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

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%') would now be a valid option with % treated as a wildcard. Bug Fixes An issue when using multiple database and @no_recovery = 0 or @standby=1... Continue Reading →

Jul 15, 2019 0

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

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 in the four node cluster, migrate those over to the new SAN provided to me by the lovely storage guys. Once they were done, fail the... Continue Reading →

Jul 8, 2019 0

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

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 that I really wish it would do better. Firstly, I'd love to see the total size of the drive and possibly even a percentage of free... Continue Reading →

Jul 3, 2019 1

Undercover Catalogue 0.2 Hox Fix 2 to Fix Breaking Changes with dbatools 1.0.0 & SQL2008r2/2008 Compatibility Patch RELEASED

Some breaking changes were introduced with dbatools 1.0.0, please make sure that you've got the latest version of hotfix 2 installed as well as the lastest Interrogation script runningThe minimum version of dbatools that we now support is 1.0.0 Undercover Catalogue 0.2.2 It looks like a bug has crept it's way into the Undercover Catalogue.... Continue Reading →

Jun 20, 2019 0

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.

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. I started off by running the following command against the secondary server. ALTER DATABASE SQLUndercover MODIFY FILE (NAME = 'AG01', FILENAME = 'E:\DATA\AG01.mdf') There's nothing wrong... Continue Reading →

Jun 6, 2019 0

Is Your Availability Group ‘REALLY’ Ready To Failover?

You know what it's like, you need to fail your AG over but is it safe to fail over? Perhaps you've clicked on 'failover' for the AG and there's a little green tick and no data loss reported... Or maybe you've checked out sys.dm_hadr_database_replica_cluster_states and 'is_failover_ready' is reporting a 1. So, you're cool to failover,... Continue Reading →

Apr 29, 2019 1

Filling Missing ID Codes In SQL

This is going to be a bit of a brain storming post that comes from an interesting question that I was asked today... "I've got a table with a ID code field, now some of the rows have a value in that field and some are NULL. How can I go about filling in those... Continue Reading →

Mar 26, 2019 1

TSQL Tuesday #112 – Dipping into the Cookie Jar

This month's TSQL Tuesday comes from Shane O'Neil and he's asking us to 'dip into the cookie jar' (or raid the biscuit tin, for us Brits 😉 ), essentially how we use past accomplishments to help us through difficult or challenging times. I've been trying to think about this and while like everyone I've had... Continue Reading →

Mar 12, 2019 1

Using Indexing To Solve Blocking and Deadlocking Issues

A while back, I was having a conversation about a deadlocking issue and suggested that an index could perhaps help solve it. The reaction I got was along the lines of, 'What, how can in index solve a deadlocking issue?' So, can we solve a deadlocking issue with an index? Let's create a rather simple,... Continue Reading →

Mar 5, 2019 7

Up ↑

Tag: Microsoft

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

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

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

Undercover Catalogue 0.2 Hox Fix 2 to Fix Breaking Changes with dbatools 1.0.0 & SQL2008r2/2008 Compatibility Patch RELEASED

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.

Is Your Availability Group ‘REALLY’ Ready To Failover?

Filling Missing ID Codes In SQL

TSQL Tuesday #112 – Dipping into the Cookie Jar

Using Indexing To Solve Blocking and Deadlocking Issues

David Fowler

Adrian Buckman

Archives

Follow me on Twitter

Recent Posts From The Undercover DBAs