It looks like we had a bug the in the SQL script in Move All Your SQL Database and Log Files in Bulk. No worries though, it's all been fixed now 🙂
A Bug in ‘Move All Your SQL Database and Log Files in Bulk’
Inspector 2.1 now available
As always all updates can be found on our Github repo Breaking changes (Powershell collection): We only test the powershell collection against 2-3 servers so please test carefully before rolling out changes especially if you are centralising more servers than we do. Unlike the SQL based agent collections we would recommend running the powershell collection... Continue Reading →
CPU custom module available for Inspector V2
If you need to keep track of CPU and are not fortunate enough to have a monitoring tool to keep hold of historical CPU usage then this module may just be for you, you can find the code on GitHub. New to the Inspector? be sure to check out the Introducing Inspector post first.We have... Continue Reading →
Resend an email sent from SQL Server using TSQL
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 →
What if it all grows out?!
The other day I got thinking about what would happen if all databases on a single instance grew out, every single one of them! but not just once, what if they all grew out three, four or fives times overnight - what would things look like? Well I know the likelihood may be slim but... Continue Reading →
Log Shipping – Error: Failed to update database “DATABASE NAME” because the database is read-only
Here's a strange one that I've recently come across. I had a customer report that their log shipping restore jobs were chock a block of errors. Now, the logs seem to have been restoring just fine but before every restore attempt, the job is reporting the error, Error: Failed to update database "DATABASE NAME" because... Continue Reading →
Getting started with the SQLUndercover Inspector
Post Updated: 15/07/2020 Here is a quick guide to getting started with the SQLUndercover Inspector. So you have ran through the installation of the Inspector and now you want to know what to do next, below we will guide you through some of the key steps to get you started and following on from that... Continue Reading →
The SQLUndercover Inspector is now available!
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... Continue Reading →
sp_AGReconfigure 1.1 is now available
sp_AGReconfigure 1.1 is now available HERE and on GitHub V1.1 includes a new Parameter and some minor bug fixes: @Readable NULL - DEFAULT: Ignore Readable secondary check (acts as though you are using V1) 0 - Produce a statement to switch readable secondary off if switched on 1 - Produce a statement to switch readable... Continue Reading →
Introducing: The SQLUndercover Inspector
Page Updated: 15/07/2020 Current changes:Inspector V2 changesPrevious changes: Inspector V1.4 changes. Inspector V1.3 changes.Inspector V1.2 changes.Custom modules:BlitzWaitsBlitzFileStatsCPU Introducing: The SQLUndercover Inspector! now available on GitHub but what exactly is it? The All new Inspector gives you the power to Create, configure and schedule SQL modules, control when modules execute and control when reports are produced/emailed.... Continue Reading →
