3 days ago4 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 WarMaybe not the best entry in the franchise, but this is another one of those configuration options that has been around forever, but very...
Aug 8, 20236 minSP_WHO are you..."Who who, Who who... ... I really want to know ..?" OK, we all have our servers, and that they always work absolutely magnificently, we...
Jul 18, 202313 minSQL Observation for the Nation - Part 3 - The Return of the Ping.This is the third and final post in the series "SQL Observation for the Nation". Part one can be found here: SQL Observation for the...
Jul 7, 20238 minSQL Observation for the Nation - Part 2 - The Few Towers.This is the second post in the series "SQL Observation for the Nation". Part one can be found here: https://sqlrodbloke.wixsite.com/sqlro...