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.

SQL Undercover TV – Encrypting SQL Backups

by davidfowler-42596

SQL Undercover

In this episode, David looks at how we can encrypt our SQL Server backup files

2019-11-26 (first published: 2019-11-18)

257 reads

Getting table row counts with sp_Tablecount

by davidfowler-42596

SQL Undercover

Sometimes you just want to get a quick row count for a specific table – other times you may want to see a list of tables order by size...

2019-11-06 (first published: 2019-10-30)

1,073 reads

SQL Undercover TV – Using Excel to Visualise SQL Performance Data

by davidfowler-42596

SQL Undercover

Adrian looks at how you can use Excel to visualise SQL performance data, specifically data collected by the Blitz First Responder Kit

2019-11-05

119 reads

Undercover TV Podcast – Scripting Options in SSMS

by davidfowler-42596

SQL Undercover

In this episode of the podcast, Adrian looks at the scripting options available in SSMS.

2019-10-31 (first published: 2019-10-21)

440 reads

Availability Groups and Redo Latency, Data Committed on a Primary isn’t Visible on a Synchronous Secondary

by davidfowler-42596

SQL Undercover

If you’re running availability groups it may seem like a great idea to offload your read only reporting workloads to a secondary. There are a couple of ways that...

2019-10-28 (first published: 2019-10-16)

421 reads

Finding the Primary Replica of an Availability Group

by davidfowler-42596

SQL Undercover

This is going to be a bit of a quick post but one about something that I see coming up time and time again on SQL Undercover’s search terms....

2019-10-24

1,474 reads

Undercover TV Podcast – Intent Locks

by davidfowler-42596

SQL Undercover

The first of our new series of new look podcasts, David has a look at intent locks in SQL Server and what the purpose of them is.

2019-10-18 (first published: 2019-10-14)

197 reads

We Thought That Sean McCown’s SMO Tutorial Was So Good, It Needed To Be A Video In It’s Own Right

by davidfowler-42596

SQL Undercover

Back in February, Sean McCown joined us on the Undercover podcast and presented a brilliant tutorial on the SMO. We thought that it was so good that we’ve decided...

2019-10-01

54 reads

SQL Tuesday #118 – Your Fantasy SQL Feature

by davidfowler-42596

SQL Undercover

This month’s T-SQL Tuesday invitation comes from Kevin Chant and he’s asking us about a fantasy feature that we’d love to see in SQL Server. I had a little...

2019-09-09

34 reads

sp_RestoreScript 1.6 Release – @Credential Added For Backups In Azure BLOB Storage

by davidfowler-42596

SQL Undercover

Releases seem to be coming out thick and fast at the moment, here’s the latest v1.6 revision to sp_restorescript For those of you backing up to Azure BLOB Storage,...

2019-08-29

57 reads

All authors

SQL Undercover TV – Encrypting SQL Backups

Getting table row counts with sp_Tablecount

SQL Undercover TV – Using Excel to Visualise SQL Performance Data

Undercover TV Podcast – Scripting Options in SSMS

Availability Groups and Redo Latency, Data Committed on a Primary isn’t Visible on a Synchronous Secondary

Finding the Primary Replica of an Availability Group

Undercover TV Podcast – Intent Locks

We Thought That Sean McCown’s SMO Tutorial Was So Good, It Needed To Be A Video In It’s Own Right

SQL Tuesday #118 – Your Fantasy SQL Feature

sp_RestoreScript 1.6 Release – @Credential Added For Backups In Azure BLOB Storage

Blogs

Database AI Agents: The Read-Only Rule

Creating a SQL Stored Procedure to Load a SCD2

Funny Money: #SQLNewBlogger

Forums

Backup Availability Group

How Do the Experts Become Experts?

Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment

Question of the Day

Secure Communications