Defensive Database Programming
Inside this book, you will find dozens of practical, defensive programming techniques that will improve the quality of your T-SQL code and increase its resilience and robustness.
2013-08-26
10,398 reads
Alex Kuznetsov
Fun with business days, calendar tables, and test-driven development
We shall discuss how to
build a calendar table, and use it in calculations involving business days
2010-09-23
7,700 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 Menara Ancol,Telp/Wa 0821.3111.159
Jl. Pasir Putih Raya, Ancol, Kec. Pademangan, Jkt Utara, Daerah Khusus Ibukota Jakarta 14430
BCA KCP Gading Riviera,Telpon/Wa 0821-8200-239
Jl. Raya Kelapa Hibrida, Ruko, Jl. Gading Riviera Raya No.10 Blok PF 21, Daerah...
BCA KCP Prima Sunter,Telpon/Wa 0821-8200-239
Jl. Danau Sunter Utara No.A2-A3, Sunter Jaya, Kec. Tj. Priok, Jkt Utara, Daerah Khusus...
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