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,853 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

364 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

293 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

552 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

269 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

296 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

345 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

374 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

271 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,837 reads

Blogs

Query Intelligence in SQL Server 2025: What Developers Need to Know

When Microsoft announced SQL Server 2025, I was curious about what would truly change...

Finding and Killing Blockers with Redgate AI Tech

Redgate has a research arm, called the Foundry, that has been experimenting with AIs...

Back at Small Data SF in 2025

Today I’m in San Francisco at Small Data SF 2025. I went to the...

Read the latest Blogs

Forums

Large posts full of code not allowed anymore?

Several times now, I've seen a post asking for a solution. I've replied, and...

Data > Hype

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Data > Hype

Create and Read the Analysis Services Flight Recorder

By Pablo Echeverria

Comments posted to this topic are about the item Create and Read the Analysis...

Visit the forum

Question of the Day

Slipstream parameters

What parameters are needed to enable a slipstream installation for setup.exe (SQL Server setup)?

See possible answers