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

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

Sunday, 8 May 2016


SQLBits XV was held between 4 -6 May 2016 at the Exhibition Centre in Liverpool. It was the official UK launch event of SQL Server 2016 which will RTM 1st June. There were lots of amazing sessions held for the first time in domes.

The keynote was delivered by Joseph Sirosh, the corporate vice president of the Microsoft Data Group. His keynote entitled the unreasonable effectiveness of data. A paper was written by Alon Halevy, Peter Norvig, and Fernando Pereira of the same titleJoseph Sirosh mentioned the future effectiveness of data and the Sloan Digital Sky Survey, the 1st astronomy datascope. A take away was that there are many new data services and R should be the language to learn. 

There were many sessions covering the new features of SQL Server 2016 on both the BI and administration side. A highlight for me was the training day on data science by Buck Woody and using the Cortana Intelligence suite. 

The Cortana Analytics Suite big data and advances analytics process

The Azure IaaS and PaaS Services are embedded into these services.

U-SQL is another new language that allows you to query unstructured data. Michale Rys delivered a very informative session on Azure Data Lake and U-SQL. The traditional data warehousing approach is

  The new Data Lake approach

 The slides are http://www.slideshare.net/MichaelRys

 There are many new features in SQL Server 2016 and many new data features in Azure.

Monday, 2 May 2016

SQL Server 2016 General Availability

SQL Server 2016 will be generally available on 1st June 2016. The SQL Server 2016 editions will include Enterprise, Standard, Express, and Developer.  SQL Server 2016 Developer edition will be free to download.

The SQL Server 2016 preview details .

Friday, 22 April 2016

Database Research and Data's Journey

The first TechNet UK blog post was entitled Management of Database Systems Research and was a prĂ©cis of the database research I am undertaking. A comic strip was included telling the story of Data and the path that lead to starting the database research.  

My research journey has progressed and my new blog post crosses the boundary between academia and the industrial world of database systems. Data reprises his role taking the reader through the research journey and methods used.

Wednesday, 6 April 2016

Sunday, 3 April 2016

Microsoft SQL Server Developer Edition is now free

SQL Server 2014 Developer Edition is now a free download for Visual Studio Dev Essentials members

SQL Server Developer Edition is for development and testing only, and not for production environments or for use with production data.

Thursday, 10 March 2016

SQL Server 2016 Rocks

The SQL Server Data Driven event shared the forthcoming toolset to enable business transformation with data.

The directors of tomorrow will embrace technology to become leaders across industries. If you want to disrupt, you must adopt and adapt to new technology. Data is the connective tissue driving all technological revolution. Data assets are core to the success of a business.  It enables business to engage better with customers to transform products and services
T-SQL and R will be in one place for real time predictive analytics  and it is possible to extend databases into the cloud to allow customers to keep information they don't have local storage space for.  
SQL Server 2016 is always encrypted even when processing is being done and even if the in-memory engine being used, using homomorphic encryption.
SQL Server 2016 is a true data platform not just a database with mission critical intelligence which is what distinguishes it from all others.  SQL Server 2016 is key to business transformation. Intelligence driven from data is now enabling new ways of working.  
Data is at the heart of transformation enabling engagement with Customers, Running your Business and Transforming your Products.
Microsoft have created significant incentives to encourage people with Oracle databases to migrate to SQL Server.
You can run SQL Server 2016 in a docker container and also on Linux.