This month’s T-SQL Tuesday invitation is from Ken Fisher and he’s asking about non-SQL tips and tricks. This had me thinking for a bit and then something popped into...
2020-06-23 (first published: 2020-06-09)
310 reads
SQL Server has given us the option to backup our databases directly to Azure BLOB storage for a while now but it’s not something that I’ve had all that...
2020-06-22
BlitzFileStats is the latest addition to our custom module collection for reporting on data logged to tables using the First Responder kit, We created a new project where we plan on...
2020-06-03
8 reads
Undercover Catalogue Update 0.4.3 An update to the tables module, Row count and size infotmation added Fix – LocalInterrogation There was an issue with the LocalInterrogation stored proc not...
2020-06-01
4 reads
As always, the script from this post can also be found on our GitHub repo, HERE You’ve got a SQL Server with a few hundred databases on it (to...
2020-04-23 (first published: 2020-04-15)
695 reads
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...
2020-04-22
5 reads
This month’s T-SQL Tuesday invitation comes from Tracy Boggiano and she’s asking us to write about our experiences with Query Store. I thought about what I should write, I’m...
2020-03-17 (first published: 2020-03-10)
315 reads
Below is the February list of changes and updates to the Undercover Tools. Undercover Catalogue Update 0.4.2Two new modules were added to the Catalogue. Trace Flags – Capture trace...
2020-03-02
12 reads
I decided to write this off the back of a conversation I was having the other day around the SOS_SCHEDULER_YIELD wait type. The conversation went something along the lines...
2020-02-26
117 reads
Adrian has a look at the performance benefits of instant file initialisation Below is Ade’s auto growth script…
2020-02-17
18 reads
By Steve Jones
It’s the eve of the Fourth of July, when the Declaration of Independence is...
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
By John
No, not that kind of volume! Over the past couple of blog posts, I...
I was trying these but it does not work: USE [MyDatabase] GO /****** Object:...
Comments posted to this topic are about the item Managing Stress
Hi, I am using AlwaysOn Availability Groups in SQL Server 2016 with a primary...
Ask SSC