Stuff & Things. Click Around!

MS SQL Tips

MS SQL Tips is an incredible resource for working with Microsoft data tools, from T-SQL scripting to Power BI. This site is invaluable to DBAs, Analysts, and anyone just beginning or curious. I think using the word "Tips" is a huge understatement; this site is nuanced, providing not just tips, but full on tutorials using advanced techniques.

SQL Shack

The SQL Shack is a huge collection of authors and articles about anything SQL. A navigation menu tree helps you navigate to topics of interest. Be prepared to open a thousand tabs as you get lost digging down the rabbit hole. Check your ADD on this one cause you'll need the focus. Dedicate a day to this site and see how much you can learn. Totally worth it.

Advanced SQL Puzzles

This is a personal site, much like my own with some excellent T-SQL content which includes a set of advanced SQL puzzles to solve. His github includes the code for creating a database for working on the puzzles, as well as solutions, and of course the PDF of the puzzles themselves.

Querying with Transact SQL

Here is a T-SQL tutorial from Microsoft themselves. Looks to be a bit dated, but the content is fairly comprehensive and MS approved, so you'll get it straight from the horse's mouth.