Azure SQL Devs’ Corner

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

Connecting the Dots of Azure SQL CICD Part 3: Testing with tSQLt

December 5, 2022 Dec 5, 2022 12/5/22

Brian Spendolini

(image) In part 3 of our Azure SQL database change management (CICD) series we cover testing your code using tSQLt and GitHub Actions. Prerequisites Check Refer to part 1 and part 2 for the prerequisites. Fork the GitHub Project We will be using tSQLt in this post, so I have created a GitHub project made up of ...

Connecting the Dots of Azure SQL CICD Part 2: Local Development

November 7, 2022 Nov 7, 2022 11/7/22

Brian Spendolini

Join us for part two of our Azure SQL database change management (CICD) series. This post covers local development environments with Visual Studio Code. Prerequisites Check For Database Projects to deploy correctly, we need to have the .NET Core SDK installed. You can get it here with a direct link for windows x64 here. You can also ...

Welcome to the new Azure SQL Database local development experience!

May 24, 2022 May 24, 2022 05/24/22

Silvano Coriani

The “inner loop” in software development workflows is the process of writing, building, debugging and testing code, usually on a local workstation or development environment, before sharing it with someone else. In contrast, the “outer loop” kicks off as soon as that code is checked in a source control system from where CI/CD pipelines...

Announcing the “Azure SQL Database External REST Endpoints Integration” Early Adoption Program

May 24, 2022 May 24, 2022 05/24/22

Davide Mauri

A new, exciting capability for Azure SQL Database has been announced today at //Build: Azure SQL Database has a new built-in feature that allows native integration with external REST endpoints. This means that integration of Azure SQL Database with Azure Functions, Azure Logic Apps, Cognitive Services, Event Hubs, Event Grid, Azure ...

LAUNCH: Build serverless, full stack applications in Azure

May 25, 2021 May 25, 2021 05/25/21

Anna Hoffman

Whether you’re new or seasoned to cloud, development, and SQL, building and architecting applications in the cloud has become a required skill for many roles. Today, we’re excited to announce a new learning path to help developers of all skill levels learn how to create applications quickly and effectively with Azure.

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.

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.

Resources to become a Well-Rounded Full-Stack Developer

October 8, 2020 Oct 8, 2020 10/8/20

Davide Mauri

(image) 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 ...

Promises, Node, Tedious, Azure SQL. Oh My!

October 4, 2020 Oct 4, 2020 10/4/20

Davide Mauri

(image) 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...

Practical Azure SQL Database for Modern Developers

September 2, 2020 Sep 2, 2020 09/2/20

Davide Mauri

Practical Azure SQL Database for Modern Developers: a book to learn how to take advantage of the all the breakthrough technologies available in Azure SQL like columnstore, in-memory lock-free tables, row-level-security, graph and geospatial support to create modern, scalable and secure applications.

Azure SQL Devs’ Corner

Developers - Azure SQL Devs’ Corner