Select Page

The February release of SQL Operations Studio is now available

This post is authored by Alan Yu, Program Manager, SQL Server. We are excited to announce the February release of SQL Operations Studio is now available. Download SQL Operations Studio and review the Release Notes to get started. SQL Operations ... continue reading

Sync SQL data in large scale using Azure SQL Data Sync

This post is authored by Xiaochen Wu, Program Manager, SQL Server. Azure SQL Data Sync allows users to synchronize data between Azure SQL Databases and SQL Server databases in one-direction or bi-direction. This feature was first introduced in 2012. By ... continue reading

Migrating to Azure SQL Database with Zero Downtime for Read-Only Workloads

Special thanks to MSAsset engineering team’s Peter Liu (Senior Software Engineer) and Shail Batra (Principal Software Engineering Manager) for sharing their migration story with the Azure SQL Database product team. Microsoft uses an internally written service called MSAsset to manage ... continue reading

JSON in SQL Server – Use cases

JSON support in SQL Server 2016+ and Azure SQL Database enables you to combine relational and NoSQL concepts and easily transform relational to semi-structured data and vice-versa. JSON is not a replacement for the exiting relational models, and there are ... continue reading

Simplify REST API development for modern Single-page apps with SQL Server

JSON functionalities that are added in SQL Server 2016 and Azure SQL Database enable application developers to easily expose relational data from database tables and create REST API that will provide data to modern JavaScript single-page applications. In this post ... continue reading

Simplify data access using de-normalized models

Classic relational databases enable you to create highly normalized data models with schema that might contain a lot of tables. Logical entities are broken into several tables and every complex property of the primary entity (for example, list, array, collection) ... continue reading

Working with Azure IoT data in Azure SQL Database

IoT use cases commonly share some patterns in how they ingest, process, and store data. First, these systems need to ingest bursts of data from device sensors of various locales. Next, these systems process and analyze streaming data to derive ... continue reading

The January release of SQL Operations Studio is now available

This blog post was authored by Alan Yu, Program Manager, Microsoft SQL Server. We are excited to announce the January release of SQL Operations Studio is now available. Download SQL Operations Studio and review the release notes to get started ... continue reading

Compatibility Level 140 is now the default for Azure SQL Database

Database compatibility level 140 is now the default for new databases created in Azure SQL Database across almost all public regions. As of this writing, there are already 539,903 databases in Azure SQL Database running in compatibility level 140. Questions ... continue reading
Loading...