SQL Undercover

@adedba Adrian Buckman has been working hard and has put all of our scripts up on Github https://github.com/SQLUndercover/UndercoverToolbox

2018-01-18

357 reads

Dissecting SQL Server, The Internal Structure of a Row

by davidfowler-42596

SQL Undercover

I’m sure that most of us know that SQL Server stores all it’s data in 8Kb pages. But what do...

2018-01-26 (first published: 2018-01-15)

1,919 reads

Creating a SQL Server Test Lab On Your Workstation – Part Two, Creating a Domain Account and Joining a SQL Server to the Domain

by davidfowler-42596

SQL Undercover

In the second part of our series on creating a SQL Server test lab on your workstation, I’m going to...

2018-01-12 (first published: 2018-01-03)

2,313 reads

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

623 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

345 reads

UNDERCOVER TOOLBOX: sp_AGReconfigure – Manage Always on Sync & Failover settings from a single stored procedure.

by davidfowler-42596

SQL Undercover

From time to time we need to make changes to Always on Availability group Synchronization mode settings , this also includes...

2017-12-20 (first published: 2017-12-08)

1,468 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

499 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,410 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

690 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

448 reads

SQL Undercover

All Scripts Now On Github

Dissecting SQL Server, The Internal Structure of a Row

Creating a SQL Server Test Lab On Your Workstation – Part Two, Creating a Domain Account and Joining a SQL Server to the Domain

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

GroupBy Slides and Demo Script is Now On GitHub

UNDERCOVER TOOLBOX: sp_AGReconfigure – Manage Always on Sync & Failover settings from a single stored procedure.

Using PowerShell To Deploy Scripts From GitHub to Multiple SQL Servers

SQL Smackdown!!! Cursors VS Loops

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

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

Blogs

How to find free space in Azure PosgreSQL

T-SQL Tuesday #180: Good enough is perfect Roundup

Using SQL Compare with Read-only Access

Forums

Compare rows within the same table

Microsoft Recommendations for Update Stats?

how can i tell if our db2 driver is ms or ibm or other?

Question of the Day

A Strange Result