A New Word: Tarrion

tarrion – n. an odd interval of blankness you feel after something big happens to you bt before you feel the resulting emotional reaction – stunned by a sudden...

Azure Function App doesn’t retrieve most recent secret value from Azure Key Vault

Quite a long title for quite an annoying issue. Let me explain the set-up first: I have pipelines running in Azure Data Factory and I want to send e-mails...

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