External Article

Optimizing Transaction Log Throughput

As a DBA, it is vital to manage transaction log growth explicitly, rather than let SQL Server auto-growth events "manage" it for you. If you undersize the log, and then let SQL Server auto-grow it in small increments, you'll end up with a very fragmented log. This article demonstrates how this can have a significant impact on the performance of any SQL Server operations that need to read the log.

Blogs

Overcoming Imposter Syndrome: A Plan

By

My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...

Advice I Like: Celebrate Success

By

“On the way to a grand goal, celebrate the smallest victories as if each...

Programmatically Retrieving MLV Lineage and Refresh Times

By

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

Read the latest Blogs

Forums

BCA KCP Wahid Hasyim Telpon/WA:087768193341

By matkydablog

BCA KCP Wahid Hasyim Telpon/WA:087768193341.Jl. K.H. Wahid Hasyim No.82, Kb. Sirih, Kec. Menteng, Kota...

BCA KCP Raden Saleh Telpon/WA:087768193341

By matkydablog

BCA KCP Raden Saleh Telpon/WA:087768193341.Jl. Raden Saleh No. 13, 15, 17A, Daerah Khusus Ibukota...

BCA KCU THAMRIN Telpon/WA:087768193341

By matkydablog

BCA KCU THAMRIN Telpon/WA:087768193341.Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng,...

Visit the forum

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