SQL Server is one of the best products to come out of Microsoft, but not every professional knows how to use it effectively. For example, some might find it difficult to create a stored procedure but ...

Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools. To provide an example using real source, I created a simple Winforms ...

SQL Server Management Studio or SSMS allows you to connect to the SQL server and execute queries. In this tutorial, we will see how you can install and configure SQL Server Management Studio in ...

A step-by-step guide to using SAN-less failover clustering software to support SQL Server’s Always On Failover Clustering in the public cloud The thing about clouds is that they can change shape even ...

There are lots of ways to handle databases in a containerized environment like Docker. Here's how to create SQL Server in a container, how to load it with the data you want and how to integrate that ...

Storage and performance can be quite different in the cloud. It's important to choose the right VM size and configure your storage properly to keep SQL Server workloads running smoothly. Microsoft ...

When in March this year Microsoft announced that it was bringing SQL Server to Linux the reaction was one of surprise, with the announcement prompting two big questions: why and how? SQL Server is one ...

The three features of adaptive query processing can make SQL Server 2017 significantly faster at processing your workload. Not only that, but they also provide significant improvements without needing ...

In my last column (published in the February e-edition and the March print edition of DBTA), I reviewed the overall coding landscape for SQL Server with special focus on LINQ to SQL, a new technology ...

New BI and reporting features in SQL Server 2008 R2 hit the mark, but other additions leave SQL Server shops wanting more With Microsoft SQL Server 2008 R2, Microsoft begins to fully realize its ...

A conference being held in Denver this week by the Professional Association for SQL Server user group will provide a forum for the biggest public unveiling to date of Microsoft Corp.’s SQL Server 2008 ...