In this post I cover ANSI_NULLS and QUOTED_IDENTIFIER, two potentially dangerous SET options that stored procedures inherit from your session when created. Intro You might have noticed when scripting out …

This is a brief post showing how to migrate the sa password to another SQL Server instance without knowing it. Backstory I recently had to tear down an instance and …

In this post I go over the process of using Certum’s open source code signing certificate to code sign PowerShell scripts. Why code-sign? In my case, to help anyone who …

This post demos a script I put together to help move SQL Server database files to another drive and folder by generating PowerShell and T-SQL commands. I’ve decided to make …

In this post I clarify some misconceptions that I’ve seen regarding how SQL Server accesses files and potential file access denied errors. Intro This is one of those things that’s …

This is a brief post about fixing the “msoledbsql.msi feature resource unavailable” error when repairing or reinstalling SQL Server. The error I’ve recently had to do a repair of the …

In this post I’ll go over the steps to repair a SQL Server instance, via both GUI and PowerShell, and when you might need to do it. I’d also like …

In this post I demo and explain a few variations of basic SQL injection using PowerShell and SQL Server, while also showing how to address it. What is SQL injection? …

In this post I’ll go over some examples of how to parse text log files with PowerShell, specifically my blog’s raw access log from cPanel. Access log file structure Each …