The SQL Server 2016 Essential Guide: The Modern Data Platform
Microsoft is getting ready to bring out the new SQL Server 2016 release and like every major release SQL Server 2016 introduces a lot of new features as well as a lot of enhancements to existing features. In this column I'll give you an essential guide to all the major enhancements in the SQL Server 2016 release. SQL Server has come a long way since it was originally released 27 years ago. Back in the early days of SQL Server 6.0/6.5 SQL Server was considered a departmental database that wasn't able to handle enterprise workloads. That all changed when Microsoft released SQL Server 7.0 back in 1998. With the SQL Server 7.0 release Microsoft rearchitected the relational database engine and added in the OLP Services and Data Transformation Services (DTS) laying the foundation for the data platform of today. With SQL Server 2000 Microsoft added XML support and improved scalability. SQL Server 2005 added SQL Server Management Studio and Database Mirroring. Plus, DTS was replaced ...