Untangle SQL Server connection strings Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools.

Creating SQL Stored Procedures via SQL Server is easier than you might have originally thought, so let us explain what to do.

By querying these dynamic management views using a query similar to the one shown below you can see all of the indexes which the SQL Server recommends creating. Do NOT simply create these indexes.

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...