Blogs

Is Blogging Still Relevant in 2026

Why are blogs still relevant? Or are they still relevant? That is the T-SQL Tuesday topic from Jeff Iannucci and here are my thoughts. Blogging is an easier point of entry than making videos. Learning writing skills is part of education in most …

Continue reading

Building a SQL Server 2025 Lab on Linux Part 3: Installing SQL Server and Creating the Windows Cluster

In parts 1 and 2, we laid the foundation for a SQLLab. We figured out how to use virt-manager to create a Windows Server 2025 lab copmposed of 4 virtual machines on a Linux Mint host. Here is what I built. Machine IP Address Purpose DC01 …

Continue reading

How to make generating blog post stubs easier in Hugo

When I migrated my blog to Hugo, I organized posts into dated folders. Each folder contains an index.md file and an images directory. That structure works well, but creating those directories and files manually for every post gets repetitive and …

Continue reading

Building a SQL Server 2025 Lab on Linux Part 2

In part 1 I described laying the foundation for the lab. This post will describe building the Windows domain controller and other machines on my Linux Mint host. My goal was to have a realistic, production-like configuration. As a result, I wanted a …

Continue reading

Building a SQL Server 2025 Lab On Linux Part 1

Building a foundation for a Windows SQL Server lab on Linux First of all, this will be a blog post series. There is simply too much to cover in one blog post and expect people to read it. This blog post is going to be about how I laid the foundation …

Continue reading

Goodbye WordPress: How I migrated to Hugo and Azure Static Web Apps

I started blogging back in 2015. At first, I was fairly consistent, but as I’ve learned from other bloggers, posting has seasons where writing comes easy and others where life and other things just get in the way. For me, I did ok until 2022 and then …

Continue reading

Fixing Missing SQL Agent Jobs After a Migration

 I’ve been doing migrations fairly continuously for the past 18 months. PowerShell has been my primary mechanism for many parts of the process, including copying jobs from the source SQL Server to the target. That has worked almost without incident …

Continue reading

How to Check SQL Server Security Part 3

 In the previous two parts we’ve reviewed investigating logins to SQL Server, which operate at the top server level. We’ve also reviewed looking at logins at the database level. Today, I’ll be showcasing another couple of ways to view SQL Server …

Continue reading

How to Check SQL Server Security Part 2

In a previous post we started reviewing SQL Server security at the server level by looking at Logins. Is that enough though? It definitely isn’t! We need to look at the users at the database level as well. So, let’s do that. Again, the internet is …

Continue reading

Speaking at the PASS Data Community Summit

 My favorite thing that happened this year was that I was a speaker at the PASS Data Community Summit in November. I presented an online live stream at the world’s largest SQL Server conference, and I did it while in-person at the conference in …

Continue reading