Skip to main content
Microsoft
Azure SQL Database
Azure SQL Database
  • Home
  • DevBlogs
    • Visual Studio
    • Visual Studio Code
    • Visual Studio for Mac
    • DevOps
    • Developer support
    • CSE Developer
    • Engineering@Microsoft
    • Azure SDK
    • IoT
    • Command Line
    • Perf and Diagnostics
    • Dr. International
    • Notification Hubs
    • Math in Office
    • DirectX
    • PIX
    • SurfaceDuo
    • Startups
    • Sustainable Engineering
    • Windows AI Platform
    • C++
    • C#
    • F#
    • Visual Basic
    • TypeScript
    • PowerShell Community
    • PowerShell Team
    • Python
    • Q#
    • JavaScript
    • Java
    • Java Blog in Chinese
    • .NET
    • .NET MAUI
    • Blazor
    • ASP.NET
    • NuGet
    • Xamarin
    • #ifdef Windows
    • Apps for Windows
    • Azure Depth Platform
    • Azure Government
    • Bing Dev Center
    • Microsoft Edge Dev
    • Microsoft Azure
    • Microsoft 365 Developer
    • Old New Thing
    • Windows MIDI and Music dev
    • Windows Search Platform
    • Azure Cosmos DB
    • Azure Data Studio
    • Azure SQL Database
    • OData
    • Revolutions R
    • SQL Server Data Tools

    Azure SQL Database Devs’ Corner

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

    Azure SQL - Azure SQL Database Devs’ Corner

    Programmatically parsing Transact SQL (T-SQL) with the ScriptDom parser
    Programmatically parsing Transact SQL (T-SQL) with the ScriptDom parser
    December 11, 2020 Dec 11, 2020 12/11/20
    Arvind Shyamsundar
    Azure SQL developers have access to a full-fidelity, highly accurate, and easy-to-use client-side parser for T-SQL statements: the TransactSql.ScriptDom parser. This blog post walks through basic usage, and links to a number of resources for digging deeper.

    1Azure SQL.NETDevOps
    Azure SQL can read Azure Data Lake storage files using Synapse SQL external tables
    Azure SQL can read Azure Data Lake storage files using Synapse SQL external tables
    December 10, 2020 Dec 10, 2020 12/10/20
    Jovan Popovic
    Serverless Synapse SQL pool in Azure Synapse Analytics is a T-SQL query engine that enables you to read the files placed on Azure storage. You can easily integrate your Azure SQL engine with Synapse SQL to delegate big data analytics and analyze large amounts of data placed on Azure.

    2Azure SQLBig Data
    Using an Azure Container Instance to convert a BAK to BACPAC for Import into Azure SQL Database
    Using an Azure Container Instance to convert a BAK to BACPAC for Import into Azure SQL Database
    December 9, 2020 Dec 9, 2020 12/9/20
    Davide Mauri
    Importing a SQL Server backup into an Azure SQL Database is not a trivial task. Here's how to automate the process of converting a .bak to .bacpac file using Docker Containers, Powershell and some automation.

    Comments are closed.0Azure SQLContainersDevOps
    Autoscaling with Azure SQL Hyperscale
    Autoscaling with Azure SQL Hyperscale
    December 3, 2020 Dec 3, 2020 12/3/20
    Davide Mauri
    Azure SQL Hyperscale is the latest architectural evolution of Azure SQL, which has been natively designed to take advantage of the cloud. One of the main key features of this new architecture is the complete separation of Compute Nodes and Storage Nodes. This allows for the independent scale of each service, making Hyperscale more flexible and...

    Comments are closed.0Azure SQL.NET
    Seasons of Serverless Challenge 1: Azure Functions and Azure SQL Database serverless
    Seasons of Serverless Challenge 1: Azure Functions and Azure SQL Database serverless
    November 30, 2020 Nov 30, 2020 11/30/20
    Drew Skwiers-Koballa
    Throughout the next seven weeks we'll be sharing a solution to the week's Seasons of Serverless challenge that integrates Azure SQL Database serverless with Azure serverless compute. Learn how to develop an Azure Function that leverages Azure SQL database serverless with Challenge 1 of the Seasons of Serverless challenge.

    Comments are closed.0Azure SQLPython
    Continuous Delivery for Azure SQL DB using Azure DevOps Multi-stage Pipelines
    Continuous Delivery for Azure SQL DB using Azure DevOps Multi-stage Pipelines
    October 28, 2020 Oct 28, 2020 10/28/20
    Arvind Shyamsundar
    Multi-stage pipelines in Azure DevOps offer a rich, declarative, YAML-based mechanism to implement and customize Continuous Delivery for Azure SQL.

    2DevOpsAzure SQL
    Testing performance of Azure SQL Database as a key-value store
    Testing performance of Azure SQL Database as a key-value store
    October 20, 2020 Oct 20, 2020 10/20/20
    Dimitri Furman
    Executive summary Our testing shows that Azure SQL Database can be used as a highly scalable low latency key-value store. Starting with a cost-efficient 4-core General Purpose database, we see an order of magnitude increase in workload throughput as we increase dataset size by 100x and scale across the spectrum of database SKUs to a Business ...

    4Azure SQL
    Serverless Streaming At Scale with Azure SQL
    Serverless Streaming At Scale with Azure SQL
    October 19, 2020 Oct 19, 2020 10/19/20
    Davide Mauri
    Just before Ignite, a very interesting case study done with RXR has been released, where they showcased their IoT solution to bring safety in buildings during COVID times. It uses Azure SQL to store warm data, allowing it to be served and consumed to all downstream users, from analytical applications to mobile clients, dashboards, API, and...

    Comments are closed.0Azure SQLIoTStreaming
    Optimize storage usage for large volumes of IoT data with Azure SQL
    Optimize storage usage for large volumes of IoT data with Azure SQL
    October 12, 2020 Oct 12, 2020 10/12/20
    Silvano Coriani
    IoT with Azure SQL IoT solutions are generally producing large data volumes, from device to cloud messages in telemetry scenarios to device twins or commands that need to be persisted and retrieved from users and applications. Whether we need to store data in “raw” formats (like JSON messages emitted by different devices), to preserve and...

    Comments are closed.0Azure SQLIoT
    Ingest millions of events per second on Azure SQL leveraging Shock Absorber pattern
    Ingest millions of events per second on Azure SQL leveraging Shock Absorber pattern
    October 12, 2020 Oct 12, 2020 10/12/20
    Silvano Coriani
    IoT with Azure SQL IoT workloads can be characterized by high rates of input data, on both steady and burst streams, to be ingested from devices. A common design pattern for relational database systems involves a “landing zone” (or staging area) which is optimized for “absorbing the shock” of this high and spikey input rate, before ...

    2Azure SQLIoT
    • Previous page
    • Page 1
    • Page 2
    • Page 3
    • Page 4
    • Page 5
    • Page 6
    • Next page
    Topics
  • Azure SQL
  • DevOps
  • Python
  • Node
  • .NET
  • Javascript
  • IoT
  • Big Data Clusters
  • Big Data
  • Java
  • Apache Spark
  • Azure Databricks
  • Streaming
  • Containers
  • Typescript
  • Top Bloggers

    Davide Mauri
    Principal Program Manager

    Silvano Coriani
    Principal Program Manager

    Abhiman Tiwari
    Program Manager

    Anna Hoffman
    Data & Applied Scientist / Program Manager

    Archive
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • October 2021
  • May 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • Stay informed

    Login
    Code Block
    What's new
    • Surface Pro 8
    • Surface Laptop Studio
    • Surface Pro X
    • Surface Go 3
    • Surface Duo 2
    • Surface Pro 7+
    • Windows 11 apps
    • HoloLens 2
    Microsoft Store
    • Account profile
    • Download Center
    • Microsoft Store support
    • Returns
    • Order tracking
    • Virtual workshops and training
    • Microsoft Store Promise
    • Flexible Payments
    Education
    • Microsoft in education
    • Devices for education
    • Microsoft Teams for Education
    • Microsoft 365 Education
    • Education consultation appointment
    • Educator training and development
    • Deals for students and parents
    • Azure for students
    Business
    • Microsoft Cloud
    • Microsoft Security
    • Azure
    • Dynamics 365
    • Microsoft 365
    • Microsoft Advertising
    • Microsoft Industry
    • Microsoft Teams
    Developer & IT
    • Developer Center
    • Documentation
    • Microsoft Learn
    • Microsoft Tech Community
    • Azure Marketplace
    • AppSource
    • Microsoft Power Platform
    • Visual Studio
    Company
    • Careers
    • About Microsoft
    • Company news
    • Privacy at Microsoft
    • Investors
    • Diversity and inclusion
    • Accessibility
    • Security
    English (United States)
    • Sitemap
    • Contact Microsoft
    • Privacy
    • Manage cookies
    • Terms of use
    • Trademarks
    • Safety & eco
    • About our ads
    • © Microsoft 2022