Anna Hoffman

Azure Data

Notebook Views in Azure Data Studio

In this episode of Data Exposed with Julie Koesmarno, get a sneak peek of what’s new in Azure Data Studio.

Read More
Azure Data

Azure SQL September 2021 New Updates | Data Exposed Live

Here are the latest September news and updates in the world of data with Anna Hoffman, Henk van der Valk (FullData BV), Marisa Brasile, Mohamed Kabiruddin, and Niko Neugebaur on Data Exposed Live. Time stamps: 0:00 Show begins 1:25 Product Update – New Azure SQL Migration Extension in Azure Data Studio 11:11 Azure blog 18:50 […]

Read More
Linux SQL Server

SQL Server on Linux Storage Secrets

SQL Server object disks on Windows Server can be expanded at any time with no issues, but Linux doesn’t quite work like that by default. In a situation where you run out of space, you’re out of luck, unless you know some secrets about Linux. The mysterious Linux Logical Volume Manager must be used before […]

Read More
Azure SQL

Track and Record Data Changes with Change Data Capture (CDC) in Azure SQL

Change data capture (CDC) records insert, update, and delete activity that applies to tables in SQL Server, Azure SQL Managed Instance or Azure SQL Databases. In this Data Exposed episode with Mara-Florina Steiu, we will cover common use cases and scenarios for CDC, discuss key technical implementation details, and try out a CDC demo.      Resources: […]

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 Blockchain

Azure SQL Database Ledger​ the Power of Blockchain with the Simplicity of SQL

In this episode of Data Exposed with Jason Anderson, learn what the ledger feature of Azure SQL Database is and where using ledger can help enable digital trust in your data. There will also be some quick demos on how to enable this exciting new capability and how to show to others that your data […]

Read More
Azure Azure SQL

How to Set up Azure Monitor for SQL Insights

SQL insights is a comprehensive solution for monitoring any product in the Azure SQL family. Learn about how to set up Azure Monitor for SQL insights with Alain Dormehl, Senior Program Manager at Microsoft. Resources: Monitor your SQL deployments with SQL insights (preview) Deep Dive on Azure SQL Insights

Read More
Data SQL Server

Understanding the Benefits of Intelligent Query Processing

In this episode of Data Exposed, Kate Smith will take you through the basics of why query processing matters, what it does, and how Intelligent Query Processing makes your workloads faster and more efficient. Resources: The Positive Impact of Intelligent Query Processing – Microsoft Tech Community Intelligent query processing in SQL databases

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