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,360 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,679 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,439 reads
Blogs
Logging in Azure Data Factory data flows
By Rayis Imayev
(2025-June-15) Long gone are the days when a data engineer could simply focus on building...
ADF: Publish suddenly includes everything where it used to be incremental changes since the last publish
By Ed Elliott
I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...
Beginner’s Guide: Create a File Organizer CLI Tool in Rust
Image from Afdhaluddin on ShutterstockCLI which is generally referred to as Command Line Interface...
Forums
How Many Can Be the Greatest
Comments posted to this topic are about the item How Many Can Be the...
How to process images and analyze charts with AI
Comments posted to this topic are about the item How to process images and...
Patching the Patch
Comments posted to this topic are about the item Patching the Patch
Question of the Day
How Many Can Be the Greatest
I am trying to analyze a number of columns in a large table to determine the highest value for each row. In SQL Server 2022, we have the GREATEST function, which will return the greatest value from those columns passed in. How many columns can I include in an expression like this:
select GREATEST( col1, col2, col3, ...)See possible answers