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.

Take advantage of user secrets management in ASP.NET Core to prevent the sharing of sensitive application data in your projects When working with ASP.NET web applications, you will want to protect ...

SQL Server 2016 lets you treat JSON objects like rows in a table, allowing you to use data from AJAX queries in joins, updates and any other SQL statement you can think of. SQL Server 2016 provides ...

Rather than try to ensure that he's getting the right config file for his production and test systems, Peter Vogel lets the application configure itself, using the Managed Extensibility Framework to ...

I think storing images in a database can save a developer loads of time and can ease his life while dealing with visuals, either creating a local application or a web application. Think of storing ...