Cleaning Up NA Values

Running Powershell Scripts – #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. When you install Windows, by default, the execution...

Changing Algorithms

Great Writers Get Hired

Steve thinks one of the ways you can stand out with your resume or CV is by writing well and attracting the attention of hiring managers.

Backwards Compatible Symmetric Keys in SQL Server 2017+

I discovered recently that there was a change made in SQL Server 2017 to the way that symmetric key passphrases are hashed. There’s a KB article that notes the...

CHOOSing a value

Quick Security Mistakes

Steve reminds you to be careful of taking shortcuts, as these can compromise security. Automation and DevOps might help you avoid mistakes.

The Art of Commenting

This week Steve talks about the ways in which comments are important in our code.

Default Schemas

The Time to Patch

Microsoft has spent years working on building a reliable and dependable patch process for their software. While some products have had more sporadic updates, SQL Server has moved to a fairly regular schedule. Not quite a predictable "Patch Tuesday" schedule, but you can count on a CU arriving every month or two for SQL Server. […]