Azure SQL

Data SQL Server

How to Use Citus to Shard Postgres, for Performance & Scale | Data Exposed

If you’re looking to scale your Postgres database, the Citus open-source extension to Postgres makes sharding simple. And Citus is available on Azure as a managed service, too. Join Claire Giordano on the Citus team to learn about how Citus uses the Postgres extension APIs to shard Postgres—and the best way to get started with […]

Read More
Azure SQL

Managing SQL Server Agent jobs with Notebook Jobs in Azure Data Studio | Data Exposed: MVP Edition

In this episode of Data Exposed: MVP Edition, Taiob Ali will walk you through every step of Notebook Jobs. Time stamps: 0:00 Show begins 0:31 About Taiob Ali 1:34 Benefits of SQL Server Agent Jobs 4:50 Demo 12:30 Getting Started Resources: Github: https://github.com/sqlworldwide/Presentations/tree/master/NotebookJobs?WT.mc_id=dataexposed-c9-niner About Taiob Ali: Taiob Ali, Microsoft Data Platform MVP, is an accomplished […]

Read More
Azure

How to Use Azure Monitor Metrics to Track VM Cache Health

Azure Monitor is a technology used to collect telemetry data from your Azure and on-premises environments. You can use Azure Monitor to improve performance and support the stability of your applications by identifying issues quickly. Azure Monitor includes Azure Metrics and Azure Logs to store telemetry data and track data in real-time and for historical […]

Read More
Azure SQL

Performance Tuning on Azure SQLDB and Readable Secondaries

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: Offload read-only […]

Read More
Azure SQL

Setup Azure SQL Database to use with Azure Static Web Apps

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: Learn Live video covering the learning path: https://youtu.be/XBxBC959tLg Data Exposed show (live and […]

Read More
Azure Azure SQL

Migrating to Azure SQL

In this video with Rajesh Setlem, learn about the new integrated assessment and migration experience for Azure SQL from Azure Data Studio (ADS) as well as how easy it is to get started.

Read More
Azure SQL SQL Server

Storage 101 for Azure SQL and SQL Server Engineers

Learn how storage impacts the performance of your database solution. In this episode with MVP Argenis Fernandez, go over the basics of I/O, what the different access patterns are for the database engine and how to tell when there is an issue with underlying storage for your database. Resources: Argenis’ blog on IO Block Size […]

Read More
Azure SQL

What’s New in Azure SQL Auditing

Azure SQL Auditing recently announced two new destinations now Generally available, and a new capability called Azure SQL Auditing of Microsoft support operations. In this episode, Anna Hoffman and David Trigano will cover all these new capabilities that allow you to capture any operations done against your SQL assets on Azure at scale. Resources: Auditing […]

Read More
Azure SQL Server

How to Create Operational Analytics with Window Functions in Azure SQL – Part 3

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: How […]

Read More
Azure SQL

Azure SQL Connectivity Performance Tips & Tricks

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: Simplify Authentication with […]

Read More