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.

How to connect .NET Core Console application to SQL server database and read table data. This blogpost explains how to connect .NET Core Console application to SQL server database and read table data.

I'm trying to add to a table in SQL Server by creating a connection in VB.NET. The table has very many columns. I can currently open the connection and ...

Well, optimization of SQL in general and VB/SQL (ADO.NET) apps in particular is a huge topic. There is quite a bit on MSDN if you search for it, including some information aimed directly at VB/C# ...