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

10 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

28 reads

Get All Database Snapshots and Their Parent Databases On A SQL Server

• by davidfowler-42596

• SQL Undercover

This is going to be a quick post but this morning I was asked the question, ‘how can I get the name of all the database snapshots on a...

2019-08-15

13 reads

sp_RestoreScript 1.5 Release

• by davidfowler-42596

• SQL Undercover

We’ve released sp_RestoreScript 1.5. This is only a minor release but adds the type of the backup file to the output. You can grab the latest version from our...

2019-08-12

7 reads

Intent Locks In SQL Server

• by davidfowler-42596

• SQL Undercover

Intent locks, one of those things in SQL Server that seem to be very often misunderstood. They’re something that I’ve found myself explaining time and time again, I’ve even...

2019-07-25

33 reads

Error: ‘misaligned log IOs which required falling back to synchronous IO’ And Slow AG Synchronisation

• by davidfowler-42596

• SQL Undercover

I recently hit this rather interesting issue when migrating a bunch of SQL Servers onto a nice, shiny new SAN. The plan was simple enough, take the secondary servers...

2019-07-22 (first published: 2019-07-08)

423 reads

sp_drivespace – See How Much Space You Have On Your Disks, Including Mount Points

• by davidfowler-42596

• SQL Undercover

We love xp_fixeddrives here, it’s a quick and simple way to see how much space you’ve got available on your drives. But there are just a couple of things...

2019-07-17 (first published: 2019-07-03)

736 reads

sp_RestoreScript v1.4 – It’s Now Compatible with Case Sensitive Collations, Accepts Wild Cards in DB Names and Fixes A bug

• by davidfowler-42596

• SQL Undercover

sp_RestoreScript 1.4 is now out and ready for download from our GitHub, https://github.com/SQLUndercover/UndercoverToolbox/blob/master/sp_restorescript.sql New Features Compatible with case sensitive collations Now accepts wild cards in the @DatabaseName string, (‘Database1,Database2,SQL%’)...

2019-07-15

200 reads

Undercover Catalogue 0.2 Hox Fix 2 and SQL2008r2/2008/possibly 2005 Compatibility Patch RELEASED

• by davidfowler-42596

• SQL Undercover

Undercover Catalogue 0.2.2 It looks like a bug has crept it’s way into the Undercover Catalogue. When running with certain versions of DBA Tools, a number of the modules...

2019-06-20

To use ALTER DATABASE, the database must be in a writable state in which a checkpoint can be executed. – when moving files on an Availability Group secondary.

• by davidfowler-42596

• SQL Undercover

Here’s a little error that I stumbled across the other day when trying to migrate the data files of an Availability Group secondary node onto a nice new SAN....

2019-06-06

71 reads