SQL Server Reference & homepage

SQL Server
product 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

  • GLASS (Greater Lansing Area for SQL Server)
  • SPID (Detroit, click on the “Follow” button, or even better, get on their email list

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

SQL Server
product documentation

My local group (Greater Lansing Area for SQL Server)

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

Get Started Querying with Transact-SQL, a learning path from Microsoft Learn

Stairway to T-SQL DML (Data Manipulation Language) at SQLServerCentral

Describe SQL Server query plans, also a learning path from Microsoft Learn

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)

Microsoft SQL Server Version List
Lists all of the know Service Packs, Cumulative Updates, Patches, Hotfixes, and other builds of SQL Server back to SQL Server 6.0)

And from SentryOne, Category: SQL Server Builds

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

Guidelines for online index operations

Encryption references

Encryption Hierarchy
Backup Encryption
Transparent Data Encryption (TDE)
Always Encrypted (Database Engine)


Training To-Do List for New DBA by William Assaf at SQL Tact

SQLServer Tutorial website (SQL Server {querying} basics)

The “SQL Hall of Shame” by Adam Machanic

Early History of SQL by Donald D. Chamberlin (found at the IEEE website, ~ 5 pp.)