Azure SQL Devs’ Corner

Voices from the Azure SQL PM Team, focusing on development and developers

Image sql database 3 560
Optimize Azure SQL Upsert scenarios
AvatarMay 28, 2020May 28, 202005/28/20
Customers often need to move a dataset from a source system into a new destination, inserting rows that doesn't exist in a target table and update those that already exists. With this technique, we've been able to reduce the time needed to upsert a dataset of 2M rows against a target table with 30M rows from 20 hours to 20 minutes. 
Image sql database 3 560
DevOps for Azure SQL
Arvind ShyamsundarMay 20, 2020May 20, 202005/20/20
DevOps is a broad term with multiple technology and process options at hand. Read this post for an overview of what DevOps for Azure SQL means, and review some options for tools and processes to use.
Image sql database 3 560
Join us: Azure SQL at Microsoft Build 2020
AvatarMay 15, 2020May 15, 202005/15/20
Don't miss Microsoft Build 2020, this year delivered 100% online and 100% free. Make sure to attend to Azure SQL and SQL Server sessions, to see with your own eyes what you can do with all the features that we packed in these two amazing post-relational databases!
Image sql database 3 560
10 reasons to use Azure SQL in your next project
AvatarApril 25, 2020Apr 25, 202004/25/20
There are many database technologies available on Azure that you can choose from. Why would you use Azure SQL? Let me show you why, using just 10 simple points: from JSON support to ColumnStore, through Geospatial and Temporal queries, Non-Blocking transaction, Encryption and Row-Level Security and the amazing Intelligent Query Optimizer.