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.

Creating a SQL Server Test Lab On Your Workstation – Part One, Installing The Domain Controller

by davidfowler-42596

SQL Undercover

One of the most useful tools to the DBA when we need to test new features, recreate a fault that...

2017-12-18

630 reads

GroupBy Slides and Demo Script is Now On GitHub

by davidfowler-42596

SQL Undercover

The slides and demo scripts from today’s GroupBy session are now available on our GitHub repository
https://github.com/SQLUndercover/UndercoverToolbox/tree/master/GroupBy
Many thanks again for watching,...

2017-12-08

347 reads

Using PowerShell To Deploy Scripts From GitHub to Multiple SQL Servers

by davidfowler-42596

SQL Undercover

Now I’m all for making my life easier and one thing that makes life easier for me is having a...

2017-11-27

518 reads

SQL Smackdown!!! Cursors VS Loops

by davidfowler-42596

SQL Undercover

Ladies and Gentlemen, welcome to the main event of the evening. The SQL Undercover Smackdown Heavy Weight Championship of the...

2017-11-16

2,448 reads

T-SQL Tuesday – Folks Who Have Made a Difference #TSQL2sday

by davidfowler-42596

SQL Undercover

So this month’s T-SQL Tuesday subject is a shout out and high-five to those people who have inspired or made a...

2017-11-14

306 reads

T-SQL Tuesday #96 – Folks Who Have Made a Difference in my career #TSQL2sday

by davidfowler-42596

SQL Undercover

This months TSQL Tuesday subject is a shout out and high-five to those people who have inspired or made a contribution...

2017-11-14

696 reads

T-SQL Tuesday #96 How did I get started?

by davidfowler-42596

SQL Undercover

Hi Folks,

I’m the new guy that my two colleagues are still trying to convince to write my first blog post...

2017-11-14

450 reads

UNDERCOVER TOOLBOX: Using Python To Copy A SQL Login From One Server To Another

by davidfowler-42596

SQL Undercover

Recently I’ve been thinking about Python and whether it can be useful to the DBA as well as the data...

2017-10-30

391 reads

UNDERCOVER TOOLBOX: Find Untrusted Foreign Keys and Orphaned Key data

by davidfowler-42596

SQL Undercover

SQL Server tracks untrusted Foreign keys in sys.Foreign keys with a column called is_not_trusted, there may be a number of...

2017-10-24

189 reads

Connecting to a Remote Instance of SQL Server Using Python

by davidfowler-42596

SQL Undercover

SQL Server’s integration of Python has been heavily marketed towards the machine learning and BI guys, but does it offer...

2017-10-18

1,099 reads

Blogs

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

There was a time when the Chief Data Officer lived in the shadows of...

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

By Rayis Imayev

"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...

Adding a Local Model to Ollama through the GUI

I saw some good reviews of the small gemma3 model in a few places...

Read the latest Blogs

Forums

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

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

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

Comments posted to this topic are about the item SQL Server Advanced Troubleshooting and...

T-SQL Fundamentals

Comments posted to this topic are about the item T-SQL Fundamentals

Visit the forum

Question of the Day

PWDCompare

What does the PWDCOMPARE function do?

See possible answers