A Bug in ‘Move All Your SQL Database and Log Files in Bulk’
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
27 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
27 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)
352 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
33 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
144 reads
Adrian has a look at the performance benefits of instant file initialisation Below is Ade’s auto growth script…
2020-02-17
48 reads
Quick video showing you how to install and configure the SQL Undercover Catalogue
2020-02-04
39 reads
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...
2020-02-03
48 reads
Below is the January list of changes and updates to the Undercover Tools. Undercover Catalogue Update 0.4.0Major upgrade, see https://sqlundercover.com/2020/01/06/undercover-catalogue-0-4-0-released/ for full details Update 0.4.1ServerConfig module added, detailing settings...
2020-02-03
29 reads
David takes a look at a new feature of SQL 2019, table variable deferred compilation
2020-02-03
30 reads
As usual, the scripts in this post can be found HERE on our Git Hub repo If your SQL Server comes across something that it’s not happy about, it...
2020-01-30
317 reads
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Comments posted to this topic are about the item It's Never Just One Thing
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers