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 ...

Below is a cheat sheet for creating SQL Server client connection strings and finding them in common configuration files. Connecting to instances by name, forcing a named pipes connection.

It may not be immediately obvious, but you cannot set your own connection string properties when connecting to SQL Server using the built-in SQL Server connector from either Power BI or a modern data ...

I am unable to connect to a SQL instance on a microsoft/mssql-server-windows-developer container from a microsoft/aspnet container. From the aspnet container I can ping the sql server hostname ...

We have our SQL server configured to only allow Windows accounts (i.e. not mixed). However, in some cases we are connecting from non-domain boxes and we want to specify a domain account to connect ...

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code.

By changing the string into XML, each part between the delimiters becomes a separate XML element. This method gives better control over complex delimiters, supports multi-character delimiters, and ...

I vaguely remember this topic from awhile back. Maybe I dreamt it though...How do you guys store your connection strings for ASP.Net? I currently develop on a test machine and then deploy to the ...