YouTube video by Microsoft Developer

YouTube video by Microsoft Developer

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

The Microsoft SQL Drivers team has been busy with 7 releases across 6 drivers in less than a month. David Levy stops by to tell us about all of the great stuff they've delivered. Stick around to the end for a demo of new Bulk Copy and Arrow functionality in the mssql-python driver. ✅ Chapters: 0:00 Introduction 2:08 mssql-python: Bulk Copy & Apache Arrow 3:44 SqlClient 7.0 & JDBC 13.4 5:25 Django, PHP, ODBC - Caught Up & Shipping 7:50 Demo ✅Resources: Quickstarts for the python driver: https://aka.ms/mssql-python-qs 📌 Let's connect: Twitter - Anna Hoffman, https://twitter.com/AnalyticAnna Twitter - AzureSQL, https://aka.ms/azuresqltw 🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQL #LearnSQL

Let's dive into the major updates and innovations that came to Microsoft Fabric Data Warehousing in 2025, including features like Data Clustering, IDENTITY columns, MERGE, Migration Assistant, Security Features, and more! ✅ Chapters: 0:00 Introduction 2:38 Fabric Data Warehouse in 2025 3:49 Data Clustering 4:50 IDENTITY columns 5:54 MERGE 6:54 Migration Assistant 8:05 Security Features 9:45 What's next ✅ Resources: Fabric Roadmap, Administration, Governance and Security: http://aka.ms/fabricroadmap 📌 Let's connect: Twitter - Anna Hoffman, https://twitter.com/AnalyticAnna Twitter - AzureSQL, https://aka.ms/azuresqltw 🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQL #LearnSQL

It has finally arrived - native Regex directly in SQL Server! Now text can be searched using any Regex patterns using a variety of powerful, new functions. Enjoy demonstrations of some of the new features and why they will be a huge help for anyone that writes T-SQL! 0:00 Introduction 2:40 Demo 9:00 Demo 9:55 Getting started ✅ Resources: Regular Expressions Overview (Microsoft Learn): https://learn.microsoft.com/en-us/sql/relational-databases/regular-expressions/overview Regex re2 syntax (Github): https://github.com/google/re2/wiki/Syntax Re2 Regex library (GitHub): https://github.com/google/re2/ About MVPs: Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: https://aka.ms/mvpprogram 📌 Let's connect: Twitter: Anna Hoffman, https://twitter.com/AnalyticAnna Twitter: AzureSQL, https://aka.ms/azuresqltw 🔴 To watch other MVP Edition episodes, see our playlist: https://aka.ms/dataexposedmvps To check out even more Data Exposed episodes, see our playlist: https://aka.ms/dataexposedyt 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQLServer

Going a level deeper than a basic semantic search talk, we’ll explore semantic search, how to implement it in your app, and how to ingest data at scale to support your application’s AI needs. ✅ Chapters: 0:00 Introduction 3:50 Demo ✅ Resources: https://learn.microsoft.com/en-us/sql/t-sql/functions/vector-search-transact-sql?view=sql-server-ver17 https://learn.microsoft.com/en-us/sql/sql-server/ai/vectors?view=sql-server-ver17 https://github.com/Azure-Samples/azure-sql-db-vector-search About Joseph D'Antoni: Joseph D'Antoni is an Principal Consultant at Denny Cherry and Associates Consulting. He is recognized as a VMWare vExpert and a Microsoft Data Platform MVP, and has over 20 years of experience working in both Fortune 500 and smaller firms. He has worked extensively on database platforms and cloud technologies and has specific expertise in performance tuning, infrastructure, and disaster recovery. About MVPs: Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: https://aka.ms/mvpprogram 📌 Let's connect: Twitter: Anna Hoffman, https://twitter.com/AnalyticAnna Twitter: AzureSQL, https://aka.ms/azuresqltw 🔴 To watch other MVP Edition episodes, see our playlist: https://aka.ms/dataexposedmvps To check out even more Data Exposed episodes, see our playlist: https://aka.ms/dataexposedyt 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQLServer

