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
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.
- Download free eBook
- Printed book:
- Kindle book:
2010-02-19
9,445 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 MULTI FINANCE CAB SUNTER Telpon/WA:0851•8812•0691
BCA MULTI FINANCE CAB SUNTER Telpon/WA:0851•8812•0691 Ruko Danau Sunter Utara, BLK. a 36D Jl....
BCA KCP Jelambar Baru Raya Telpon/WA:08137887595
BCA KCP Jelambar Baru Raya Telpon/WA:08137887595.Jl. Jelambar Baru Raya No.53 C, Jelambar, Kec. Grogol...
BCA KCU SUKABUMI Tlpn/wa:085373737551
Jl. A. Yani No.33-35, Gunungparang, Kec. Cikole, Kota Sukabumi, Jawa Barat 43111
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