Performance Tuning Using Extended Events: Part 2
Part 2 of identifying performance puning opportunities using Extended Events. Learn how about shredding XML.
2019-12-23
8,172 reads
Brian Davey
Performance Tuning Using Extended Events: Part 3
Identifying Performance Tuning Opportunities Using Extended Events: Part 3 Aggregate Report
2019-12-20 (first published: 2017-05-04)
6,082 reads
Performance Tuning Using Extended Events: Part 1
In this article, learn how to identify performance tuning opportunities using Extended Events.
2019-12-06 (first published: 2017-04-20)
18,228 reads
How to Setup Log Shipping for Multiple Databases
This article by Brian Davey describes how to setup log shipping for a large number of databases minimizing the number of jobs needed thus significantly reducing CPU and memory usage.
2011-09-28
11,713 reads
Changing Text in Multiple Stored Procedures From a Stored Procedure
In this article Brian Davey present a solution for changing the text in multiple stored procedures using T-SQL.
2011-03-28
11,496 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 Klender Call CSO; (+62 821°3111°179
Jl. I Gusti Ngurah Rai No.8 A-B, RT.8/RW.6, Wil, Kec. Duren Sawit, Kota Jakarta...
BCA KCP Permata Ujung Menteng Call CSO; (+62 821°3111°179
Jl. Raya Bekasi Km. 25 Blok A/17, RW.18, Ujung Menteng, Wil, Kota Jakarta Timur,...
BCA KCP Pondok Bambu Call CSO; (+62 821°3111°179
Pondok Bambu Center, Jl. Pahlawan Revolusi No.30 Blok A/5-6, RT.2/RW.2, Wil, Kec. Duren Sawit,...
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