Agentic solutions working with production data can breathe a little easier with SQL MCP Server. The latest release introduces OBO authentication, tailored MCP tools, and continued investment in security guardrails to help ensure agents do not wander into dangerous areas. With this release, SQL MCP Server gives developers and architects real tools to optimize their AI applications, while administrators gain the control they need to allow agents to interoperate securely with production data. ✅ Chapters: 0:35 Data API Builder (DAB) reference to episode here: https://youtu.be/8b_4ftQP1IY?si=dwdtyxOxYedXaB2G 1:22 What is SQL MCP Server 1:50 Why did we create it 3:08 Benefits of being integrated with DAB 5:15 Demo 7:44 Controlling Graph, REST, MCP - Demo 8:45 Configure MCP - Demo 9:01 Try SQL MCP Server and review tools - Demo 11:20 Wrap up ✔️Resources: https://aka.ms/sql/mcp 📌 Let's connect: Twitter - Jerry Nixon, https://twitter.com/jerrynixon Twitter - Anna Hoffman, https://twitter.com/AnalyticAnna Twitter - AzureSQL, https://aka.ms/azuresqltw 🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQL #LearnSQL

 The 2024 FinWise data breach underscores the rising risk of insider threats within financial institutions. Unlike cyberattacks initiated by external hackers, this breach resulted from unauthorized access by a former employee who retained system credentials after leaving the company. On May 31, 2024, the ex-employee accessed FinWise Bank’s internal systems and leaked personal information of approximately 689,000 customers of American First Finance (AFF). The breach went unnoticed for more than a year, until FinWise discovered it on June 18, 2025. This prolonged exposure period raises serious concerns about the bank’s internal monitoring and incident detection capabilities.  Legal complaints against FinWise allege that the compromised data was inadequately encrypted, intensifying public scrutiny and regulatory pressure. Security experts emphasize that effective information protection involves more than encrypting financial data; it requires continuous monitoring, abnormal access detection, and secure key management. FinWise’s alleged failure to deploy these essential safeguards has led to lawsuits and reputational damage. While the bank has yet to disclose details about its encryption protocols, experts agree that encryption alone cannot protect data without proper implementation and access controls.  The incident highlights how encryption serves as a final layer of defense, but its effectiveness depends on complementary systems like key management and access control. Proper encryption management could have minimized the risk of data exposure, even after unauthorized access. In this context, Penta Security’s D.AMO encryption platform has gained renewed attention as an all-in-one defense solution against such vulnerabilities.  D.AMO, South Korea’s first packaged encryption solution launched in 2004, integrates encryption, granular access control, and an independent key management system (KMS). Trusted by over 10,000 clients across the finance, public, and enterprise sectors, D.AMO ensures data confidentiality while maintaining operational efficiency. It supports multiple encryption methods and selective column-level encryption, reducing system slowdown without compromising data protection.  The platform’s key management system, D.AMO KMS, operates as a dedicated hardware appliance that keeps encryption keys separate from the data they protect. By dividing the roles of database and security administrators, D.AMO prevents unauthorized individuals—including insiders—from accessing both encrypted data and the keys simultaneously. Even if an attacker breaches the database, the absence of decryption keys renders the stolen data unusable.  Additionally, D.AMO Control Center provides centralized management across an organization’s encryption systems. It allows administrators to monitor logs, enforce role-based access controls, and manage permissions to reduce insider misuse. This centralized visibility helps institutions detect unusual behavior early and maintain compliance with international data security regulations such as PCI-DSS, GDPR, and CCPA.  The FinWise breach serves as a cautionary tale about the consequences of weak encryption governance and insufficient access monitoring. It demonstrates that robust data protection requires a proactive, multi-layered approach integrating encryption, key management, and centralized oversight. Penta Security’s D.AMO platform embodies this strategy, offering institutions a unified solution to mitigate both external and insider threats. For organizations managing sensitive customer information, implementing comprehensive encryption frameworks is no longer optional—it is essential for preserving trust, compliance, and long-term security resilience.

Learn about the Azure SQL Database free offer.

Learn how seamless it is to connect to connect to SQL Ma...

YouTube video by Microsoft Developer