Its the 80th T-SQL Tuesday and for some reason I decided to write a blog post.  This month’s host is a good friend, Chris Yates and since its his birthday he decided to give us a gift by opening the topic to “anything”

My topic of choice is simple and relates to Chris’s Present. SQL Server’s Birthday.  

I’ve worked with SQL Server in some form for longer than I care to admit so I thought it would be interesting to write down my memories of each release.  Why? I dont know, I guess because I can and perhaps just perhaps to compare notes with a few other “old-timers”

 

SQL Releases over the years  

SQL 6.5

  • a GUI on a DB? This was sheer madness
  • SQL Enterprise manager was revolutionary & light years ahead of the competition
  • Corruption, Corruption Corruption
  • I still miss ISQL_w sometimes (not really)
  • Shipped with actual printed books

SQL 7.0

  • Side by side unusable installs of SQL 6.5 and 7.0 during upgrades
  • I do miss the standalone Query Analyzer tool
  • DTS… oh the nightmares of DTS, they all start here

SQL 2000

  • Someone put XML in a database… AKA: Patient zero
  • You get a bigint and you get a bigint and you, bigints for everyone!
  • There was a disturbance in the force and SSRS appeared (Someone say it was SSAS that caused the disturbance but I disagree)
  • Put multiple instances of SQL on a server they said, it’ll be fun they said…… NOT

SQL 2005

  • SSIS appears, the lights suddenly dim and a clown jumps out of a box and says “Surprise”
  • Upgrade pain like no other “80” compatibility still haunts many-a-DBA
  • CLR is banished by DBA’s everywhere for being the devils magic and clearly evil
  • DTA appears and is quickly crowned with a dunce cap
  • SSNS came and went so quickly no one ever saw it
  • TSQL Window functions appear and developers rejoice!
  • BIDS shows up and BI developers lives are never the same

SQL 2008

  • PBM appears and quickly goes stale
  • Compression of all the things arrives but only if you spend mega bucks
  • DMV’s finally became useful
  • intellisense? what is this dark art that saves me from typing SLECT 1 more time
  • AlwaysOn, Alwayson, Always on, Who knows what it will be called today but the moniker appeared and Allan Hirt suddenly had more grey hair

SQL 2008R2

  • The SQL team joined the “R2” Parade and quickly got lost
  • The what edition of SQL do I need to do X game gets into high gear
  • PowerName All the things starts with PowerPivot
  • MasterDataServices appears and quickly goes stale

SQL 2012

  • Core licensing appears and the value proposition gets instantly more complicated
  • SSIS was disemboweled (Thankfully)
  • Column Store indexes were created to give Niko something to write about
  • AlwaysOn Availability Groups make DBA’s look like superheros
  • Extended event shaming becomes a thing
  • BIDS? SSDT? SSDT-BI? Data tools? The confusion is maddening

SQL 2014

  • The what edition do I need game takes another twist
  • SSMS is still treated like a stepchild
  • Hekaton changes the game (If you meet this teeny tiny list of caveats)
  • Azure is melted into the box product

SQL 2016

  • Someone put JSON in a database… AKA: Patient zero
  • Dynamic data masking and Row level security brings all the auditors to the yard
  • AlwaysEncrypted continues the pattern of “Always or Power” all the names!
  • QueryStore appears and DBA’s the world over are immediately confused by this black magic
  • Temporal tables appear and SQL Server catches up with postgres circa 2012
  • SSMS starts getting major love, everyone wonders if its a trick
  • SSDT is… wait…for…it… a SINGLE tool finally!

Future SQL Server

  • Can we get indexes on functions expressions *pretty please* If a mainframe can do it surely SQL can too
  • Banish the message “string or binary data may be truncated” to the history books
  • How about a tiny touch of love for Powershell (those guys yell loud enough that powershell can cure all my ills, how about giving them a proper hammer)
  • An edition based on size of server, pay for the T-SQL features you use based on server/database size *things like hekaton on small db’s* in a new “AlwaysPower” edition
  • *basic* Scalar UDF optimization to cache deterministic values

What did I miss?  Wait, I know I missed a lot so dont answer that.