Goal Progress–Wrapping up 2020
This is the final look at my goals for 2020 and how I did. I am writing this a few days after the end of the year, and examining...
2021-01-08
16 reads
Blog Posts
Powerful Monitoring for Your Linked Servers with XEvents
Linked Servers can certainly provide an enigma to your finely tuned Database environment. In this article, I share how to decrypt that enigma via XEvents.
The post Powerful Monitoring...
2021-01-08 (first published: 2021-01-02)
354 reads
Saving PASS Pro Videos
PASS will close down their websites on 15 Jan 2021. That’s just a couple weeks away, and if you’re someone that paid for a year of PASS Pro access,...
2021-01-08 (first published: 2021-01-04)
270 reads
Daily Coping 7 Jan 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-01-07
21 reads
Experiments With Go Arrays and Slices
Simplicity Over Syntactic Sugar
As I’ve been learning Go, I’ve grown to learn that many decisions to simplify the language have removed many features that provide more succinct expressions in...
2021-01-07 (first published: 2020-12-30)
332 reads
Game changer settings # MAXDOP and Cost threshold for parallelism
I got a performance tuning assignment for an esteemed customer in the Financial Services domain. I went through the wait stats of SQL Server using the built-in SQL Server...
2021-01-07 (first published: 2021-01-02)
2,668 reads
SQLpassion Online Training about Statistics & Plan Caching
On January 28, 2021 I will run an SQLpassion Online Training about Statistics & Plan Caching in SQL Server. Statistics are used by SQL Server to estimate how many...
2021-01-07
5 reads
SQLpassion Online Training about Statistics & Plan Caching
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2021-01-07
6 reads
SQLpassion Online Training about Statistics & Plan Caching
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2021-01-07
4 reads
SQLpassion Online Training about Statistics & Plan Caching
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2021-01-07
10 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 Mulyosari No.Telp 083831617937
Whatsapp.083831617937 JL. Mulyosari, No.364 A Blok Z.56, 60113, Kalisari, Kec. Mulyorejo, Kota SBY, Jawa...
BCA KCP Mega Grosir No.Telp 083831617937
Whatsapp.083831617937 ITC Mega Grosir, Ground Floor Blok H2 No. 7-8-9, Jl. Gembong No. 20-30...
BCA KCP M. Duryat No.Telp 083831617937
Whatsapp.083831617937 Jl. Kombes M. Duryat Blok A No. 5-6 Surabaya, Jawa Timur, Indonesia 60262
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