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
Máté FarkasSQL Server Consultant

Database Expert with 15+ years experience (SQL, Access, Power BI).

Solution

SQL Connection Attribute error

55
I have 2 sql servers running on my Server, 2008 and 2016,  I connect to the 2008 on a regular basis …
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.
Video
Executing a SQL Server Stored Procedure from Within Access

Executing a SQL Server Stored Procedure from Within Access

6
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft …
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…
Solution

Powershell help for creating accounts

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

#Requires -Module ActiveDirectory # Utility …
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…
Solution

Need some help with "empty" field and <>

13
Hallo,
I need some help with a column.
Usually in column FMIDNr is a number like 2020.0702.40318
Solution

SQL Server Restore: Closed Restore Window before Restore was Complete.  Did I interrupt the restore?

15
SQL Server restore of a large BAK  (1.5 TB).   I started it just fine in SSMS but accidentally …
Solution

Nest CASE statements in SELECT statement

14
Hi Experts,


I have tow fields 'Product' and 'Type' that could have NULL values.  So if Product …
Solution

Reclaim Space on the C DRIVE from the MS SQL installation

11
I am running Windows Server Essentials 2012

My C Partition has 58GB used of 60GB

This space …
Solution

Need to identify only columns that have all NULL values in a row per each table in a database.

32
I want to take a SQL Server database - list out only the tables that have columns with null values …
Article
SA

Deny SA account for Developers in Microsoft SQL Server

This article shows how to force SQL and Web Developers to not use SA account while other services are already deployed to connect to SQL Server via SA account. So we will not touch existing services and applications only developers must be prevented.
Article

How to load JSON's data into SQL Server in different ways

Data can be kept in different media, Sometimes, the data need to be extracted, transformed or loaded in different ways. For this article, I'm going to demonstrate some of the popular ways of importing JSON data into MS SQL Server.
Article

Storage savings with Microsoft SQL Server

This article shows how to use different types of data compression in SQL Server and they drawbacks.
Solution

SQL server migration assistand does not see ODBC driver

14
I am trying to import data from MySQL to MSSQL using SQL server migration assistant for MySQL.

Solution

Moving Access to Azure

25
I'm considering setting up SQL Server for my MS Access application. A colleague suggested moving the…
Solution

The result of a qry as a wry

30
I am using sql 2014....I have created a sql statement has the results...
This actually appears in …
Solution

Datetime Field Overflow error occurs after upgrading from SQL Server 2008 to SQL Server 2016.

19
Datetime field overflow after updating SQL Serve 2008 to SQL Server 2016

Background:
I have a …
Solution

How do I query JSON file from MSSQL

22
How can I query a json file of this format

if yuo notice this has this status header I want to …
Solution

Why i can't install dbatools

17
Hi Expert,
Why i can't install Install-Module -Name DBATools


Install-Module : The term …

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more