Knowledge base.SQL Server.
SQL Server Data Types Reference
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.
Network Protocol for SQL Server Connection
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.
All SQL Server SqlConnection Properties
There are plenty of combinations when creating an SQL Server connection string. This reference table explains each option available per keyword.
When to use the SQL Native Client
The SQL Native Client should only be used in certain contexts. This is the definition of when to use it, and when not to.
Application Name for SQL Server Connections
This optional parameter can be a life saver. The DBAs will love that you provide this info for the connection.
Download SQL Server Native Client
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.