Adding Copilot to Azure Data Studio and a Few Experiments

As a part of a recent Data Exposed that I was on, there was an ADS update which mentioned Copilot being added. Since I’ve been experimented, I decided to...

Appalachian State Cyber Summit – September 8, 2023

Looking to attend a security summit in cooler weather that will benefit students? Applachian State holds an annual cybersecurity summit and this year it is scheduled for September 8,...

A Basic SQL Script to Monitor Long Running SQL Server Agent Jobs

A Basic SQL Script to Monitor Long Running SQL Server Agent Jobs

 As a SQL Server DBA, especially Production/Operations DBA in a relatively large environment,...

How To Identify The Grain

Creating a data warehouse can be challenging. Identifying the grain is one of the most important parts of having a quality data...

Searching for People

Inside Redgate Software, someone posted a picture and was asking if anyone knew who the person was. In this case, there had been a conversation at an event, and...

SQL Homework – August 2023 – Have the best practices changed while you weren’t looking?

It’s been a bit since I did one of these so let’s go back to the basics. Best practices. We ... Continue reading

T-SQL Tuesday #165: Database Job Titles Roundup

This month I prompted bloggers to talk about what database job titles mean to them. Thank you to all who posted on this topic! Don’t worry; if you still...

Fill Out The State of the Database Landscape Survey and Maybe Win

If you’re like me, you sometimes wonder how different other environments are from the one I work in. Well, the ones I used to work in. These days I...

SQL Server Patching

Why should you patch your SQL Server instances? Compliance, stability, security, reliability, functionality, and more. Microsoft regularly releases updates to SQL Server known as Cumulative Updates (CUs). Cumulative updates...

Running SQL Server in Docker Swarm

I haven’t touched Docker Swarm for a looooong time but I was asked about running SQL Server in Swarm at a conference a while back…so here’s how it can...