SQL Undercover

Undercover Tools: June Updates

• by davidfowler-42596

• SQL Undercover

Undercover Catalogue Update 0.4.3 An update to the tables module, Row count and size infotmation added Fix – LocalInterrogation There was an issue with the LocalInterrogation stored proc not...

2020-06-01

5 reads

A Bug in ‘Move All Your SQL Database and Log Files in Bulk’

• by davidfowler-42596

• SQL Undercover

It looks like we had a bug the in the SQL script in Move All Your SQL Database and Log Files in Bulk. No worries though, it’s all been fixed...

2020-04-22

5 reads

Move All Your SQL Database and Log Files in Bulk

• by davidfowler-42596

• SQL Undercover

As always, the script from this post can also be found on our GitHub repo, HERE You’ve got a SQL Server with a few hundred databases on it (to...

2020-04-23 (first published: 2020-04-15)

706 reads

T-SQL Tuesday #124 Query Store and Spin Locks #tsql2sday

• by davidfowler-42596

• SQL Undercover

This month’s T-SQL Tuesday invitation comes from Tracy Boggiano  and she’s asking us to write about our experiences with Query Store. I thought about what I should write, I’m...

2020-03-17 (first published: 2020-03-10)

319 reads

Undercover Tools: February Updates and Change Log

• by davidfowler-42596

• SQL Undercover

Below is the February list of changes and updates to the Undercover Tools. Undercover Catalogue Update 0.4.2Two new modules were added to the Catalogue. Trace Flags – Capture trace...

2020-03-02

12 reads

SOS_SCHEDULER_YIELD – What is it really telling us?

• by davidfowler-42596

• SQL Undercover

I decided to write this off the back of a conversation I was having the other day around the SOS_SCHEDULER_YIELD wait type. The conversation went something along the lines...

2020-02-26

123 reads

SQL Undercover TV – Instant File Initialisation

• by davidfowler-42596

• SQL Undercover

Adrian has a look at the performance benefits of instant file initialisation Below is Ade’s auto growth script…

2020-02-17

18 reads

Installing and Configuring the Undercover Catalogue

• by davidfowler-42596

• SQL Undercover

Quick video showing you how to install and configure the SQL Undercover Catalogue

2020-02-04

13 reads

Undercover TV – Table Variable Deferred Compilation

• by davidfowler-42596

• SQL Undercover

David takes a look at a new feature of SQL 2019, table variable deferred compilation

2020-02-03

11 reads

Undercover Tools: January Updates and Change Log

• by davidfowler-42596

• SQL Undercover

Below is the January list of changes and updates to the Undercover Tools. Undercover Catalogue Update 0.4.0Major upgrade, see https://sqlundercover.com/2020/01/06/undercover-catalogue-0-4-0-released/ for full details Update 0.4.1ServerConfig module added, detailing settings...

2020-02-03

10 reads