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 →
It has been long overdue but finally V1.2 is now available on GitHub. V1.2 brings a lot of changes, We put together a sample report for you to play with but here is an overview of what has been added. Enhancements: #9 Long running transactions module added - A new setting has been added to [Inspector].[Settings]. This setting... Continue Reading →
Pre-requisites: SQL 2012 or higher SQL Server Agent A database to store the the data collected by the agent jobs (this can be one you use for your other DBA needs it doesn’t have to be a dedicated database) Optional: For instances with availability groups where you take backups on the secondary replicas you will... Continue Reading →
I was having a cleanup of some old scripts the other day when I stumbled upon a script I wrote some time ago. I remember writing the script because from time to time I would get asked if I can restore a copy of a specific database to a particular point in time... Continue Reading →
This months T-SQL Tuesday is being hosted by Bert Wagner , you can find the invitation for this months topic here. Bert has a great topic for this month, he wants us to write about code you’ve written that you would hate to live without. I have found the SQL server community to be extremely helpful... Continue Reading →
Sometimes emails from SQL Server go missing, especially when you share an inbox with colleagues. On most occasions it doesn't always matter as the job that generated the email can simply be re ran to produce the email once again, but what about those emails that contain time specific information? we cannot simple just kick... Continue Reading →
This month’s T-SQL Tuesday is brought to you by Jens Bestergaard - the subject is Essential SQL Server tools, the original invitation can be found here. Here is how my day of using SQL tools went: It all started at 00:00 this morning with planned maintenance, I was adding a bunch of Clustered indexes... Continue Reading →
Here's a quick one for you. If you happen to be managing SQL Servers with a large number of databases and availability groups, it can sometimes be difficult to keep track of which database belongs to which availability group. sp_WhatsMyAG will tell you just that. You can either provide it with the database name and... Continue Reading →
Updated: 28/11/2018: We've put together a sample report for you to play with. The SQLUndercover Inspector is now available on GitHub, a quick run down of what it does can be found here: Introducing: The SQLUndercover Inspector, a quick video introduction can be found here and upcoming video tutorials will be released on Undercover TV in due... Continue Reading →
