You can find links to all the resources, tools and products mentioned in my Tools and Tips for Data Warehouse Developers (sometimes called Tools and Tips: From Accidental to Efficient Data Warehouse Developer) session on this page. I have also added a bunch of other useful resources that I use, but didn’t mention in my session.
Increase that productivity today! :)
Recorded Session
You can watch the entire recording of my Tools and Tips for Data Warehouse Developers session on the SQLBits XIV page:
Slide Decks
The slide deck for my Tools and Tips for Data Warehouse Developers session at SQLBits XIV:
The latest version of my Tools and Tips for Data Warehouse Developers slide deck:
Resources
SQL Server
SQL Tools and Utilities for SQL Server
Download SQL Operations Studio
Download SQL Server Management Studio
Biml
Biml Resources and References
Keyboard Shortcuts
Andy Mallon’s Shortcuts Cheat Sheet – SSMS & Windows
Kendra Little’s SSMS Shortcuts and Secrets on SQLWorkbook.com
SQL Server Management Studio Keyboard Shortcuts
Advanced Snippets and Formatting Products
Redgate SQL Prompt (Licensed)
ApexSQL Complete
ApexSQL Refactor
SSMS Tools Pack (Licensed)
SSMS Boost
Poor Man’s T-SQL Formatter
dbForge SQL Complete (Licensed)
Instant SQL Formatter
SqlSmash
Search in SQL Server Management Studio
Redgate SQL Search
ApexSQL Search
SSMS Tools Pack (Licensed)
SSMS Boost
SqlSmash
Data Modeling and Mockups
SQL Database Modeler
Mockaroo
List of Random Names
Google Dataset Search
Execution Plans
SQL Sentry Plan Explorer
Paste The Plan
Supratimas Online Plan Explorer
Free eBook: SQL Server Execution Plans by Grant Fritchey
Statistics
Statistics Parser
Free eBook: SQL Server Statistics by Holger Schmeling
Scripts
sp_WhoIsActive
sp_Blitz
sp_BlitzCache
sp_BlitzFirst
sp_BlitzIndex
sp_helpExpandView
Minion Reindex
Ola Hallengren’s Maintenance Solution
Performance
David Peter Hansen’s List of Free SQL Server Performance Troubleshooting Scripts and Tools
Books
Redgate Free eBooks
Videos
Rob Farley – Understanding SARGability (to make your queries run faster)
Bonus Tools and Tips
These aren’t specific to SQL Server, Data Platform or Data Warehouse Developers, but they are useful for other tasks or help increase my productivity :)
Productivity
Toggl
Image Optimization
TinyPNG
TinyJPG
SVGOMG
Software Management
Total-Uninstaller