Knowledge base.sql server 2000.

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.

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