Developers Azure SQL Devs’ Corner

LAUNCH: Build serverless, full stack applications in Azure

Anna Hoffman May 25, 2021 May 25, 2021 05/25/21

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

Arvind Shyamsundar December 11, 2020 Dec 11, 2020 12/11/20

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

Arvind Shyamsundar October 28, 2020 Oct 28, 2020 10/28/20

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

Davide Mauri October 8, 2020 Oct 8, 2020 10/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 ...

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

Davide Mauri October 4, 2020 Oct 4, 2020 10/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 ...

Practical Azure SQL Database for Modern Developers

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

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.

Querying and visualizing data using SQLPad

Davide Mauri June 30, 2020 Jun 30, 2020 06/30/20

SQLPad is an amazing free, open source, tool to run SQL Queries against a broad spectrum of popular databases, without the need to install and run something on-premises. It's lightweight, simple and just perfect if you need a no-frills tool to query and visualize data, to do some data exploration.

Microsoft.Data.SqlClient 2.0.0 is now available

Davide Mauri June 19, 2020 Jun 19, 2020 06/19/20

Microsoft.Data.SqlClient version 2.0.0 has been released, with several interesting features. Make sure you check it out if you are a .NET developer and you are using Azure SQL or SQL Server in your solutions. Microsoft.Data.SqlClient is the new, open source, official data access library that replaces System.Data.SqlClient

Go Azure SQL!

Silvano Coriani June 16, 2020 Jun 16, 2020 06/16/20

Go is a very popular programming language for developing microservices, Web APIs and other server-side applications, and Azure SQL can definitely be an option where to persist data for these applications in a scalable, reliable and modern way leveraging Microsoft SQL Server Driver for Go and ORM packages like Gorm. Give it a try!

JSON in your Azure SQL Database? Let’s benchmark some options!

Silvano Coriani June 10, 2020 Jun 10, 2020 06/10/20

Introduction Storing and retrieving data from JSON fragments is a common need in many application scenarios, like IoT solutions or microservice-based architectures. You can persist these fragments can be in a variety of data stores, from blob or file shares, to relational and non-relational databases, and there’s a long standing debate in...

Azure SQL Devs’ Corner