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.

A Bug in ‘Move All Your SQL Database and Log Files in Bulk’

by davidfowler-42596

SQL Undercover

It looks like we had a bug the in the SQL script in Move All Your SQL Database and Log Files in Bulk. No worries though, it’s all been fixed...

2020-04-22

17 reads

T-SQL Tuesday #124 Query Store and Spin Locks #tsql2sday

by davidfowler-42596

SQL Undercover

This month’s T-SQL Tuesday invitation comes from Tracy Boggiano and she’s asking us to write about our experiences with Query Store. I thought about what I should write, I’m...

2020-03-17 (first published: 2020-03-10)

337 reads

Undercover Tools: February Updates and Change Log

by davidfowler-42596

SQL Undercover

Below is the February list of changes and updates to the Undercover Tools. Undercover Catalogue Update 0.4.2Two new modules were added to the Catalogue. Trace Flags – Capture trace...

2020-03-02

22 reads

SOS_SCHEDULER_YIELD – What is it really telling us?

by davidfowler-42596

SQL Undercover

I decided to write this off the back of a conversation I was having the other day around the SOS_SCHEDULER_YIELD wait type. The conversation went something along the lines...

2020-02-26

133 reads

SQL Undercover TV – Instant File Initialisation

by davidfowler-42596

SQL Undercover

Adrian has a look at the performance benefits of instant file initialisation Below is Ade’s auto growth script…

2020-02-17

35 reads

Installing and Configuring the Undercover Catalogue

by davidfowler-42596

SQL Undercover

Quick video showing you how to install and configure the SQL Undercover Catalogue

2020-02-04

29 reads

Inspector 2.1 now available

by davidfowler-42596

SQL Undercover

As always all updates can be found on our Github repo Breaking changes (Powershell collection): We only test the powershell collection against 2-3 servers so please test carefully before...

2020-02-03

35 reads

Undercover Tools: January Updates and Change Log

by davidfowler-42596

SQL Undercover

Below is the January list of changes and updates to the Undercover Tools. Undercover Catalogue Update 0.4.0Major upgrade, see https://sqlundercover.com/2020/01/06/undercover-catalogue-0-4-0-released/ for full details Update 0.4.1ServerConfig module added, detailing settings...

2020-02-03

22 reads