Microsoft Connect(); is a developer event from Nov 16-18, where plenty of announcements are made. Here is a summary of the data platform related announcements:
- Azure Data Lake Analytics is generally available in two datacenters in US (EMEA coming in Feb). Azure Data Lake Analytics is a cloud analytics service…
Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. I’m writing a set of blogs covering the major announcements. Next up is the Microsoft Professional Program for Big Data.
With Windows Server 2016 just been released, now is the perfect time to build an Azure VM with SQL Server 2016 on Windows Server 2016. In a matter of minutes you can be playing and learning both platforms. Below I will document the steps I took to build the VM… Read more
Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. I’m writing a set of blogs covering the major announcements. Next up is the free trial of Azure SQL Data Warehouse (SQL DW).
Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. I’m writing a set of blogs covering the major announcements. Next up is the technical Preview for Power BI reports on-prem in SSRS.
The Technical Preview is a pre-configured Virtual Machine in the… Read more
Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. I’m writing a set of blogs covering the major announcements. Perhaps the biggest one is the introduction of the Azure Analysis Services Public Preview (OLAP).
This is a PaaS for SQL Server Analysis… Read more
Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. My next few blogs will cover the major announcements. This first one is about the Data Migration Assistant (DMA) tool v 2.0 general availability and the technical preview of Database Experimentation Assistant (DEA). Read more
Microsoft Data Warehouse Fast Track for SQL Server 2016 is a joint effort between Microsoft and its hardware partners to deliver validated, pre-configured solutions that reduce the complexity of implementing a data warehouse on SQL Server Enterprise Edition. The Data Warehouse Fast Track program provides flexibility of solutions and customer… Read more
A recent Microsoft blog post announced that they are releasing five new Microsoft Certified Solutions Expert (MCSE) and Developer (MCSD) specialties. These credentials are aligned to Centers of Excellence, used by the Microsoft Partner Network to identify technical competencies that are widely recognizable by both Microsoft partners and customers. All… Read more
Cortana Intelligence Solutions is a new tool just released in public preview that enables users to rapidly discover, easily provision, quickly experiment with, and jumpstart production grade analytical solutions using the Cortana Intelligence Suite (CIS). It does so using preconfigured solutions, reference architectures and design patterns (I’ll just call… Read more
In my role as a Data Platform Solution Architect (DPSA) at Microsoft, part of my responsibility is to keep up with all the Microsoft on-prem and cloud data-related technology and trends, as well as non-Microsoft technology and trends in areas such as Hadoop and NoSQL. I work with Microsoft clients… Read more
One thing I try to do in my role with Microsoft is to get clients to think of possible use cases for building solutions in the Azure cloud. To set off light bulbs in their heads. Sometimes this is accomplished by showing them demo’s of existing solutions. It’s that old… Read more
SQL Server 2016 introduces a very cool new feature called real-time operational analytics, which is the ability to run both analytics (OLAP) and OLTP workloads on the same database tables at the same time. This allows you to eliminate the need for ETL and a data warehouse in some cases… Read more
A new performance level for Azure SQL Database was recently announced, called P15. This new offering is more than two times more powerful than the next best offering, P11. P15 offers 4000 database transaction units (DTU) where P11 offered 1750 DTU’s. Also, the max concurrent workers and concurrent logins increased… Read more
I am sometimes asked to compare Azure SQL Database (SQL DB) to Azure SQL Data Warehouse (SQL DW). The most important thing to remember is SQL DB is for OLTP (i.e. applications with individual updates, inserts, and deletes) and SQL DW is not as it’s strictly for OLAP (i.e. data… Read more
Lambda architecture is a data-processing architecture designed to handle massive quantities of data (i.e. “Big Data”) by using both batch-processing and stream-processing methods. This idea is to balance latency, throughput, scaling, and fault-tolerance by using batch processing to provide comprehensive and accurate views of batch data, while simultaneously using real-time… Read more
For companies that sell an on-prem software solution and are looking to move that solution to the cloud, a challenge arises on how to architect that solution in the cloud. For example, say you have a software solution that stores patient data for hospitals. You sign up hospitals, install the… Read more
In brief, SQL DW is a fully managed data-warehouse-as-a-service that you can provision in minutes and scale up in seconds. With SQL DW, storage and compute scale… Read more
I see a lot of confusion when it comes to creating a private cloud. Many seem to think that by virtualizing your servers in your local on-premise data center, you have created a private cloud. But by itself, virtualization falls far short of the characteristics of a private cloud and… Read more
The pricing for Azure SQL Data Warehouse (SQL DW) consists of a compute charge and a storage charge. For compute, it is not based on hardware configuration but rather by data warehouse units (DWU). DWU can be scaled up or down via a sliding bar in just a… Read more