Finding Identity Columns–#SQLNewBlogger

I had to find a set of identity columns recently and through this would make a good blog post. Another post for me that is simple and hopefully serves...

Using Secrets in Docker Swarm for SQL Server

In a previous post I went through how to run SQL Server in Docker Swarm and in this post I want to continue delving into the Docker Swarm platform...

Disable Activity is Finally Available in Azure Data Factory!

Since I first used Azure Data Factory, I looked for the 'disable' option on an activity, and it wasn't there! I quickly went to the ideas...

Creating and Configuring a Power BI VNet Data Gateway

If you are using Power BI to connect to a PaaS resource on a virtual network in Azure (including private endpoints), you need a data gateway. While you can...

Reflections on the Software Industry

Every now and then we like to have someone do a guest post, with a topic of their own choosing. This time, we picked Kevin Miller (LI). Kevin is...

I’m speaking at the Data Saturday Holland!

As you may have noticed, the agenda for Data Saturday Holland was recently published. I’m delighted to share that I will be conducting a full-day precon on October 7,...

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: What Do All The Database Job Titles Actually Mean?

It’s an honor to host this month’s T-SQL Tuesday. In case you don’t know the rules already, here is a recap of them: Earlier this year, when I was...

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,...

Getting a Summary of Changes in SQL Compare 15

A client asked for a summary of changes, so I wrote this quick post to show where to find this in SQL Compare 15. If you use SQL Compare,...