Azure SQL Devs’ Corner

TodoMVC Full Stack with Azure Static Web Apps, Node and Azure SQL

Davide MauriSeptember 21, 2020Sep 21, 202009/21/20

TodoMVC is a very well known (like ~27K GitHub stars known) application among developers as it is a really great way to start to learn a new Model-View-Something framework. It has plenty of samples done with different frameworks, all implementing exactly the same solution. This way is very easy to compare them against each other and see ...

Fast loading data into Azure SQL: a lesson learned.

Davide MauriSeptember 14, 2020Sep 14, 202009/14/20

I'm preparing a series of post and samples on how to properly load data into Azure SQL using Azure Databricks / Apache Spark that I will start to publish very soon, but I realized today that there is a pre-requisite that in many cases, especially by developers new to the data space, is overlooked: good table design. Wait! If you're not a...

Serverless REST API with Azure Functions, Node, JSON and Azure SQL

Davide MauriSeptember 8, 2020Sep 8, 202009/8/20

Javascript / Typescript (and thus Node) are, among Full-Stack and Back-End developers, one of the most common choices to create scalable, elegant, high-performance, REST API to be used by the most diverse clients. Azure Functions are another pretty popular solution that developers use to create scalable solution without having to deal with all...

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.

Azure SQL & .bacpac the easy way

Davide MauriAugust 31, 2020Aug 31, 202008/31/20

Restoring an Azure SQL database in one - well three - simple scripts: one with Powershell, one with AZ CLI + Bash and one using the ubiquitous SqlPackage

Developing in the cloud with SQL Server Big Data Clusters: Run and Monitor Apps

Melony QinAugust 21, 2020Aug 21, 202008/21/20

As the last part of the series of working with big data analytics solutions in Kubernetes, we learned about how to work with cloud-native applications with BDC. Operating and testing are also essential parts as an enterprise-grade solution. This article will walk you through how to run and monitoring apps to SQL Server Big Data Clusters (...

Developing in the cloud with SQL Server Big Data Clusters: Develop and Deploy Apps

Melony QinAugust 14, 2020Aug 14, 202008/14/20

Kubernetes is designed to support an open platform to support a diverse variety of containerized workloads including both stateless and stateful and data-processing workloads. Technically any application can be containerized, it can be up and running in Kubernetes. As a cloud-native platform, Kubernetes is available to deploy cloud-native ...

Azure SQL for Beginners – Video Playlist

Davide MauriAugust 13, 2020Aug 13, 202008/13/20

Easily translate your SQL Server skills and experience to Azure SQL - using familiar tools and techniques. Insiders Bob Ward and Anna Hoffman walk you through configuring, monitoring, and troubleshooting database security, performance, and availability in this Azure SQL video series on more than 60 topics.

Developing in the cloud with SQL Server Big Data Clusters: Getting Started

Melony QinAugust 6, 2020Aug 6, 202008/6/20

When it comes to innovation, we realized that the world’s most valuable resource is no longer oil, but data. One of the biggest challenges we’re having today is how to integrate disparate data sources from many different places. If you're looking into how to work on Big Data Analytics solutions in Kubernetes, that's where Big Data Clusters...

Architecting REST API with Python, Flask and Azure SQL

Davide MauriJuly 22, 2020Jul 22, 202007/22/20

Creating REST API with Azure SQL is never been easier thanks to its native JSON support. Let's see how we can use Python and Flask to create an elegant and modern solution to serve REST API to the world