Knowledge base.SQL Server.

Do you know exactly every sql data type in SQL Server and their usage and storage requirements? If not, look them all up in this reference sheet.

To explicitly define which network protocol to use when connecting to an SQL Server gives you more control over your connection. This guide explains how to do that.

There are plenty of combinations when creating an SQL Server connection string. This reference table explains each option available per keyword.

The SQL Native Client should only be used in certain contexts. This is the definition of when to use it, and when not to.

This optional parameter can be a life saver. The DBAs will love that you provide this info for the connection.

Do you know exactly every sql data type in SQL Server 2000 and their usage and storage requirements? If not, look them all up in this reference sheet.

Do you know exactly every sql data type in SQL Server 2005 and their usage and storage requirements? If not, look them all up in this reference sheet.

Do you know exactly every sql data type in SQL Server 2008 and their usage and storage requirements? If not, look them all up in this reference sheet.

Do you know exactly every sql data type in SQL Server 2012 and their usage and storage requirements? If not, look them all up in this reference sheet.

There have been new versions of the Native Client ODBC and OLEDB with each new version of SQL Server. Distributed through several different "Feature Packs" it has been confusing to find the right component. This article explains, instructs and provides download links for all versions and distributions of the SQL Server Native Client.

Why did Microsoft move SqlClient to new binaries into NuGet package Microsoft.Data.SqlClient. Should I swap? Future releases? Namespaces?