Friday Flyway Tips–Navigating in Flyway Desktop

Flyway Desktop changed the navigation and a few people were surprised. I was as well, so I decided to do a short tip on the changes. This is part...

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

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

Fabulous Stuff in Fabric – Part 4: The Office365 Outlook Activity

A while ago I had a little blog post series about cool stuff in Snowflake. I’m doing a similar series now, but this time for Microsoft Fabric. I’m not going...

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

SQL Saturday ATL – BI Recap

First of all, wow! What an incredible event! Loved seeing everyone and meeting so many wonderful new people. Thank you to everyone who organized, spoke, and attended this event!...

T-SQL Tuesday #171–Helping a Customer Fix Something

It’s that time of the month for a new blog party at T-SQL Tuesday. This month we have Brent Ozar hosing, and it’s a good topic. I wondered what...

The Docker debug command

In the latest version of Docker Desktop a new command has been included call docker debug. Now this is only available with a Pro Docker licence but it’s an...

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

Last Weeks Reading (2024-02-11)

📰 News Power BI Project (PBIP) and Azure DevOps build pipelines for continuous integration Integrating the PBIP format with Azure DevOps lets you use Azure Pipelines to automate CI/CD...