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.

old-vintage-polaroid-camera-with-photos-and-a-bag

Get All Database Snapshots and Their Parent Databases On A SQL Server

by davidfowler-42596

SQL Undercover

This is going to be a quick post but this morning I was asked the question, ‘how can I get the name of all the database snapshots on a...

2019-08-15

188 reads

sp_RestoreScript 1.5 Release

by davidfowler-42596

SQL Undercover

We’ve released sp_RestoreScript 1.5. This is only a minor release but adds the type of the backup file to the output. You can grab the latest version from our...

2019-08-12

18 reads

Intent Locks In SQL Server

by davidfowler-42596

SQL Undercover

Intent locks, one of those things in SQL Server that seem to be very often misunderstood. They’re something that I’ve found myself explaining time and time again, I’ve even...

2019-07-25

663 reads

Drawing of man hammering shapes with a mallet

Error: ‘misaligned log IOs which required falling back to synchronous IO’ And Slow AG Synchronisation

by davidfowler-42596

SQL Undercover

I recently hit this rather interesting issue when migrating a bunch of SQL Servers onto a nice, shiny new SAN. The plan was simple enough, take the secondary servers...

2019-07-22 (first published: 2019-07-08)

2,778 reads

sp_drivespace – See How Much Space You Have On Your Disks, Including Mount Points

by davidfowler-42596

SQL Undercover

We love xp_fixeddrives here, it’s a quick and simple way to see how much space you’ve got available on your drives. But there are just a couple of things...

2019-07-17 (first published: 2019-07-03)

832 reads

sp_RestoreScript v1.4 – It’s Now Compatible with Case Sensitive Collations, Accepts Wild Cards in DB Names and Fixes A bug

by davidfowler-42596

SQL Undercover

sp_RestoreScript 1.4 is now out and ready for download from our GitHub, https://github.com/SQLUndercover/UndercoverToolbox/blob/master/sp_restorescript.sql New Features Compatible with case sensitive collations Now accepts wild cards in the @DatabaseName string, (‘Database1,Database2,SQL%’)...

2019-07-15

225 reads

Undercover Catalogue 0.2 Hox Fix 2 and SQL2008r2/2008/possibly 2005 Compatibility Patch RELEASED

by davidfowler-42596

SQL Undercover

Undercover Catalogue 0.2.2 It looks like a bug has crept it’s way into the Undercover Catalogue. When running with certain versions of DBA Tools, a number of the modules...

2019-06-20

21 reads

To use ALTER DATABASE, the database must be in a writable state in which a checkpoint can be executed. – when moving files on an Availability Group secondary.

by davidfowler-42596

SQL Undercover

Here’s a little error that I stumbled across the other day when trying to migrate the data files of an Availability Group secondary node onto a nice new SAN....

2019-06-06

153 reads

Inspector V1.4 now available

by davidfowler-42596

SQL Undercover

The SQL Installation script can be found here The Inspector sample report has been updated here All of the below Git Issues can be found on the V1.4 Project...

2019-05-20

24 reads

Is Your Availability Group ‘REALLY’ Ready To Failover?

by davidfowler-42596

SQL Undercover

You know what it’s like, you need to fail your AG over but is it safe to fail over? Perhaps you’ve clicked on ‘failover’ for the AG and there’s...

2019-05-09 (first published: 2019-04-29)

858 reads

All authors

Get All Database Snapshots and Their Parent Databases On A SQL Server

sp_RestoreScript 1.5 Release

Intent Locks In SQL Server

Error: ‘misaligned log IOs which required falling back to synchronous IO’ And Slow AG Synchronisation

sp_drivespace – See How Much Space You Have On Your Disks, Including Mount Points

sp_RestoreScript v1.4 – It’s Now Compatible with Case Sensitive Collations, Accepts Wild Cards in DB Names and Fixes A bug

Undercover Catalogue 0.2 Hox Fix 2 and SQL2008r2/2008/possibly 2005 Compatibility Patch RELEASED

To use ALTER DATABASE, the database must be in a writable state in which a checkpoint can be executed. – when moving files on an Availability Group secondary.

Inspector V1.4 now available

Is Your Availability Group ‘REALLY’ Ready To Failover?

Blogs

AI Helps Me with My Sloppiness

WITH clause gets a 26ai boost!

Automatic Index Compaction

Forums

SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About

ALAMAT KONTAK BCA KCU PONTIANAK Telp,Cs:08218154393

ALAMAT KONTAK BCA KCU BALIKPAPAN Telp,Cs:08218154393

Question of the Day

Getting the Average