Explore SQL Server on Experts Exchange

Expert Solutions for Your Tech Problems

SQL ServerMicrosoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Se...

Read more
  • 166K Content
  • 16K Contributors

Expert Spotlight
Tomas Helgi JohannssonDatabase Administrator / Software Engineer

Over 20 years of experience as an Application Architect/Developer, a Database Administrator, and a PM focusing on performance.

Troubleshooting Solution

Get data based on a week from a SQL table

byRIAS
44
Hello,
Any suggestions on a Stored Procedure to get data for a week , starting from Monday to …
Article

SQL Server Calendar Table

28
A demonstration of SQL Server T-SQL script that will build a calendar table, and demonstrate ways to easily query it to perform what would otherwise be complex date expressions.
Article

Add Security Protections for Data Extraction

The Get & Transform Data Wizard in Excel is a powerful tool. It allows the users to extract the data from the connected sources. But by delegating the privilege to users to access the connected sources, how could we ensure there is at least some degree of security is in place?
Video
Post

I'm glad to see Liquidweb is a new topic here. They have …

I'm glad to see Liquidweb is a new topic here. They have been my web host of choice since about 2008…
Video
Video
Video
Post

The Course of the Month for May: Comp TIA A+!  Prepare for …

The Course of the Month for May: Comp TIA A+!
Prepare for the 220-901 & 220-902 exams in the month…
Video
Video
Video
Troubleshooting Solution

Powershell help for creating accounts

byAckles
284
Hello Experts,
I need help with the below :

#Requires -Module ActiveDirectory # Utility …
Video
Video
Video
Troubleshooting Solution

Powershell issue during SQL database "bak" file restore.

19
Hi

I am trying to run powershell script to restore SQL database.

However, when I executed that …
Article

AutoComplete feature with ASP.NET and SQL Server

One of my friends recently asked me how to do an AutoComplete feature. I thought it was easy and there are already a lot of examples online. But I wish to provide him with a working solution instead of providing links. And in this article, I will explain the steps that I used to build that solution.
Troubleshooting Solution

How can I upgrade from SQL Server 2008R2 to SQL Server 2017?

16
We currently run SQL Server 2008R2 on a Windows 7 computer with 16GB of RAM and are being forced to …
Troubleshooting Solution

Need to delete a MS SQL Server row that displays as #Deleted

19
I have migrated a MS Access table to MS SQL Server 2017.  This table is now linked to my MS Access …

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more