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

175 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

308 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

132 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,205 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

154 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

163 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

140 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

From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO

Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests

Adding a Local Model to Ollama through the GUI

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques

T-SQL Fundamentals

Question of the Day

PWDCompare