Move All Your SQL Database and Log Files in Bulk
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)
732 reads
SQL Undercover
T-SQL Tuesday #124 Query Store and Spin Locks #tsql2sday
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)
340 reads
Undercover Tools: February Updates and Change Log
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
24 reads
SOS_SCHEDULER_YIELD – What is it really telling us?
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
135 reads
SQL Undercover TV – Instant File Initialisation
Adrian has a look at the performance benefits of instant file initialisation Below is Ade’s auto growth script…
2020-02-17
37 reads
Installing and Configuring the Undercover Catalogue
Quick video showing you how to install and configure the SQL Undercover Catalogue
2020-02-04
31 reads
Undercover TV – Table Variable Deferred Compilation
David takes a look at a new feature of SQL 2019, table variable deferred compilation
2020-02-03
22 reads
Undercover Tools: January Updates and Change Log
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
24 reads
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...
2020-02-03
37 reads
Your SQL Server's Screaming But Is Anyone Listening? – High Severity Alert Notifications
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
310 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Cengkeh Telpon/WA:085188120691
BCA KCP Cengkeh Telpon/WA:085188120691 Jl. Cengkeh 21-21A, Pinangsia, Kec. Taman Sari, Kota Jakarta Barat,...
BCA KCU THAMRIN Telpon/WA:085188120691
BCA KCU THAMRIN Telpon/WA:085188120691 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec....
BCA KCU KALIMALANG Telpon/WA:085188120691
BCA KCU KALIMALANG Telpon/WA:085188120691 Jl. Tarum Barat Blk. E No.5, Wil. Kota, Kec. Duren...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers