top 20 toolbelt tips - redgate · sql toolbelt redgate's sql toolbelt contains the...
TRANSCRIPT
Top 20 Toolbelt Tips
Tom Austin, Red Gate
About me
• Pre-Sales Engineer who has worked with Redgate SQL Server
tools since 2008.
• Worked with hundreds of clients across the globe, from start-
ups to FTSE/Fortune 100 companies and everything in
between.
• Specialises in helping clients to improve their approach to
Database Lifecycle Management (DLM)
• Recently been writing and delivering DLM training courses in
Europe and Asia
Tom Austin
Pre-sales Engineering
SQL Toolbelt
Redgate's SQL Toolbelt contains the
industry-standard products for SQL
Server development, deployment,
backup, and monitoring.
Together, they make you productive,
your team agile, and your data safe
1. Colour code your databases
2. Find your dependencies
3. Standardise your layout
4. Standardise your code
5. Undo Changes
6. Find references quickly
7. Don’t write documentation…ever
8. Spot drift before someone else does
9. Never lose a query
10. Quickly fill a table for testing
11. Customise your generated data
12. Run your queries once
13. Banish wildcards!
14. Clean up your database
15. Customise your deployment scripts
16. Script as insert
17. Rename your alias
18. Switch tools fast
19. Follow best practices
20. Never forget a where clause
“I didn’t know we had that”
“I didn’t realise that was in the bundle”
-Sooo many people I speak to!