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

Inspector V1.4 now available

The SQL Installation script can be found here The Inspector sample report has been updated here All of the below Git Issues can be found on the V1.4 Project page #68 Added a new table [Inspector].[ExecutionLog] which will hold elapsed time for each of the stored procedures executed during a collection, this table is truncated... Continue Reading →

May 20, 2019 1

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

Why Rolling back inserts with Identity columns is a bad idea.

It wasn't until the other day that I realised what the behaviour was when rolling back a transaction with an insert on a table with an identity column, to be fair I have never had a need to do so but I know that there are people who like to run code like below to... Continue Reading →

Apr 11, 2019 7

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

#TSQL2sDay – #112 – Mini cookies

This months TSQL Tuesday is hosted by Shane O'Neill (Blog | Twitter) Shane explains the Topic as: Dipping into the Cookie Jar is about when the going gets tough and you don’t think you can handle anymore, then you think back about your accomplishments and take some sustenance from them. Cookie One: is remembering... Continue Reading →

Mar 12, 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 11

Undercover TV – Sean McCown Joins Us For a Session on Beginning Powershell SMO

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

Feb 26, 2019 0

Undercover Catalogue 0.2.1, Fixes An Issue With The Recording Of Unicode And MAX Datatype Lengths

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 →

Feb 14, 2019 0

Up ↑

Tag: SQL

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.

Inspector V1.4 now available

Is Your Availability Group ‘REALLY’ Ready To Failover?

Why Rolling back inserts with Identity columns is a bad idea.

Filling Missing ID Codes In SQL

#TSQL2sDay – #112 – Mini cookies

TSQL Tuesday #112 – Dipping into the Cookie Jar

Using Indexing To Solve Blocking and Deadlocking Issues

Undercover TV – Sean McCown Joins Us For a Session on Beginning Powershell SMO

Undercover Catalogue 0.2.1, Fixes An Issue With The Recording Of Unicode And MAX Datatype Lengths

David Fowler

Adrian Buckman

Archives

Follow me on Twitter

Recent Posts From The Undercover DBAs