DBA Unfiltered

  • Technician connecting power and input AC power cables in workshop

    DBAOps Pt.2: Connecting A GitHub Repository To Azure DevOps

    In the last post, we covered setting up an AzDO organization and project that is going to support us in achieving the end goal of building a fully functional AzDO pipeline that will handle SQL Patching for an AG. Next up: Creating a GitHub repository and connecting it to our AzDO environment so we can…

    Jordan Boich
  • DBA evolving with digital technology and cloud computing icons

    DBAOps Pt.1: Setting Up AzDO Pipelines From The Ground Up

    We see talks of the DBA role evolving all of the time online. Most of it is hype, some of it is valid observations. But I don’t see many posts on the actual application and practices of what DBAs have to learn as things start to shift to more of an engineering ecosystem. In this…

    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