I was recently having a conversation with someone and they asked me what some good resources were to begin writing SQL. So I thought it would be a good idea to compile a quick list of places I like to go and people I like to read.
The First thing to check out
SQL Server Central has many good “Stairways” that can help guide you through different aspects of SQL.
For starters:
Where to start – SQL DML (Data Markup Language) Stairway
After that – Beyond the Basics Stairway
And then – Advanced TSQL Stairway
Then depending on the topic there are other stairways that you can review.
Topic Specific recommendations
While there is a lot of overlap in topics and many, many more great authors and articles here are some go to names depending on what you are looking into below.
Amazing Performant SQL – Itzik Ben-Gan and Jeff Moden
Execution Plans and Operators check out Fabiano Amorim and Paul White.
Database Corruption check out Paul Randall (he actually rewrote DBCC CHECKDB some time ago) and Gail Shaw
SQL Internals – Kimberly Tripp and Kelan Delaney
Indexing – Gail Shaw
Hardware Setup – Glenn Berry
If you are interested in Microsoft’s BI Stack then there is a lot of good webinars and content you can check out over at Pragmatic Works where Brian and Devin Knight and crew do some great work.
Further Learning
If you still feel the need to scratch that learning itch here are some other
Websites
All-Stars
- Grant Fritchey
- Brent Ozar
- Jes Borland
- Jeremiah Peschka
- Kendra Little
- Jonathan Kehayias
- Erin Stellato
- Jamie Thompson
- Matt Masson
- Buck Woody
- Connor Cunningham
- Plus many more.
Feel free to reach out if there is a specific topic you are interested in and I can point you at an author or resource I would recommend.
Have you been researching any topics and found a great webinar or article? Maybe you have a favorite SQL All-Star?
Let us know in the comments below.
