DBA Unfiltered

  • Airport traveler using biometric scan; signs read DEPARTURES, GATE B3, BIOMETRIC SCAN, IDENTITY VERIFIED

    A DBA’s Take On Microsoft Entra ID And More

    As a DBA with on-prem and cloud experience, I feel confident in saying that I’m fairly well versed on the “DBA Domain” part of the shared responsibility model. However, if we really want to do our jobs right as data professionals, having an understanding of the entire infrastructure does wonders when it comes to making…

    Jordan Boich
  • PowerShell displays Connect-AzAccount and Get-AzVM results for Azure virtual machines

    Using Azure Cloud Shell To Manage Resources

    As a DBA or any data professional, it is becoming more valuable and vital to have a well rounded understanding of your data estate and environment. However, sometimes it can be a bit cumbersome, especially when connecting to Azure resources via PowerShell. You have to fumble with authentication, connection cmdlets and more, which can be…

    Jordan Boich

  • Navigating SQL Server 2022 CLR Restrictions: A Step-by-Step Guide to Signing Assemblies with a Public-Private Key Pair

    SQL Server 2022 introduces several enhancements to improve the security and performance of CLR (Common Language Runtime) assemblies. While these updates, like CLR Strict Security, make SQL Server safer by default, they can also complicate workflows for developers accustomed to older versions. One key change is the requirement for assemblies to be signed with a…

    Jordan Boich