-
An Azure Landing Zone a DBA Can Read
Before any VM, Azure needs a network: a VNet, subnets, firewalls and a route table. Here’s how I built mine, and the rule that almost made my firewall useless.
-
Don’t Break the House: Safety Nets Before Stretching My AG to Azure
Before touching Azure, I made sure nothing could take down my home Wi-Fi: an isolated lab network, checkpoints, and a subscription of its own.
-
Beyond Port 1433: a DBA learns the network by stretching an AG to Azure
Part 0 of the Beyond Port 1433 series. Start here. Every IT person has lived this outage: the app is down, the database team says the database is fine, the network team says the network is fine, and infrastructure team says the DCs are fine. Everyone is right, and the app is still down. The…
-
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…
-
So Your Boss Asked If You Should Move to the Cloud
More and more organizations are making the decision to move their data and infrastructure into a public cloud provider. If you’re in the position where you need to provide the insight to determine if going to the cloud is the right move for you or not, then it is crucial to be as educated as…
-
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…
-
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…
-
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…
-
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…
-
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…
-
Subscribe
Subscribed
Have a WordPress.com account? Log in now.
