Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk . Microsoft Data Platform MVP

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

Wednesday 29 July 2015

SQL Server 2016 New Features

Query Store
The Query Store feature maintains a history of query execution plans with their performance data. This allows you to quickly identify queries that have become slower recently and use different query plans. 

This was introduced into the data warehouse appliance Analytics Platform System in 2015. It is a connector between Hadoop (and Azure Blob Storage) and its data warehouse appliance Analytics Platform System. This functionality is incorporated into the regular on-premises product. 

Stretch Database
The is a hybrid feature to help reduce storage and processing cost and some of your tables will be moved into an Azure SQL Database in the cloud. 

JSON Support
SQL Server 2016 adds support for the lingua franca of Web applications: Java Script Object Notation (JSON).

Row Level Security
This restricts which users can view what data in a table, based on a function which could be useful in multi-tenant environments.

In-Memory Enhancements
This feature will support foreign keys, check and unique constraints and parallelism. Additionally, tables up to 2TB are now supported (up from 256GB).

Alwayson Enhancements
There are some enhancements to Alwayson.

Tuesday 28 July 2015

Administering Microsoft SQL Server 2012 Databases

Useful links whilst studying for 70-462

Exam Syllabus

Skills Measured

Exam Prep Videos
MCSA Certification Prep | Exam 462: Administering Microsoft SQL Server 2012 Databases

Microsoft Virtual Academy 
Administering Microsoft SQL Server 2012 Jump Start

Training Kit Book
Training Kit (Exam 70-462): Administering Microsoft SQL Server 2012 Databases

Ebook: Introducing Microsoft SQL Server 2012

Books online for SQL Server 2012

Tuesday 7 July 2015

2014 ACM Turing Award

Michael Stonebraker received the 2014 ACM Turing Award. Michael Stonebraker was recognized for fundamental contributions to the concepts and practices underlying modern database systems.  The A.M. Turing Lecture is here.