The Microsoft Ignite session on the modern data estate was full of announcements. All around us, data is driving digital transformation. Modernize with SQL Server 2017 on Linux and Windows and Azure Data Services; deliver modern intelligent applications using technologies like Azure Cosmos DB and Azure Database for PostgreSQL.
The world is changing. We need to help invest in the future without being tied to the past. AI is a fundamental pillar to leverage that. If businesses invests in data they outperform other companies.
Data doesn’t need to leave the database for data science to take place.
The cloud first approach breeds faster innovation and SQL Server 2017 is proof of that.
SQL Server 2017 on Linux, Docker , and Windows server
Supports for graph data and queries
Advances Machine Learning with R & Python
Native T-SQL scoring
Adaptive Query processing and Automatic Plan Correction
Vulnerability assessment for GDPR - preview
Intelligent insights into performance – preview
Support for Graph data and queries –GA
Adaptive query processing – GA
Native scoring and support for Azure Machine Learning - GA
SQL Database and Database Migration Service
Migration to the cloud is easy with this new service.
Azure SQL Database is the intelligent cloud database for app developers. It learns and adapts, scales on the fly, enables multi-tenant SaaS apps, works in your environment, secures and protects. The systems of intelligence on SQL Database is shared.
Globally Distributed Applications
Announcing Azure functions for Azure Cosmos DB to build apps faster with a serverless infrastructure.
Uncovering insights with big data and advanced analytics
The new Azure Data Factory allows easy modelling of diverse data integration scenarios. You can now with the preview service, easily move your SQL Server Integration Services (SSIS) workloads to cloud. There is also a data movements as a service with 30+ connectors. Azure SQL Data Warehouse has a compute- optimized tier and unlimited columnar storage in preview. The last announcement was the Power BI Report Server.