IntroductionToday Microsoft has announced next version of SQL Server 2017 named as Community Technology Preview 2.0 is first production quality preview of SQL Server 2017 and it's available on both Windows and Linux. Download and Install SQL Server 2017 PreviewKey Enhancements and capabilities:- Ability to run advanced analytics using Python language in-database in a parallelized and highly scalable way
- Ability to store and analyse graph data
- Capabilities that help you manage SQL Server for high performance and uptime, including the Adaptive Query Processing family of intelligent database features and presumable online indexing.
- Microsoft Machine Learning Service - Enables Python scripts to be run directly within the database server, or to be embedded into T-SQL script
We can install and use SQL Server 2017 on MacOS, Docker, Windows, and Linux and quickly build an app in a programming language of your choice.
Fig: SQL Server 2017 Data Estate
|