Tools and Tips For Data Warehouse Developers

Cathrine Wilhelmsen's Tools And Tips For Data Warehouse DevelopersYou 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:
Cathrine Wilhelmsen SQLBits XIV: Tools and Tips for Data Warehouse Developers

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
SQL Hunting Dog
SqlSmash

Data Modeling and Mockups
SQL Database Modeler
Mockaroo
List of Random Names

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