Whether it’s for reporting and offloading queries from production, there are things you need to keep in mind when using a Geo Replicated Azure SQL Database Readable Secondary.

Anna Hoffman speasked with MVP Monica Rathbun the challenges when it comes to performance tuning, what to keep in mind, and what to expect.

Resources:

Azure SQL Database enables serverless and hyperscale scenarios, all backed by the enterprise-grade SQL Server engine. This video shows how to setup the database and update your website, in this case a map with real-time bus data, to use it.

Related resources:

Running complex aggregations and analytical functions on real-time operational databases is a powerful capability in Azure SQL. In the last part of this three-part series with Silvano Coriani, we will see how Window Functions can be a great tool to express analytical calculations on real-time data sets.

More episodes in this Operational Analytics Series:
Resources:

Real-Time Operational Analytics:

Azure SQL provides several connectivity options to cover different application scenarios. It is important to understand that they may have implications related to security and performance. In this episode with Silvano Corini, we will go through some tips & tricks that may help you to find the best for your needs.

Resources: