A collection of developer productivity articles covering SQL code complete and SQL coding topics
SQL code layout
SQL code auto-replacements
CRUD procedures
SQL code structure
SQL code snippets
- How to code faster with SQL Server code snippets
- How to create and use T-SQL code snippets
- Improving productivity with SQL snippets
Executed SQL code
- How to track executed SQL Server queries
- How to track queries in SQL Server Management Studio and Visual Studio
- Retrieve unsaved SQL query scripts due to SQL Server Management Studio crash
Safe SQL code practices
- How to prevent accidental data loss from executing a query in SQL Server aka “Practicing safe coding”
- How to set different connection colors in SSMS
- Fatal action guard: guarding against inadvertent execution of code that may damage or destroy data in SQL Server
SQL results Import/Export
- How to Import and Export SQL Server data to an Excel file
- How to export SQL Server data to a CSV file
- SQL Server Management Studio (SSMS) – how to save results with headers
SQL productivity tools
- Boost your productivity using ApexSQL Fundamentals Toolkit for SQL Server
- How to query data using a SELECT statement in SQL Server
- Top things you need in a SQL Server coding productivity tool
