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,320 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,211 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,276 reads
Blogs
Azure Storage tips
By James-Serra
As a followup to my blog post Azure Data Lake Store Gen2 is GA,...
Managing Agent Jobs on Availability Group Servers
As always, the scripts in this post can also be found on our Git...
Permissions required for row counts to show up on Object Explorer Details
I ran into a rather obscure permissions problem the other day. Since I wasn’t...
Forums
First DW design - advice appreciated
All, Up to this point I've only worked with relational databases. I'm trying to...
Backup Strategy For distributed availability groups
What is the recommendations for backups in distributed availability groups? I have AG setup...
What happens when I drop a huge table with LOBs? will the space be reused?
Thanks in advance for your help. I have a 5TB database with mutliple filegroups. ...
Ask SSC