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.

How Far Has My Update Got? Finding Out How Many Rows Your Long Running Insert, Update or Delete Has Actually Modified So Far

by davidfowler-42596

SQL Undercover

I’m pretty sure that we’ve all found ourselves in the situation where we’ve run an INSERT, UPDATE or DELETE script...

2017-10-05

186 reads

Failed to perform AlwaysOn Manual Failover using the wizard – Availability-group DDL Operations are permitted only when you are using the master database .

by davidfowler-42596

SQL Undercover

Routine maintenance rolls around and it’s time to failover your AG’s to new Primary’s to allow for patching and restarts…...

2017-10-04

315 reads

SQL Mirroring, Preserving the Log Chain During Database Migrations

by davidfowler-42596

SQL Undercover

This is a reblog of a post that I originally wrote back in January. After using this technique again last...

2017-10-03

137 reads

Concatenation Truncation – Are your strings being truncated?

by davidfowler-42596

SQL Undercover

It wasn’t until recently that i paid attention to truncation during concatenation, but that’s because whenever I used concatenation before...

2017-09-27

1,220 reads

Copying Data From One Table To Another – To Disable Indexes or Not To Disable Indexes, That’s the Question.

by davidfowler-42596

SQL Undercover

As the famous Bard once said, “To disable indexes or not to disable indexes, that is the question?”. Well maybe...

2017-09-25

169 reads

UNDERCOVER TOOLBOX: Sp_ChangeJobOwnerShip – Changing Ownership in bulk.

by davidfowler-42596

SQL Undercover

How many times have you seen SQL Agent jobs with random ownership? It can be very frustrating when you are...

2017-09-25

169 reads

UNDERCOVER TOOLBOX: sp_Snapshot – The Easy Way To Create Database Snapshots for One or Many Database

by davidfowler-42596

SQL Undercover

sp_Snapshot is a procedure that we’ve written to quickly and easily create a database snapshot of one or multiple databases.
Prerequisites
sp_Snapshot...

2017-09-20

154 reads

All authors

How Far Has My Update Got? Finding Out How Many Rows Your Long Running Insert, Update or Delete Has Actually Modified So Far

Failed to perform AlwaysOn Manual Failover using the wizard – Availability-group DDL Operations are permitted only when you are using the master database .

SQL Mirroring, Preserving the Log Chain During Database Migrations

Concatenation Truncation – Are your strings being truncated?

Copying Data From One Table To Another – To Disable Indexes or Not To Disable Indexes, That’s the Question.

UNDERCOVER TOOLBOX: Sp_ChangeJobOwnerShip – Changing Ownership in bulk.

UNDERCOVER TOOLBOX: sp_Snapshot – The Easy Way To Create Database Snapshots for One or Many Database

Blogs

Audit – Security Compliance Frameworks (Part 1)

Restore SQL Server Database to an OrbStack Container

Day of Data Baton Rouge Slides and Code

Forums

Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened

What is CPU Usage?

Limiting Checkpoints

Question of the Day

Limiting Checkpoints