top of page
Sep 16, 20244 min read
SSIS with SQL Always Encrypted Data. It's Integrated Jim, but not as we know it.
This is part 3 in the SQL Always Encrypted mini series... Unfortunately, the gotchas continue, as it isn't straight forward when using...
Sep 4, 20246 min read
Power BI with SQL Always Encrypted Data. Database Connectivity...Open you say?
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),...
Aug 19, 20247 min read
SQL Always Encrypted with Azure Key Vault - Lock up your data!
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...
Aug 5, 20245 min read
SQL Server Avengers: CPU Affinity War
Maybe not the best entry in the franchise, but this is another one of those configuration options that has been around forever, but very...
Jul 15, 20246 min read
Statistics IO. IO... IO... it's off to parse we go.
Again, this is another one of those little bits of functionality that has been present since year dot. Unfortunately, it seems to be...
May 15, 20246 min read
Partitioned Views, a blast from the Past?
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...
Feb 13, 202412 min read
Checking SQL Server Estate Connectivity with Powershell Jobs...parallel technicolour.
In my previous post Running Powershell for SQL Use* in Parallel - POshRBAR no more. (sqlrod.com) , I discussed the use of powershell...
Jan 30, 20245 min read
Running Powershell for SQL Use* in Parallel - POshRBAR no more.
*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...
bottom of page