Tag Archives: syndicated

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

Posted in Blog | Tagged , | 2 Comments

Using Parameters in #SQLPrompt

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 , , | Leave a comment

Using a PoSh variable in a string- #SQLNewBlogger

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 , , | Leave a comment

Unprepared for Travel

I’ve had a month off from travel, which has been nice. It’s been an interesting time catching up on things at home, and a nice break from the disruption to my schedule that travel entails. However, all good things come … Continue reading

Posted in Blog | Tagged , | 2 Comments