Posts by this author

Mar 15, 2022
0
0

Build GraphQL apps with Hasura and Azure SQL Database

Hasura makes data access easy, by instantly composing a GraphQL API that is backed by databases and services so that the developer team (or API consumers) get productive immediately. The nature of GraphQL itself and Hasura’s dynamic approach makes integration and iteration easy.

Azure SQL
Mar 16, 2021
11
2

Introducing Configurable Retry Logic in Microsoft.Data.SqlClient v3.0.0-Preview1

Over the last few years, we provided guidance on how customers could create their own retry logic or reuse existing libraries aimed to simplify this task for them, We decided to provide a better experience incorporating configurable retry logic capabilities in our client drivers portfolio starting with Microsoft.Data.SqlClient v3.0.0-Preview1.

Azure SQL.NET
Oct 12, 2020
0
0

Optimize storage usage for large volumes of IoT data with Azure SQL

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

Azure SQLIoT
Oct 12, 2020
2
0

Ingest millions of events per second on Azure SQL leveraging Shock Absorber pattern

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 data will be fl...

Azure SQLIoT
Oct 12, 2020
0
0

Build your full-PaaS IoT solution with Azure SQL Database

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, mon...

Azure SQLIoT
Jun 16, 2020
0
0

Go Azure SQL!

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!

Azure SQL
Jun 10, 2020
0
0

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

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 the in...

Azure SQL
Jun 4, 2020
2
0

Improve JDBC application reliability with Azure SQL and connection pooling

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.

Azure SQL
May 28, 2020
0
0

Optimize Azure SQL Upsert scenarios

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. 

Azure SQL