Monthly Archives: December 2019

Backwards Compatible Symmetric Keys in SQL Server 2017+

Posted on December 23, 2019 by way0utwest

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 fix, but basically the passphrases used to be encrypted with SHA1. … Continue reading →

Posted in Blog | Tagged , | 2 Comments

Using Parameters in #SQLPrompt

Posted on December 20, 2019 by way0utwest

I am a big fan of snippets in SQL Prompt, often using them in demos to quickly get code written. However, I’ve liked the idea of snippets and templates for a long time. These are great time savers, and they … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Using Parameters in #SQLPrompt

Using a PoSh variable in a string- #SQLNewBlogger

Posted on December 18, 2019 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is something I haven’t quite understood or used often, but I’ve been aware of it and wanted to … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Using a PoSh variable in a string- #SQLNewBlogger

Better Protection from Hardware

Posted on December 17, 2019 by way0utwest

Microsoft is working on ways to protect your system at an even lower level than the bootloader. Many modern computers have UEFI protection, which allows for security in the boot process, and prevents untrusted code from running. This is intended … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Better Protection from Hardware