Permissions and requirements
- Minimal SQL Server permissions for ApexSQL Developer tools
- Minimum requirements for installing ApexSQL Refactor
- Supported software for ApexSQL Refactor
Introduction
Configuration and setup
- How to install ApexSQL add-ins and integrate them into SQL Server Management Studio and Visual Studio
- How to remove add-ins just from Visual Studio while retaining them in SQL Server Management Studio
- How to manually uninstall ApexSQL add-ins
- How to install ApexSQL add-ins and integrate into host environments e.g. SSMS, Visual Studio
Formatting
- Formatting option mockups and examples
- Online SQL formatter overview
- Tips and tricks for using ApexSQL Refactor SQL formatting options – General options, Capitalization and Comments
- Tips and tricks for using ApexSQL Refactor SQL formatting options – Parameters, Columns, Joins, and Flow control
- Rules of SQL formatting – Nesting and indenting SQL statements
- How to customize SQL formatting profiles
- How to improve query performance and avoid syntax errors by expanding wildcards in SQL statements
Refactors
- How to refactor SQL databases with ApexSQL Refactor
- Avoid implicit name resolution of objects in queries by qualifying object names
- How to encapsulate code as a new stored procedure, a function, or a view
- How to set options for the Split Table refactoring method on SQL Server
- How to refactor SQL databases with ApexSQL Refactor
- How to refactor SQL databases with ApexSQL Refactor
- How to refactor SQL databases with ApexSQL Refactor
- How to refactor SQL databases with ApexSQL Refactor
- How to refactor SQL databases with ApexSQL Refactor
Qualify object names
Encapsulate SQL
Split table
Safe rename
Add surrogate key
Change parameters
Replacing one-to-many relationship
Command line interface
