SQL Server Reference & homepage

Odd trivia…who do you know that has “S“, “Q“, and “L” contained in their last name (and, in the right order, like SQUILLACE)?


I strongly support participation in your local user group Professional Association for SQL Server

SQL Saturday, free, one-day training events all over the world

My local group (Greater Lansing Area for SQL Server)


Here’s a list of recommended email newsletters and sites to which you should subscribe


List of some select, free ebooks from SimpleTalk/Redgate Hub


DML Query clause order (for SELECT, INSERT, UPDATE, DELETE)

Select ____(column list)____________________________
From __________[ JOIN(s) ] [ APPLY ]_______________
Where ____________________________________________
Group By _________________________________________
Having ___________________________________________
Order By _________________________________________

Remember this as “SFJOWGHO”. Does that help? Student Susan Svoboda suggests “Some Freak JO Watches GHOsts.”


Watch my 14 minute YouTube video called “Structure of a Relational Database


September 2019 User Group Presentation – Free Resources for SQL Server


Transact-SQL Reference (Database Engine)


History of Microsoft SQL Server (Wikipedia) (shows SQL Server version history)


Microsoft SQL Server (Wikipedia article, describes various features, services, and editions)


In the fall of 2013 my colleague Rich Currey and I delivered two live Microsoft Virtual Academy presentations on SQL Server 2012

Provisioning a New SQL Server Instance – series by Glenn Berry at Redgate Hub

Part One Part Two Part Three


sp_Blitz® – Free SQL Server Health Check Script (SQL Server Takeover Script)

Master list of SSMS Tricks and Shortcuts