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

Wednesday, 1 November 2017

PASS Summit 2017 Day 1 Keynote

I attended PASS Summit 2017 which was my second year of
attendance. I enjoyed the conference enormously. It is enjoyable being immersed in data and being with people who are enthusiastic in the field.

The Day 1 Keynote "Microsoft for the Modern Data
Estate" was presented by Rohan Kumar. Data is driving transformation. Data, Cloud and AI are the three most disruptive trends of our time. The modern data estate, enables simplicity and common sense.
It takes any data from any source, structured or unstructured data and large or small data. The modern data estate provides a seamless infrastructure between on premises, private and public
cloud, enabling a hybrid set up that hides the dichotomy of these disparate
systems. Seamless flexibly and a choice of engines.

New features in SQL Server 2017

There are many changes to SQL Server 2017. SQL Server 2017 has industry leading performance and security
now on Linux and Docker. The key engine changes

Support for graph data and queries

Advanced Machine Learning with R and Python

Native T-SQL scoring

Adaptive Query Processing and Automation Plan Correction

SQL
Server 2017 will enable deployment in seconds on Linux and Windows containers
and has special pricing for SQL Server on Linux and Red Hat Enterprise Linux.

New Features Azure SQL Database

Azure SQL Database offers intelligent DBaaS, privacy and trust, seamless and compatibility and competitive TCO. There is seamless migration to the cloud with the cloud first approach
breading faster innovations. The list of changes presented