Query Profiling on Azure SQL
[Azure SQL](https://azure.microsoft.com/en-us/services/sql-database/?v=16.50" target="_blank) is one of the most valuable Platform as…
Topic
SQL Server
Solve "A network related..." connection error for SQL2000
What? Did I read this right? Did he say SQL2000? Well, my friends, you're absolutely right. I jumped into a wormhole back…
Execute SQL Query with PowerShell
Scripting is very powerful. And for me, one of the best scripting languages is PowerShell (PoSH). Yes, PoSH takes a bit of getting used…
Create SQL Login with Powershell and T-SQL
If you ever have the need to create a number of logins and users for a specific database(s) programmatically, then the following scripts…
Fixing error: "Cannot generate SSPI context" after changing SQL service account
Everyone knows that it is good practice to use a domain or service account to run the SQL service. I’m sure you do…
NLog with SQL Server and MVC 4
NLog is a great open-source logging tool that allows developers to easily and efficiently implement custom logging. Nlog can be configured to log to…