Controlling how SQL Prompt Formats your Code: The Knobs and Dials
Phil Factor explores and discusses the current state of the art in SQL Formatting, as done automatically by SQL Prompt.
2019-12-20
Coding Style
SQL Server Name Convention and T-SQL Programming Style
There are only two hard things in Computer Science: cache invalidation and naming things -- Phil Karlton The recommendations in this article are not the ultimate truth. Please consider this article as a rule template that you can adapt to your needs. A naming convention is a set of rules for choosing the character sequence to […]
2019-12-10
25,036 reads
Balancing Performance and Readability
Developers need to consider not only system performance when writing code, but also how readability impacts code maintenance.
2018-03-20
1,322 reads
Blogs
SQL Training Black Friday Deals
By Brian Kelley
If you're looking for particular "Black Friday" deals, here is what I've seen advertised...
Dry-run xp_delete_file Before Actually Deleting Files?
By SQLPals
Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...
Happy Thanksgiving! (USA Holiday)
By Brian Kelley
In the United States, today is Thanksgiving. The intent behind the holiday is to...
Forums
Don't Let Corner Cases Drive Your Design
Comments posted to this topic are about the item Don't Let Corner Cases Drive...
A New Operator
Comments posted to this topic are about the item A New Operator
Troubleshooting Common SQL Server Errors: 823, and 824
Comments posted to this topic are about the item Troubleshooting Common SQL Server Errors:...
Question of the Day
A New Operator
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers