1 / 24

where does your journey start?

Join Rolf Tesmer, Azure Cloud Architect, as he takes you on a light-hearted look at the journey of SQL Server from its inception in 1989 to the present day. Discover the milestones, partnerships, and innovations that have shaped SQL Server's evolution over the last 30 years.

larita
Download Presentation

where does your journey start?

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. where does your journey start?

  2. SQL Server Saturday #875 – Sydney Key Note – 2019 “An Incredible Journey” (a light-hearted look at the journey of SQL Server) Rolf Tesmer | Azure Cloud Architect | https://www.linkedin.com/in/rolftesmer/ How did we get here? Where will we go next? ref: https://en.wikipedia.org/wiki/Microsoft_SQL_Server ref: https://en.wikipedia.org/wiki/History_of_Microsoft_SQL_Server

  3. So lets step way back… to 1989! Ronald Regan & George H W Bush ref: https://en.wikipedia.org/wiki/1989 Voyager 2 Flyby of Neptune and Triton (moon) ref: https://en.wikipedia.org/wiki/1989 …and I’m still completing Y11 High School.

  4. 3 friends got together one summer and built something special SQL Server 1.0 16 bit, for IBM OS/2 Sybase,Ashton-Tate, Microsoft SOLD 2010 RIP 1991 US$1T 2019 ref: https://en.wikipedia.org/wiki/Microsoft ref: https://en.wikipedia.org/wiki/Ashton-Tate ref: https://en.wikipedia.org/wiki/Sybase

  5. This great partnership started an INCREDIBLE Journey that would last to this very day more than 30 years later

  6. By 1993 things had moved forward (4 years later) SQL Server 4.21 The First Database on Windows NT (and first version of SQL not to run on an x286 chip) Heralds a new era on Windows

  7. But alas, a sad eventin 1995 An unfortunate breakup… …BUT a new future? Sybase!= Microsoft …And as luck should have it, I’m out of University ready for a career as a DBA!

  8. And thus in 1995…we welcome… SQL Server 6.0 (the first release independent of Sybase) • yes, that was 24 years ago… • Microsoft’s Entry into the Enterprise Database Market

  9. Scoot forward quick to 1996 and a quick flash past the dot versions SQL Server 6.5 Code Name: Hydra What changed? Mmmm, ah, fixes?

  10. Now it’s 1998 ten yearssince the 1st version SQL Server 7.0 Conversion from C  C++ • Data pages go from 2k to 8k, Extents go from 16K to 64K, User Mode Scheduling (UMS), support for fibers, ++ • But its also a sad day, SQL ejects the ALPHA o/s platform welcome a “little brother”,OLAP Services

  11. A short trip to year 2000Its Y2K, and nothingbreaks…?! SQL Server 2000 Hello 64 bit SQL - ! Hello Multi-Instances - ! ( …and, oh boy, hello to the “joy” of multi-instance-version management!  ) LET’S PARTY LIKE ITS 1999 • we welcome “little sisters” SSIS & SSRS

  12. Skip ahead 5 years, its 2005Yukon, why a 5-year Wait?? SQL Server 2005 It’s a complete conversion to Microsoft code base (For the first time ever, there’s no original Sybase code) The world falls in love with XML, so does SQL Also welcome CLR, CTE, DMV, MARS, Snapshots • SQL 2005 SP1 adds Database Mirroring

  13. Double years 2008and 2010in 2 short years EVERYTHING changes In 2008 Microsoft Announces Windows Azure In 2010 Windows Azure is RELEASED Azure SQL Database (PaaS) SQL Server 2008and 2008 R2 The development teams GO LARGE SQL Spatial, Compression, TDE, Data-Tier Apps, Resource Governor, Intellisense, Microsoft buys Dundas BLOB & Filestream data types (unstructured) Powershell, Power Pivot, MDS, Stream Insight, Itanium We welcome Evergreen SQL Versions The beginning of No More Upgrades

  14. Now we’re in 2012 and we settle into a release cadence… SQL Server 2012 Adding SQL Always-On Column Store Indexes OLE DB(use ODBC instead)

  15.  2014 …more solid cadence… + Azure SQL Data Warehouse MPP in the Cloud SQL Server 2014 In-memory tables (aka Hekaton), buffer pool extension HelloHybrid Cloud! Ability to backup to Azure! Ability to run Always-On Nodes on Azure!

  16. In 2015 Something… …Awesome… …Happened. After 26 years and 14 versions SQL Server takes #1 spot credit: Gartner Magic Quadrant for Operational Database Management Systems, 2015 ref: https://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux/

  17. But no no, lets not stop now  2016…even more solid cadence! SQL Server 2016 • The world falls in love with XMLJSON, so does SQL Query Store, Temporal Tables, Always Encrypted, Dynamic Data Masking, RLS P O L Y B A S E

  18. Arrghhh! :) Are we there yet? (anyone with kids will already know the answer to this) NO! • We’re only 11 versions in… • …and 27 years down…

  19. By 2018, More Linux than Windows run in Azure 2017Loving the new Microsoft! + Azure SQL Managed Instance SQL Server 2017 • Newsflash:Microsoft + OSS = Awesome! • Hello Linux, Docker, Python • …and some other superkick-ass stuff like… • Resumable indexing, adaptive queries, automatic tuning, graph database, scale out SSIS, Tabular model SSAS default, ++

  20. PHEW!Finally… its 2019 SQL Server 2019(RC Release) + Azure SQL Database Edge + Azure SQL Database Serverless + Azure SQL Database Hyperscale Data Virtualisation[think PolyBase but with SQL, Oracle, Teradata, Mongo, ODBC] Big Data Clusters (Spark, Kubernetes, Jupyter)

  21. What has SQL become?  or but hey, that’s not the important bit THE SWISS ARMY KNIFE DATABASE IT’S ALIVE!

  22. What to expect…2020and beyond? Expectmore … Cloud First strategy! Expectmore … AI/ML Features! Expectmore… Intelligent Automation! Expectfaster … Release Cadence!

  23. But that’s STILL not the important bit… This Journey is about YOU This is YOURopportunity… What new skills do YOU need to succeed? How will YOUembrace the change moving forward? What can YOU do to help your techcommunity? but do give pause and remember where this data journey started all those 30 years ago… because it’s…

  24. SQL Server • Forever!

More Related