A collection of articles covering SQL formatter and code refactoring topics
SQL formatting
- Beautify your SQL code using SQL formatter features
- How to format all SQL objects in your database
- How to format SQL code in SQL Server Management Studio
- How to format SQL like a pro – formatting to implicit Microsoft standards and guidance
- Rules of SQL formatting – Commas and spacing in T-SQL
- Rules of SQL formatting – Regular and delimited T-SQL identifiers
- Rules of SQL formatting – SQL code commenting
- Rules of SQL formatting – SQL naming conventions and capitalization rules
- Rules of SQL formatting – Terminating SQL statements with semicolons
- SQL Formatting standards – Capitalization, Indentation, Comments, Parenthesis
- SQL Formatting standards – joins, lists, structure, operations
- SQL query basics – How to improve readability by formatting commas, spacing and alignment
- Top things you need in a SQL Server formatting tool
SQL Server code refactoring
- SQL database refactoring – Finding and updating internal references
- SQL database refactoring – Introduction
- SQL database refactoring techniques
- How to refactor a SQL Server database table to add a surrogate key
- SQL code refactoring – ways to improve database performance (part III) – Add surrogate key
- SQL database refactoring techniques – Replacing a natural key with a surrogate key
- Quickly convert SQL code to language-specific client code
- Changing SQL stored procedures and functions parameters without breaking dependencies
- How to safely modify SQL stored procedure and SQL function parameters
- SQL code refactoring – ways to improve database performance (part I) – Encapsulate code as a stored procedure
- How to secure stored procedures against SQL injection
- How to format a SQL query to qualify object names explicitly
- Improve the performance of your SQL queries by qualifying object names
- Replacing one-to-many relationships with association tables automatically– Part 1
- Replacing one-to-many relationships with association tables automatically – Part 2
- SQL code refactoring – ways to improve database design
- How to rename database objects in a SQL Server database safely – Part 1
- How to rename database objects in a SQL Server safely – Part 2
- SQL database refactoring techniques – Rename method
- Two ways to rename SQL Server database objects
- How to refactor a SQL Server database by splitting a table
- SQL code refactoring – ways to improve database performance (part II) – Split table
- SQL Refactoring techniques – How to split a table in SQL
- Clean up SQL code from variables you don’t use
- How to clean up SQL database code by removing unused parameters
- How to prevent performance problems and errors due to wildcards in SELECT statements
Adding surrogate key
Converting to code
Changing parameters
Encapsulating SQL
Qualifying object names
Replacing one-to-many relationship
Renaming safely
Splitting a table
Cleaning up unused variables and parameters
Expanding wildcards
SQL productivity tools
- Boost your productivity using ApexSQL Fundamentals Toolkit for SQL Server
- How to review SQL object dependencies and rename objects without breaking the integrity
- How to script SQL objects, format, and run SQL scripts on multiple SQL Server instances
Interested in more?
Here is a great collection of SQL formatter tools
