Azure SQL

Azure SQL

Azure SQL April 2022 New Updates

Get the latest April news and updates in the world of data with Anna Hoffman, Cheryl Adams, Claire Giordano, Marisa Brasile, and Abhiman Tiwari.

Read More
Azure SQL SQL Server

Azure SQL News Update | Data Exposed Live @SQLBits 2022

In this session, join the live audience of a session that is being live-streamed from SQLBits 2022. Receive the latest updates containing all things SQL Server and Azure SQL.

Read More
Azure SQL SQL Server

Azure SQL & SQL Server 2022: Intelligent Database Futures

Azure SQL DB and SQL Server introduced ground-breaking query performance enhancements under the Intelligent Query Processing family in the past few years. These make up the latest on Microsoft’s mission to make critical parallel workloads improve when running at scale while remaining adaptive to the constantly changing world of data! Learn more in this episode […]

Read More
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