All right with you?
SQL Server 2017
Once again, Microsoft surprises us with its innovations in the SQL Server product. Less than a year after the release of SQL Server 2016, Microsoft is already preparing to release a new version of the product, which is SQL Server 2017. If we think about the previous versions (2000> 2005> 2008> 2012> 2014> 2016), we saw that the intervals started quite large between versions, and from the 2012 version onwards Microsoft started releasing new versions every 2 years. What the vast majority of SQL Server professionals expected was SQL Server 2018, but Microsoft has anticipated it and will release a new version (again).
As its competitors innovate in slow motion turtle steps, Microsoft is increasingly bringing a range of exciting new features, enhancements and news in a short span of time, as we saw in the post. SQL Server 2016 - News and Features List.
During the event Microsoft Data Amp, held on 19 / 04, SQL Server 2017 was introduced to the public (SQL Server 2017 Community Technology Preview 2.0), available for Windows and Linux.
Among the new features available so far, we can highlight:
- Using Python for Advanced Analytics (previously only possible with R)
- Official SQL Server Support on Linux, Including Documentation on MSDN
- Use of Graph extensions, which allow you to create relationships between data for better analysis and insights important to your business, very useful in scenarios such as fraud analysis, social networking, risk management, predictive analysis, etc.
- Adaptive Query Processing improvements, which will lead to workload improvements in many situations where classic Performance Tuning methodologies are not effective
- Resumable online indexing, an innovative feature that allows you to REBUILD an online index and PAUSE it as you wish, whether to free up resources on the server to perform some urgent process or any other need, and CONTINUE where you left off.
- It just runs faster. Several performance enhancements have been applied to SQL Server 2017, making your applications run faster with minimal (or no) effort.
See also the official videos of the new SQL Server 2017 features presented at the Microsoft Data Amp event:
- Security on Linux with Tommy Mullaney - http://bit.ly/2onopRi
- Build globally-scaled mobile apps in minutes with Kirill Gavrylyuk - http://bit.ly/2oQssXl
- What's new with Azure Learning Machine with Ted Way - http://bit.ly/2pDnahz
- Building an intelligent Bot with Paul Stubbs - http://bit.ly/2pDTHUX
- Transform healthcare with advanced analytics solutions with Todd Bergeson - http://bit.ly/2oWVHd3
- Adding intelligence to your applications using big data at scale with Saveen Reddy - http://bit.ly/2pSWLvQ
- SQL Server 2017: HA and DR on Linux with Mihaela Blendea - http://bit.ly/2oWZhUu
- SQL Server Virtual Machines: Getting Started with Luis Vargas - http://bit.ly/2pDUJAo
- Developing Xamarin based data-driven intelligent applications using Azure Data Services (ADS) with Tara Shankar Jana - http://bit.ly/2oWIeC0
- Enterprise-ready Data Warehousing in the Cloud with Josh Caplan - http://bit.ly/2o5j6K5
- Developing applications with SQL Server 2017 (Linux), Entity Framework, DevOps, and Azure with Tara Shankar Jana - http://bit.ly/2phlCgk
- Python based machine learning in SQL Server with Sumit Kumar and Vijay Jayaseelan - http://bit.ly/2pDTTmT
- SQL Server 2017: Building Applications Using Graph Data with Shreya Verma - http://bit.ly/2pSVpku
- SQL Server 2017: What's New in the Database Engine? with Travis Wright - http://bit.ly/2o5gPi4
- Overview of Microsoft Machine Language R package with Gleb Krivosheev and Yunling Wang - http://bit.ly/2oQKc4D
- Get started developing apps with SQL Server 2017 running on Linux with David Salgado - http://bit.ly/2oQBm6U
- Accelerate Your Journey to Advanced Analytics Solutions with Kuber Sharma - http://bit.ly/2o5l4Kp
- Get started with Azure Analysis Services with Josh Caplan - http://bit.ly/2oMZb1d
- What's New in 9.1 Server and SQL Server R Services with Nagesh Pabbisetty - http://bit.ly/2pDGTR3
- Transform retail with Advanced Analytics solutions with Esther Christoffersen - http://bit.ly/2ot8Fez
- Big data that's easy and productive with Azure Data Lake with Saveen Reddy - http://bit.ly/2otlwgK
- Transform traditional data warehouse with cloud and big data with Oliver Chiu - http://bit.ly/2phgmcC
- SQL Server 2017: Adaptive Query Processing with Joe Sack - http://bit.ly/2otjfSF
- Make your apps faster and more secure in SQL Server 2016 SP1 Standard and Express Edition with Travis Wright - http://bit.ly/2o5mMeT
- The app developer's managed cloud database (overview) with Lindsey Allen - http://bit.ly/2o5ke0p
- Transform manufacturing with Advanced Analytics solutions with Colin Masson - http://bit.ly/2oMA4vk
- SQL Server 2017: BI Enhancements with Christian Wade - http://bit.ly/2oo0Tne
- Breakthrough performance with SQL Server for data warehousing (new RAs) with Jamie Reding - http://bit.ly/2phsJWc
- Enable applications to beat the speed of light with planet-scale DocumentDB with Sayam Nair - http://bit.ly/2phxBuw
- Transforming Customer Care with Business Analytics and AI with Seayoung Rhee and Giampaolo Battaglia - http://bit.ly/2ot9hkm
- Deploy an intelligent solution with solution templates with Sachin Chouksey - http://bit.ly/2oMKOdj
- Build intelligence into your apps with SQL Server 2016 with Nellie Gustafsson - http://bit.ly/2oQRdCI
- What's new with Microsoft Cognitive Services with Anna Roth - http://bit.ly/2phpL4a
- Top reasons to run SQL Server on Azure VM with Luis Vargas and Wynn Johnson - http://bit.ly/2phgc53
- SQL Server 2017 Scale Out with Mihaela Blendea and Travis Wright - http://bit.ly/2otoqlX
- Modernize your database infrastructure with DBaaS in Azure with Lindsey Allen and Murat Ozturan - http://bit.ly/2pDKfDG
- Unleash your data from non-Microsoft data platforms with Murat Ozturan - http://bit.ly/2oWU1ju
Want to download and start testing SQL Server 2017 now?
- SQL Server 2017 for Red Hat Enterprise Linux
- SQL Server 2017 for Ubuntu Linux
- SQL Server 2017 for SUSE Linux Enterprise Server
- SQL Server 2017 for Linux Docker Container
- SQL Server 2017 for Windows
- SQL Server 2017 for Linux Virtual Machine on Azure
Azure SQL Managed Instance
As if the SQL Server 2017 news wasn't enough, Microsoft decided to innovate in the cloud as well. If a lot of people couldn't / wanted to migrate their SQL Server On Premises instances to Azure SQL Database due to lack of features like CLR, SQL Agent, cross-database usage, among others, this will no longer be an excuse, because Microsoft has announced that it will support SQL Server instances as a service, operating in a manner very similar to what we use today in our local instances.
This makes migrations to Azure easier than ever! In addition, responsibility for managing the VM, operating system, and configurations of SQL Server will remain in the hands of the DBA, but all cloud advancements are also present, such as Elastic Pool, Patching routines and automatic backups, facilities for add discs, etc.
This creates a compromise between a local SQL Server instance and the Single Database Model instances that currently work on Azure, allowing you to have more control and resources using the Managed Instance model or greater isolation using the Azure model. Single Database as shown below:
To learn more about this news, be sure to visit this link.
That's it folks!
A lot of news is coming to SQL Server.
Follow the blog to stay on top of all the news!