Sep 164 minSSIS 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 46 minPower 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 197 minSQL 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 55 minSQL Server Avengers: CPU Affinity Warratings-display.rating-aria-label(1)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 156 minStatistics IO. IO... IO... it's off to parse we go.ratings-display.rating-aria-label(1)Again, this is another one of those little bits of functionality that has been present since year dot. Unfortunately, it seems to be...
Jun 124 minSQL 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...
May 303 minReasons to Match Datatypes #39 - Table PartitioningOk, so I may have exaggerated and jumped a few just slightly with the numbering there for effect, but they all matter. Assume a heavily...
May 284 minAzure Managed Instance SQL 2022 Update Policy. Well that potentially sucks.Ah, SQL 2022, the release that finally brought box SQL and Azure managed instance closer together. We have wonderful toys such as...
May 156 minPartitioned 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...
Apr 296 minAzure Elastic Jobs - The NonPlastic, Elastic Fantasicratings-display.rating-aria-label(1)After a lengthy period in Public Preview it seems, the boffins at Microsoft have finally pushed Elastic Jobs for SQL Azure DB to general...