SQL Server Autogrowth Settings Changes

Today, I want to discuss a topic that has been a bit of a headache for database administrators and consultants: the changes to SQL...

THAT Conference 2024–Austin

This week I attended THAT Conference in Round Rock, just outside Austin, Texas. This was my second time attending the conference, which is a very unique. The conference runs...

sp_snapshot – The easy way to take database snapshots of one of more databases – Version 2.0

Presenting you with an updated version of our sp_snapshot procedure, to easily create database snapshots. This new version adds more flexibility to the procedure, allowing you to specify the...

Query Store: How to open multiple instances of the 'Tracked Queries' dashboard

At the beginning of this week, I shared how you can Search for queries with Query Store GUI .
Today I want to share something, Query Store related, that bugged...

Exploring the Spark Connect gRPC API more

All Spark Connect Posts
Code
Goal of this post In this post we will continue looking at the gRPC API and the AnalyzePlan method which takes a plan and analyzes it....

DBAs, Give Git a Try – Getting Started

One of the really interesting things over the last decade is both the rise of Git as the main VCS system for most projects, and the number of people...

BI Training with Eugene Meidinger

I’ve known Eugene Meidinger (SQLGene) for a number of years and we share a lot of interests outside of technology. We’re both avid boardgame and card game players, though...

How to Find Where Your Databases Reside In The File System

How to Find Where Your Databases Reside In The File System

SQL Script:

Copy

/*
RETURNS LIST OF FOLDER NAMES WHERE SQL SERVER DATABASE
FILES ARE STORED.

It is dynamic...

Understanding and Using xp_sqlagent_enum_jobs in SQL Server

Understanding and Using xp_sqlagent_enum_jobs in SQL Server

What is xp_sqlagent_enum_jobs?

xp_sqlagent_enum_jobs is an undocumented, extended stored procedure in Microsoft SQL Server. It is used to provide information about the jobs that are...

Darling Data SQL Server Stored Procs in Azure SQL Database

Erik Darling, founder of Darling Data, has created these fantastic stored procedures to query SQL Server more efficiently to get health, log, or performance information. I will go through...