Patching, we all know how important it is, for those of us with a presence on prem that is, or even SQL on Azure VM, without the correct...

This is part 3 in the SQL Always Encrypted mini series... Unfortunately, the gotchas continue, as it isn't straight forward when using...

In this episode, we're going to look into how we can read that Always Encrypted data (On Prem, with the Key secured by Azure Key Vault),...

Those DBAs eh? You just can't trust 'em.... Well, we know that statement is ridiculous, but there are so many cases where data in a SQL...

Maybe not the best entry in the franchise, but this is another one of those configuration options that has been around forever, but very...

Again, this is another one of those little bits of functionality that has been present since year dot. Unfortunately, it seems to be...

This post came around when I was at a loose end one evening, and just started poking at a local sandpit database, and it got me...

In my previous post Running Powershell for SQL Use* in Parallel - POshRBAR no more. (sqlrod.com) , I discussed the use of powershell...

*Or any use for that matter... This is one that I should have learnt way earlier than I actually did if i'm being completely honest. One...