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,704 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,302 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,359 reads
Blogs
Daily Coping 29 Nov 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
What are those new buttons under tab order in Power BI?
If you’ve visited the Tab order area of the Selection Pane in Power BI...
Last Week Reading (2021-11-28)
By Kamil
?? Press SynapseML: A simple, multilingual, and massively parallel machine learning library Microsoft just...
Forums
Get Summary Data for Last 52 weeks by Week
I have a table which stores shipment data by date. We have a need...
create index columnstore
hello , Who has any idea please how to rebuild a clustered index to...
help with SQL query PGADMIN
2 tables Users : User_id, First_name, Last_name, Gender. Deposits : User_id, time_stamp, amount. i...
Ask SSC