top of page
Subscribe for New Posts.


Automatic SQL Patch Metadata - Scrape it off my shoe.
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...
Feb 276 min read


Azure VMs Constrained CPU - Hidden in plain sight, can you reduce your SQL License bill?
Ah, SQL, CPUs and licenses... you've got to love it. Our SQL servers have specific loads, patterns and resource requirements. We've...
Jan 93 min read


Azure Database Watcher - Every Breath you take, every move you make...
Monitoring can be expensive...really expensive. And while there are open source options available (shameless self promotion here for a...
Nov 7, 20248 min read


Constrained Delegation and Power BI Gateway SSO or SSRS - Delegation... oooo..ooo delegation, it's what we need...
Ah, the elderly parent, the old warhorse SQL Server Reporting Services, and the young(ish) upstart Power BI and its On Premises Data...
Oct 7, 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 16, 20244 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),...
Sep 4, 20246 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 19, 20247 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...
Aug 5, 20245 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...
Jul 15, 20246 min read


SQL Auditing. Guilty as charged! Or not, as the case may be.
This is a finger pointing situation that i've witnessed in the past regarding native SQL Auditing, and the potential for edge case false...
Jun 12, 20244 min read
FEATURED POST
bottom of page