Developers Azure SQL Devs’ Corner

Resources to become a Well-Rounded Full-Stack Developer

Davide 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 ...

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

Davide 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 ...

Practical Azure SQL Database for Modern Developers

Davide MauriSeptember 2, 2020Sep 2, 202009/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 MauriJune 30, 2020Jun 30, 202006/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 MauriJune 19, 2020Jun 19, 202006/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 CorianiJune 16, 2020Jun 16, 202006/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 CorianiJune 10, 2020Jun 10, 202006/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...

Improve JDBC application reliability with Azure SQL and connection pooling

Silvano CorianiJune 4, 2020Jun 4, 202006/4/20

A growing number of Azure SQL Database customers are developing new applications in Java using a JDBC driver from Microsoft or a 3rd party. These drivers are providing quite extensive support and covering most of database service capabilities and performance expectations but there are a couple of areas that deserve some attention.

Optimize Azure SQL Upsert scenarios

Silvano CorianiMay 28, 2020May 28, 202005/28/20

Customers often need to move a dataset from a source system into a new destination, inserting rows that doesn't exist in a target table and update those that already exists. With this technique, we've been able to reduce the time needed to upsert a dataset of 2M rows against a target table with 30M rows from 20 hours to 20 minutes.

DevOps for Azure SQL

Arvind ShyamsundarMay 20, 2020May 20, 202005/20/20

DevOps is a broad term with multiple technology and process options at hand. Read this post for an overview of what DevOps for Azure SQL means, and review some options for tools and processes to use.

Azure SQL Devs’ Corner