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 … Continue reading →
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 … Continue reading →
(updated 8/15/2019) 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 … Continue reading →
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 … Continue reading →