DBA Unfiltered

  • Car engine bay featuring futuristic glowing components and digital displays

    Popping the Hood on Postgres Plan Caching

    Talk Is Cheap In my last post, I talked about how I was amazed that PostgreSQL doesn’t have a shared plan cache like SQL Server does. I wanted to create an experiment / lab where I could see this in action, so I built one. I’m going to be leveraging a free PostgreSQL database hosted…

    Jordan Boich
  • 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