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
14,338 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
982 reads
Blogs
Daily Coping 24 Jun 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
DDL Trigger to log database level security commands.
In my last post I talked about reasons why your permissions might go missing....
Azure SQL Managed Instance Versions
By Arun Sirpal
Just a really quick FYI for the readers. If you are using Managed Instances...
Forums
Cannot log in to new SQL server
Hello, I'm fairly new to installing SQL 2019 standard and am having two issues....
Single Query Instead of a Cursor
Is it possible to rewrite this routine to be a single query, instead of...
Report with 2 tables per page grouped on same data
hi all looking some advice on the best approach on designing a report in...
Ask SSC