SQL Relay R2

The second SQL Relay event this year was kicked off in Reading. I again was pleased to help out at this event. Microsoft opened with the Cloud OS Vision. The premise of how it unlocks insights on any data, transforms the datacentre, empowers people-centric  IT and enables modern business applications.  The future is about hybrid IT, and with the data explosion and rapid evolution being underway a rapid lifecycle is required.   There is a continuous offering from private to public cloud with various taxonomies towers; Physical, Virtual, IaaS, PaaS and SaaS.

There was a session on the new engine taken from this paper, SQL Server 2014 In-Memory OLTP (“Hekaton”)Whitepaper for CTP2 by Kalen Delaney.

An interesting sessionwas delivered positioning Enterprise Information Management including MDS, DQS and Integration Services. For clarity these services were defined as

DQS (Data Quality Services) is a knowledge driven data quality solution enabling IT pros and data stewards to easily improve the quality of their data

MDS (Master Data Services) is the set of data objects at the centre of business activities (customers, products, cost, locations, assets, tasks etc.)

There were many other great sessions during the day.