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

199 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

317 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

145 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,233 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

175 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

174 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

157 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

The Book of Redgate: Hours

How to Check TDE Progress and Elapsed Time in SQL Server

PostgreSQL Support in the Data API Builder

Forums

Squared Values

I Don't Want To Do XX

Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server

Question of the Day

Squared Values