Here are some of the most useful SQL Server-related links and utilities I’ve found on the Interwebs, in no particular order:
Structured Concepts (sqlsunday.com)
Docs and reference
- Hugo Kornelis’ excellent Execution Plan Reference (work in progress)
- Jim Donahoe’s Configuring tempdb on Azure VM
- sqlserverupdates.com: quick-reference links to most recent versions of SQL Server.
SQL Server scripts
- Brent Ozar’s first responder kit: open-source project including sp_Blitz, sp_BlitzCache, sp_BlitzFirst and sp_BlitzIndex
- Ola Hallengren’s SQL Server maintenance scripts: automate and simplify backups, rebuilds and defragmentation.
- sp_whoisactive: Adam Machanic’s sp_who replacement
- Glenn Berry’s DMV queries
SQL Server tools
- SQL Server Management Studio: latest stand-alone version of SSMS.
- SQL Query Stress allows you to run multiple, concurrent queries on a server.
- Azure Data Studio: the artist formerly known as SQL Operations Studio – is the new, open-source, cross-platform SQL Server management tool.
- statisticsparser.com: turns the text output from SET STATISTICS into readable, sortable tables.
- pastetheplan.com: allows you to copy/paste the query plan XML and share it with other people
- SentryOne Plan Explorer: powerful tool to analyze execution plans in SSMS and ADS
System tools
- Sysinternals is a set of Windows utilities built and maintained by Mark Russinovich
PowerShell
- Installing PowerShell on Windows, Mac, Linux
- dbatools: The industry-standard PowerShell management tools for SQL Server
Docker, Kubernetes
- Lens, an IDE for working with Kubernetes
Community
- #sqlhelp on Twitter: short-form questions
- dba.StackExchange: longer-form questions
- SQL Community Slack channel: click here for an invite!
Conferences
- SQL Saturday: SQL Saturday is back after the demise of PASS
- Data Saturdays: the independent data community initiative for free, one-day Saturday conferences
- Group By: online data platform conference
- SQL Friday: weekly lunch-and-learn event
- Data Weekender: a popup online data platform conference