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

Wednesday, 10 May 2017

Azure Cosmos DB

Another database annoucment today from Microsoft. The first globally distributed, multi-model database service. Microsoft describe Azure Cosmos DB as containing a write optimized, resource governed, schema-agnostic database engine that natively supports multiple data models: key-value, documents, graphs, and columnar.

Azure Cosmos DB is an evolutionary leap for DocumentDB which states it contains APIs for accessing data including MongoDB, DocumentDB SQL, Gremlin (preview), and Azure Tables (preview).

Azure Cosmos DB contains a write optimized, resource governed, schema-agnostic database engine that natively supports multiple data models: key-value, documents, graphs, and columnar. 

The Key Capabilities
  • Turnkey global distribution
  • Multiple data models and popular APIs for accessing and querying data
  • Elastically scale throughput and storage on demand, worldwide
  • Build highly responsive and mission-critical applications
  • Ensure "always on" availability
  • Write globally distributed applications, the right way
  • Money back guarantees
  • No database schema/index management
  • Low cost of ownership

Monday, 1 May 2017

Interesting blog posts of the last month

These are a few blog posts I read last month which i found quiet interesting.

Azure SQL 
Resource Manager template reference now available
DEA 2.0 Technical preview: Release Overview – Database Experimentation Assistant: Overview
Azure Data Warehouse: Understanding the DWU, workload management, resource and memory allocation
Top 30 SQL Blogs  Websites for Microsoft SQL Server Administrators
Microsoft touts SQL Server 2017 as the first RDBMS with built-in AI

AWS Database Migration Service expands into NoSQL migrations with MongoDB & Amazon DynamoDB support



Getting started with R in SQL Server

Deep Learning

Build a recommendation system with the support for graph data in SQL Server 2017 and Azure SQL DB


The Data and Analytics Playbook: Proven Methods for Governed Data and Analytic Quality 1st Edition

Wednesday, 19 April 2017

Microsoft DataAmp – SQL Server 2017

The DataAmp webcast was packed full of announcements. The Webcast was delivered by Scott Guthrie and Joseph Sirosh. The SQL Server product delivering intelligence, trust and flexibility.

Microsoft confirmed that the next version of SQL Server is SQL Server 2017 and will be available simultaneously on Windows, Linux and Docker. Download the SQL Server 2017 datasheet.  It will be the first RDBMS to deliver AI with data. There is a convergence of cloud, data and intelligence. Delivering AI with data: the next generation of Microsoft’s data platform blog shares more information.  SQL Server 2017 Community Technology Preview 2.0 now available.

There were so many new features announced only a few are mentioned below.  There are adaptive query processing improvements which will enhance the performance of workloads. There is a You Tube video SQL Server 2017: Adaptive Query Processing discussing this. Threat detection is now in Azure SQL Database and is straight forward to configure. 

Hybrid Cloud just got easier to adopt with the new Azure migration resources and tools. To help with SQL Server migrations to the cloud features such as Service Broker, SQLAgent, Profiler etc. are now available in Azure. There is a new data migration service for automatic migration for SQL Server, Oracle and MySQL in Azure .

SQL Graph
Storing and analyzing graph data relationships. This includes full CRUD support to create nodes and edges and T-SQL query language extensions to provide multi-hop navigation using join-free pattern matching.  The SQL Server engine integration enables querying across SQL tables and graph data.

SQL Server on Linux

The official Microsoft repository for SQL Server in Docker containers is here.

Here are a few videos to help get you started with Linux:


SQL Server is the first commercial database to include Deep Learning algorithms, with the announcement of the Microsoft Cognitive Services general availability of the FACE API and Computer Vision API.
Azure Data Lake Services now have petabyte scale.
Azure Analysis Services became generally available. You Tube video: SQL Server 2017: BI enhancements.  
You can use Python for advanced analytics, You Tube video: SQL Server 2017: Advanced Analytics with Python

Azure DocumentDB

Azure DocumentDB is globally distrubuted and offer limitless scale of throughput and storage. It can be used for things such as IoT applications that need low response times and need to handle massive amounts of reads and writes.

Cortana Intelligence Solution Templates
You can now quickly build Cortana Intelligence Solutions from preconfigured solutions, reference architectures and design patterns. Some are released with more to follow.

The really important thing that I am excited about is the flexibility of choice within the SQL Server product.

Joseph Sirosh concluded comparing the industrial revolution with the intelligence revolution of today.