Data Exposed

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
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 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
SQL Server

Granular Permissions for Azure SQL Dynamic Data Masking

In this episode of Data Exposed with David Trigano and David Brookler, learn how you can leverage new capabilities in Dynamic Data Masking, help your organization prevent unauthorized access to sensitive data, and gain control by masking it to a non-privileged user at different levels of your database. 

Read More
Azure Data

Simplify Authentication with Managed Identities for Azure Resources

Managed Identities for Azure Resources can be leveraged to provide applications running on Azure Services with password-free access to Azure SQL databases and simplifying aspects like credential rotation and secrets management. In this episode of Data Exposed with Silvano Coriani, we’ll look at how it works and will see it in action Resources: Tutorial: Use […]

Read More
Azure SQL

Leveling Up Your Azure SQL Database Deployments

The Basic, Standard, and Premium service tiers fulfill a lot of customers’ needs. For some customers, though, the General Purpose, Business Critical, and Hyperscale service tiers offer additional performance and ability that is required for certain workloads. Even if you don’t require those abilities, the technology and infrastructure behind these are worth learning. In this […]

Read More
Azure SQL Server

Understanding Azure Arc Enabled SQL Server

In this episode of Data Exposed with Sasha Nosov, learn how Azure Arc allows you to leverage Azure Services for your existing database applications hosted on-premises or in other public clouds, without changing or even stopping them. Content & Time Stamps: 0:00 Introduction 0:45 What is Azure Arc 2:30 About Azure Arc Enabled SQL Server […]

Read More
Azure SQL Server

Linked Servers in Azure SQL Database Managed Instance

Linked servers enable the SQL Server and Azure SQL Database Managed Instance to read data from remote data sources and execute commands against the remote database servers. In this video, Anna Thomas and Colin Murphy go over configuring linked servers in Azure SQL Database Managed Instance. At the end, Anna briefly mentions creating a linked […]

Read More