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 →
sp_restorescript v1.3 is now available. We had found instances where backups consisting of multiple backup files were causing the length of the restore command to exceed the maximum character limit. 1.3 deals with this problems. Please visit https://sqlundercover.com/2017/06/29/undercover-toolbox-sp_restorescript-a-painless-way-to-generate-sql-server-database-restore-scripts/ for full documentation on sp_restorescript The procedure can also be downloaded from out GitHub site https://github.com/SQLUndercover/UndercoverToolbox/blob/master/sp_restorescript.sql
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 →
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 →
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 →
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 →
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 →
In this episode, Adrian looks at some of the new features of the Undercover Inspector1.3 and special guest, Sean McCown give us a fantastic intro into the Powershell SMO (0:23:20). All Sean's scripts can be found at on Git Hub at https://github.com/SQLUndercover/UndercoverToolbox/tree/master/Undercover%20TV%20Scripts/BeginningSMO https://www.youtube.com/watch?v=TCx1UbZ6iLc&t=4s
Please see https://sqlundercover.com/undercover-catalogue-0-2/ for full details on the Undercover Catalogue and how to obtain it. We've spotted an issue where unicode datatypes were having their size recorded as the data length rather than character count in the 'Tables' module. Another issue affected any MAX datatypes which were having their length mis-recorded. Version 0.2.1 fixes both... Continue Reading →
It's 4am in the morning and my phone starts ringing. A blury eyed, me picks it up to hear the voice of one of our application guys at the other end saying something about an upgrade he was trying to carry out failing. So it turns out that he was trying to run an ALTER... Continue Reading →
SQL Undercover 