Nine chapters of my data architecture book are available

As I have mentioned in prior blog posts, I have been writing a data architecture book, which I started last November. The title of the book is “Deciphering Data...

A Decade of Dedication – Celebrating 10 Years in Business

I am overjoyed to announce a momentous occasion – we have officially reached the remarkable milestone of being in business for 10 years! This incredible journey began with a...

A New Word: Merrenness

merrenness – n. the lulling isolation of driving late at night – floating through the void in an otherworldly hum, trailing red jewels in the darkness, your high beams...

One job to rule them all

Three batch jobs that run all night.Seven for the DBAs to maintain and protect.Nine quick little jobs run by the ... Continue reading

Getting list of protocols enabled in a SQL Server instance

protocols enabled in a SQL Server instance

There are number of ways you can find out what protocols are enable in a SQL Server...

Finding Analogies with AI

I saw this article on using AI to help that included a few prompts. I decided to try one. This is part of a series of experiments with the...

Restore with Standby–#SQLNewBlogger

A customer had a question about restoring with standby, so I wrote a quick post to explain how this works. Another post for me that is simple and hopefully...

Remotely Check Disks Space, Find Large Files and Remove Old Files - PowerShell

Remotely Check Disks Space, Find Large Files and Remove Old Files - PowerShell

 For a very important client, I currently manage over 200 SQL...

Chicago Database DevOps in a Day Workshop

I’m heading to Chicago today for the Redgate Database DevOps in a Day workshops. This is the first of many on the US tour. I’ll be at 5 of...

Quickly Creating a tsqlt Test for a Query

One of the things that I feel is important to building better software is testing your code. It should be easy and simple to test code and determine if...