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
9,624 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,257 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,324 reads
Blogs
Career: Talk To References
By Steve Jones
As we try to get through these strange times in the world, I am...
This Saturday: #DataWeekender, DataSaturday Southwest
By Will Assaf
Geeked to be speaking 2x on Saturday May 14, my second time speaking at...
Daily Coping 14 May 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Why doesn't the Secondary failover?
Hi, I hope someone can help. I will try to summarise as best as...
How to rewrite sql query after where condition with another query ?
I work on sql server I need to rewrite statement after where statement so...
Incorrect syntax near the keyword 'AS'
Hi Everyone. I'm hoping someone can take a look at my code here to...
Ask SSC