"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein

Sunday, 1 October 2017

Microsoft for the Modern Data Estate

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.

Announcements

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.

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.