Azure SQL

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

Azure SQL Security: Network Security

In this episode in the Azure SQL Security Series, Rohit Nayak reviews Network Security and Connectivity to Azure SQL Database. We start with the basics of public connectivity & associated network access controls and then move on to the various private connectivity options. This episode is a comprehensive resource for beginners to understand how connectivity […]

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

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