David Fowler and Adrian Buckman, two database nerds who love nothing more than to spend their time, reading about, researching and sharing all things SQL Server.

David is a DBA with over 15 years production experience of SQL Server, from version 6.5 through to 2016. He has worked in a number of different settings and is currently the technical lead at one of the largest software companies in the UK.

After working in the motor trade for over 11 years Adrian decided to give it all up to persue a dream of working in I.T. Adrian has over 3 years of experience working with SQL server and loves all things SQL, Adrian currently works as a Database Administrator for one of the UK’s Largest Software Companies.

The SQL Agents’ view of SQL Server

by davidfowler-42596

SQL Undercover

I recently came across a really odd issue with the SQL Agent, there were two agent jobs attached to one...

2018-10-11 (first published: 2018-10-02)

2,859 reads

Inspector V1.2 now available

by davidfowler-42596

SQL Undercover

It has been long overdue but finally V1.2 is now available on GitHub.
V1.2 brings a lot of changes, We put...

2018-10-10

370 reads

Inspector V1.2 revised installation guide

by davidfowler-42596

SQL Undercover

Pre-requisites:
SQL 2012 or higher

SQL Server Agent

A database to store the the data collected by the agent jobs (this can be...

2018-10-10

296 reads

sp_translate, A Universal Translator in SQL Server. Just One Example Of How Powerful the Python/SQL Partnership Can Be.

by davidfowler-42596

SQL Undercover

In my recent post, Installing External Modules into SQL Server’s Python I had a look at just how simple it is to...

2018-09-18

580 reads

TSQL Tuesday #106: Triggers and the Spiral To Oblivion

by davidfowler-42596

SQL Undercover

It’s the second Tuesday of the month which must mean only one thing…
We’re all skint and payday feels like a...

2018-09-11

282 reads

Podcast Audio Now On SoundCloud

by davidfowler-42596

SQL Undercover

For those of you who don’t have time to watch the videos, the audio stream of our webcasts are now...

2018-09-05

299 reads

Installing External Modules into SQL Server’s Python

by davidfowler-42596

SQL Undercover

So Microsoft have integrated Python into SQL Server, from the moment I heard that I thought to myself, “wow, this...

2018-09-03

358 reads

Undercover TV- Episode 2

by davidfowler-42596

SQL Undercover

The latest webcast from SQLUndercover.com. In this episode David and Adrian take a look at a few blog posts that have caught...

2018-08-29

378 reads

Undercover Catalogue 0.1 Released

by davidfowler-42596

SQL Undercover

Easily Keep Track of All Your SQL Servers
We know what it’s like when you’ve got 101 SQL Servers to manage,...

2018-08-28

280 reads

SQL Server Encryption, What’s The Key Hierarchy All About?

by davidfowler-42596

SQL Undercover

I’m sure that we all know that SQL Server includes all sorts of interesting functionality to allow us to encrypt...

2018-08-27 (first published: 2018-08-09)

1,845 reads

Blogs

Database AI Agents: The Read-Only Rule

Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...

Creating a SQL Stored Procedure to Load a SCD2

By DataOnWheels

This is a blog that I am writing for future me and hopefully it’ll...

Funny Money: #SQLNewBlogger

While wandering around the documentation looking for some Question of the Day topics, I...

Read the latest Blogs

Forums

Backup Availability Group

Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...

How Do the Experts Become Experts?

By Kathi Kellenberger

Comments posted to this topic are about the item How Do the Experts Become...

Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment

By Massimo Preitano

Comments posted to this topic are about the item Stairway to Reliable Database Deployments...

Visit the forum

Question of the Day

Secure Communications

As of June 2026, what is the best version of TLS to use with SQL Server?

See possible answers