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

Introduction to IaC: Deploying Data infrastructure to Azure using Terraform (Part 3 - Azure SQL Database)

In Part 1, we explain the basics and prerrequisites to work with Terraform.In Part 2, we created our first Azure resource.On this post we will create an Azure SQL...

Deneb – powerful visual for advanced reporting

Introduction
For one of our customers we needed to create customized reports that could not be easily implemented by using standard Power BI components. We explored different ways how to...

Friday Flyway Tips: More Config Options

Working with various Flyway configuration options used to be a pain since they were either CLI parameters or in a text files. We’ve made editing these easier in Flyway...