This site uses cookies for analytics, personalized content. By continuing to browse this site, you agree to this use. Learn More

Skip to main content
Microsoft
Azure SQL
Azure SQL
  • Home
  • DevBlogs
    • App Center
    • Azure DevOps
    • Notification Hubs
    • Visual Studio
    • Visual Studio Code
    • Visual Studio for Mac
    • Azure Artifacts
    • Azure Boards
    • Azure Pipelines
    • Azure Repos
    • Azure Test Plans
    • DevOps
    • C++
    • Java
    • Java Blog in Chinese
    • JavaScript
    • PowerShell
    • Python
    • Q#
    • Scripting
    • TypeScript
    • Visual Basic
    • Visual C#
    • Visual F#
    • .NET
    • ASP.NET
    • NuGet
    • Xamarin
    • Apps for Windows
    • Azure Government
    • Azure SDKs
    • Bing Dev Center
    • Command Line
    • Developer Support
    • DirectX Developer Blog
    • IoT Developer
    • Math In Office
    • Microsoft Edge Dev
    • Microsoft Azure
    • Office 365 Development
    • Old New Thing
    • PAX Graph
    • PAX Media
    • PAX Windows
    • Perf and Diagnostics
    • PIX on Windows
    • Startup Developers
    • Surface Duo
    • Sustainable Software
    • Windows Search Platform
    • Azure Cosmos DB
    • Azure Data Studio
    • Azure SQL
    • Azure Synapse Analytics
    • OData
    • Revolutions R
    • SQL Server Data Tools

    Azure SQL Devs’ Corner

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

    October 2020 | Azure SQL Devs’ Corner

    Continuous Delivery for Azure SQL DB using Azure DevOps Multi-stage Pipelines
    Continuous Delivery for Azure SQL DB using Azure DevOps Multi-stage Pipelines
    Arvind ShyamsundarArvind ShyamsundarOctober 28, 2020Oct 28, 202010/28/20
    Multi-stage pipelines in Azure DevOps offer a rich, declarative, YAML-based mechanism to implement and customize Continuous Delivery for Azure SQL.

    2Azure SQLDevOps
    Testing performance of Azure SQL Database as a key-value store
    Testing performance of Azure SQL Database as a key-value store
    Dimitri FurmanDimitri FurmanOctober 20, 2020Oct 20, 202010/20/20
    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
    AvatarDavide MauriOctober 19, 2020Oct 19, 202010/19/20
    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 SQLIoT
    Optimize storage usage for large volumes of IoT data with Azure SQL
    Optimize storage usage for large volumes of IoT data with Azure SQL
    AvatarSilvano CorianiOctober 12, 2020Oct 12, 202010/12/20
    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
    AvatarSilvano CorianiOctober 12, 2020Oct 12, 202010/12/20
    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
    Build your full-PaaS IoT solution with Azure SQL Database
    Build your full-PaaS IoT solution with Azure SQL Database
    AvatarSilvano CorianiOctober 12, 2020Oct 12, 202010/12/20
    IoT with Azure SQL IoT solutions usually include several components that spans from device communication and management to event processing and data ingestion and analysis. Deploying all these components independently on compute, network and storage based infrastructures can be a complex and time consuming task, but nothing compared to manage...

    Comments are closed.0Azure SQLIoT
    Running 1M databases on Azure SQL for a large SaaS provider: Microsoft Dynamics 365 and Power Platform.
    Running 1M databases on Azure SQL for a large SaaS provider: Microsoft Dynamics 365 and Power Platform.
    AvatarSilvano CorianiOctober 8, 2020Oct 8, 202010/8/20
      Thriving on Azure SQL   Many thanks to our colleagues Mahesh Sreenivas, Pranab Mazumdar, Karthick Pakirisamy Krishnamurthy, Mayank Mehta and Shovan Kar from Microsoft Dynamics team for their contribution to this article.   Overview Dynamics 365 is a set of intelligent SaaS business applications that helps companies...

    Comments are closed.0Azure SQL
    Resources to become a Well-Rounded Full-Stack Developer
    Resources to become a Well-Rounded Full-Stack Developer
    AvatarDavide MauriOctober 8, 2020Oct 8, 202010/8/20
      If you want to start coding and create your own solutions - be it an App, a Website or something else - or if you want to start a career as developer, you're in luck! There has never been so many and so good training material around, and - even better - available for free. Last addition to the amazing long list of videos and ...

    5Azure SQLJavascript
    Promises, Node, Tedious, Azure SQL. Oh My!
    Promises, Node, Tedious, Azure SQL. Oh My!
    AvatarDavide MauriOctober 4, 2020Oct 4, 202010/4/20
    If you are new to Node.js like I am, using Tedious to access Azure SQL can be challenging at the beginning. My understanding is that Tedious, while being fully asynchronous, doesn't support nor Promises nor the more modern async/await pattern. Tedious, in fact, uses events to execute asynchronous code and so a bit of work is needed ...

    2Azure SQLJavascript
    Topics
  • Azure SQL
  • DevOps
  • Javascript
  • Python
  • Node
  • .NET
  • IoT
  • Big Data Clusters
  • Big Data
  • Java
  • Apache Spark
  • Azure Databricks
  • Streaming
  • Containers
  • Top Bloggers
    Avatar

    Davide Mauri
    Senior Program Manager

    Avatar

    Silvano Coriani
    Principal Program Manager

    Arvind Shyamsundar

    Arvind Shyamsundar
    Principal Program Manager

    Melony Qin

    Melony Qin
    Program Manager

    Avatar

    Jovan Popovic
    Senior Program Manager

    Archive
  • 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 Duo
    • Surface Laptop Go
    • Surface Pro X
    • Surface Go 2
    • Surface Book 3
    • Microsoft 365
    • Windows 10 apps
    • HoloLens 2
    Microsoft Store
    • Account profile
    • Download Center
    • Microsoft Store support
    • Returns
    • Order tracking
    • Virtual workshops and training
    • Microsoft Store Promise
    • Financing
    Education
    • Microsoft in education
    • Office for students
    • Office 365 for schools
    • Deals for students & parents
    • Microsoft Azure in education
    Enterprise
    • Azure
    • AppSource
    • Automotive
    • Government
    • Healthcare
    • Manufacturing
    • Financial services
    • Retail
    Developer
    • Microsoft Visual Studio
    • Windows Dev Center
    • Developer Center
    • Microsoft developer program
    • Channel 9
    • Microsoft 365 Dev Center
    • Microsoft 365 Developer Program
    • Microsoft Garage
    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 2021