Announced at Microsoft Ignite were some new product features related to data platform and AI. Below are the ones I found most interesting: Azure Cosmos DB adds distributed PostgreSQL support: Azure Cosmos DB now brings fast, flexible and scalable service … Continue reading →
Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform and AI related announcements: SQL Server 2022: A new version of SQL … Continue reading →
Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform and AI related announcements: Azure Arc enabled machine learning (preview): Build models … Continue reading →
As I was finishing up a demo script for my presentation at the SQL PASS Virtual Summit on 11/13 (details on my session here), I wanted to blog about part of the demo that shows a feature in the public … Continue reading →
I had a previous blog comparing Cosmos DB to a relational database (see Understanding Cosmos DB coming from a relational world) and one topic that it did not address that I want to now is how to handle reference tables … Continue reading →
A few data platform announcements yesterday at Microsoft Build that I wanted to blog about. The biggest one is Azure Synapse Analytics is now available in public preview! You can immediately log into your Azure portal and use it. While … Continue reading →
Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform related announcements, and I will follow-up with more details in future … Continue reading →
Cosmos DB is an awesome product that is mainly used for large-scale OLTP solutions. Any web, mobile, gaming, and IoT application that needs to handle massive amounts of data, reads, and writes at a globally distributed scale with near-real response times for … Continue reading →
Another Microsoft event and another bunch of exciting announcements. At the Microsoft Build event this week, the major announcements in the data platform space were: Multi-master at global scale with Azure Cosmos DB. Perform writes on containers of data (for example, collections, … Continue reading →
Microsoft Connect(); is a developer event from Nov 15-17, where plenty of announcements are made. Here is a summary of the data platform related announcements: Azure Databricks: In preview, this is a fast, easy, and collaborative Apache Spark based analytics platform optimized … Continue reading →
There are a tremendous amount of Microsoft products that are cloud-based for building big data solutions. It’s great that there are so many products to choose from, but it does lead to confusion on what are the best products to … Continue reading →
Many product announcements were made this week at Microsoft Ignite, and I wanted to give a quick overview of all the data platform related announcements: SQL Server 2017 on Linux, Windows, and Docker, generally available on October 2nd. SQL Server … Continue reading →
In SQL Server, scaling out reads (i.e. using Active secondary replicas via AlwaysOn Availability Groups) is a lot easier than scaling out writes. So what are your options when you have a tremendous amount of writes that scaling up will not handle, … Continue reading →
Another Microsoft event and another bunch of exciting announcements. At the Microsoft Build event this week, the major announcements in the data platform space were: Azure Cosmos DB Azure Cosmos DB is the next big leap in the evolution of … Continue reading →
There are various Microsoft tools that you can use to help you migrate your database (updated 1/16/19): Data Migration Assistant (DMA) – enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality … Continue reading →
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). … Continue reading →
I see a lot of confusion about the place and purpose of the many new database solutions (“NoSQL databases”) compared to the relational databases solutions that have been around for many years. So let me try to explain the differences … Continue reading →
A NoSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases. NoSQL is often interpreted as Not-only-SQL to emphasize that they may also support SQL-like … Continue reading →