SQL Server

Azure SQL SQL Server

What’s new in SSMS 19.2 | Data Exposed

Learn more about the improvements in the latest version of SQL Server Management Studio (SSMS) in this video from Microsoft Developer.

Read More
Azure Azure SQL SQL Server

Automated backups, PITR, and Availability Groups with Arc-enabled SQL Server | Data Exposed

This demo features two of the capabilities unlocked with Arc enabling your SQL Server(s). The first one covers the built-in Automated backups and Point-in-time restore capability which allows you to configure a custom backup schedule and perform a point in time restore of your user databases. The second feature is in the High Availability space […]

Read More
Data SQL Server

How to Track middle tier applications with SQL Audit

The on-behalf-of authentication flow (or OBO) enables an application or web API to use an identity other than its own to call another web API or service. Azure SQL Database supports OBO with Microsoft Entra authentication, allowing middle-tier applications to connect and perform actions using the credentials of the signed in user. The SQL auditing […]

Read More
Azure Azure SQL SQL Server

Optimizing Your SQL Database Workloads w/ Automatic Tuning on Azure SQL | Data Exposed: MVP Edition

In this episode of Data Exposed: MVP Edition with Anna Hoffman and Hugo Barona, explore the features and benefits of using Automatic tuning on Azure SQL to optimize your SQL database workloads. Azure SQL’s automatic tuning capabilities can help you identify and resolve performance issues in real-time while reducing the time and resources required for […]

Read More
Azure SQL Data SQL Server

How to set up centralized, scalable, and secure access for SQL operations personnel | Data Exposed

Microsoft Purview DevOps policies help you provision access to database system metadata at-scale, securely and inexpensively. Who needs that access? Your internal IT/DevOps personnel or your external contractors that are tasked with monitoring health, tuning performance, and reviewing audit information in SQL systems. With DevOps policies, you can manage access to SQL Dynamic Management Views […]

Read More
AI Azure SQL SQL Server

Unlock the Power of AI and REST with Azure SQL Database | Data Exposed

The ability to simply call REST endpoints with a single line of code opens up the world of Azure Services to an Azure SQL Database. A single stored procedure call can access event hubs, blob storage, functions, and even AI. In this episode, Anna Hoffman and Brian Spendolini discuss how the newly generally available feature, […]

Read More
DevOps SQL Server

How to Power Up your DevOps Development with SQL Server Containers

Build consistent data applications across any operating system using SQL Server containers. Containers provide a portable, lightweight, and consistent method to create databases with the power of the SQL Server engine. SQL Server containers also provide a local cloud development experience using efficient DevOps processes and tools.

Read More
SQL Server

Office Hours: Technical Disaster Edition

This video is from Brent Ozar Unlimited. While I was going through your top-voted questions from https://pollgab.com/room/brento, my camera stopped working, hahaha. Had to switch to another camera live. Here’s what we covered:

Read More
SQL Server

What’s new in SQL Server Data Tools (SSDT)?

The latest version of SQL Server Data Tools (SSDT) [Version 17.6 GA] was released in May 2023. In this episode of Data Exposed with Anna Hoffman and Subhojit Basak, they’ll highlight the latest features that are being added to SSDT and give a sneak peek on the features coming next.

Read More
Data SQL Server

Database Q&A Office Hours At Sea!

Not only does Brent Ozar have a cool car, he’s answering your database questions from a boat!

Read More