Data Exposed

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

Azure SQL November 2021 New Updates

Get the latest November news and updates in the world of data with Anna Hoffman, Ben Hayes (Directus), Chris Rininger, Marisa Brasile, and Rijk van Zanten (Directus) on Data Exposed Live.

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