What do you want to read today?
Formating Rules for Connection Strings
Written by Mark Lurade
As a string, there are no built in checks or constraints on how to format the connection string. This article walks through the basic rules for creating a connection string that will work.
Connection Strings Explained
Written by Sebastian Affakes
Connection strings can be a bit obscure and is not often defined in a consistent way. This article straighten things out and sheds some light on how connection strings are used to connect an application to a data source.
SQL Server Data Types Reference
Written by Max Wikström
Do you know exactly every data type in SQL Server and their usage and storage requirements? If not, look them all up in this reference sheet.
How to define wich network protocol to use when connecting to SQL Server
Written by Sebastian Affakes
To explicit define the network protcol to use when connecting to an SQL Server gives you more control over your connection. This is a nifty guide for doing that.
All SQL Server SqlConnection properties
Written by Sebastian Affakes
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
Written by Sebastian Affakes
The SQL Native Client should only be used in certain contexts. This is the definition of when to use it, and when not to.
Open a password-protected Excel workbook
Written by Jon Seidel
This article explains a workaround for the "could not decrypt file" error when trying to open a password-protected Excel workbook.
Suggestions or comments on this content? Want to submit an article?
Send an e-mail to
Send an e-mail to