Welcome

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



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.

Wednesday 9 March 2016

Announcing SQL Server on Linux

Microsoft have announced SQL Server on Linux to make their data solutions more flexible. The target date for availability is mid-2017.

More details
https://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux/

Monday 7 March 2016

SQL Server 2016 release candidate

The rapid release model for SQL Server 2016 means Microsoft will be publishing multiple release candidates.

Product enhacements include

  • Stretch Database service
  • Enhancements to In-Memory OLTP
  • Enhancements to SQL Server Analysis Services
  • Enhancements to SQL Server Reporting Services

The SQL Server evaluation can be downloaded from https://www.microsoft.com/en-gb/evalcenter/evaluate-sql-server-2016