There are three Azure SQL products with so many different deployment options, service tiers, and compute tiers that it can get quite confusing when choosing the right option for your workload. So, I thought I would write this blog to … Continue reading →
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 →
There are various ways to keep SQL Server databases and SQL Database/SQL Managed Instance (SQL MI) databases in-sync asynchronously that I will discuss in this blog. The main use cases for syncing databases are to distribute reads (i.e. a second … Continue reading →
For those companies that can’t yet move to the cloud, have certain workloads that can’t move to the cloud, or have limited to no internet access, Microsoft has options to build your own private on-prem cloud via Azure Stack and … 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: Usage-based optimization with Azure Synapse and Power BI: A new … Continue reading →
I have wrote a number of blogs on the topic of business continuity in SQL Database before (HA/DR for Azure SQL Database, Azure SQL Database high availability, Azure SQL Database disaster recovery) but with a number of new features I … Continue reading →
It used to be that the only way to use SQL Server Management Studio (SSMS) against Azure SQL Database Managed Instance (SQLMI) was to create a VM on the same VNET as SQLMI and use SSMS on that VM. That … Continue reading →
(Disclaimer: This blog has potentially outdated information, so please check the current pricing page) At Microsoft Ignite, one of the announcements was for Azure SQL Database Hyperscale, which was made available in public preview October 1st, 2018 in 12 different Azure regions. SQL … Continue reading →
Read Scale-Out is a little-known feature that allows you to load balance Azure SQL Database read-only workloads using the capacity of read-only replicas, for free. As mentioned in my blog Azure SQL Database high availability, each database in the Premium tier (DTU-based … Continue reading →
My last blog post was on Azure SQL Database high availability and I would like to continue along that discussion with a blog post about disaster recovery in Azure SQL Database. First, a clarification on the difference between high availability and … Continue reading →
In this blog I want to talk about how Azure SQL Database achieves high availability. One of the major benefits from moving from on-prem SQL Server to Azure SQL Database is how much easier it is to have high availability … Continue reading →
There are a number of options to monitor Azure SQL Database. In this post I will briefly cover the built-in options and not 3rd-party products that I blogged about a while back (see Azure SQL Database monitoring). Monitoring keeps you alert … Continue reading →
Microsoft has announced the public preview of Azure SQL Database Managed Instance. I blogged about this before. This will lead to a title wave of on-prem SQL Server database migrations to the cloud. In summary: Managed Instance is an expansion … 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 →
Azure SQL Database Managed Instance is a new flavor of Azure SQL Database that is a game changer. It offers near-complete SQL Server compatibility and network isolation to easily lift and shift databases to Azure (you can literally backup an … Continue reading →
Yesterday was the Microsoft Data Amp event where a bunch of very exciting announcements were made: SQL Server vNext CTP 2.0 is now available and the product will be officially called SQL Server 2017: Runs on Linux and Docker Support … Continue reading →
Azure SQL Database (SQL DB) has increased its max database size from 1TB to 4TB at no additional cost. Customers using P11 and P15 premium performance levels can use up to 4 TB of included storage at no additional charge. … 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 →