#AzureSQL

sqlreitse.com

Azure: Check your data platforms resiliency

Wait, what? Resiliency? Against what? Well. The cloud sounds like an amazing, magical place without limits. The truth is, it isn't. Maybe you've seen the funny T-shirts with the text "the cloud is just someone else's computer". And that's true. Instead of building and maintaining your own data centre, you're hiring a global corporation to do that for you. And with that, you get a whole lot of options.

www.youtube.com

Automagic Data Anomaly Detection in Fabric | Data Exposed MVP Edition

#AzureSQL #SQL #LearnSQL As we’re pushed into an AI-driven automatic world, it’s helpful if our chosen data platform automagically detects errors and takes actions to resolve those errors. How do we set that up? Join Anna Hoffman and Matt Gordon for a few minutes to see how to do just that. ✅ Chapters: 0:20 Intro to Matt Gordon, Microsoft MVP 1:20 Introduction to a large Global Glass sporting event (scenario for the demos) 2:08 Find anomalies in ticket sales or ETL pipelines 2:58 How to set up Change Event Streaming 6:04 Event stream in Fabric 6:30 What is an Eventhouse in Fabric 7:08 Anomaly detection 8:10 Code for detecting anomalies 8:30 Creating alerts with Activator in Fabric 9:00 Custom actions, notebooks, etc 9:30 Automagic line of code 10:22 Tips and tricks for getting started 10:40 Managed identities 10:50 It's just SQL plus customization ✅ Resources: A good general blog can be found at https://community.fabric.microsoft.com/t5/Fabric-Updates-Blog/Stream-SQL-Change-Events-to-Microsoft-Fabric-Eventstream-with/ba-p/5172004. A step-by-step tutorial (mostly) can be found at https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-streams/stream-sql-change-events-to-eventstream. Anomaly detection primer can be found at https://learn.microsoft.com/en-us/fabric/real-time-intelligence/anomaly-detection?tabs=eventhouse. About Matt Gordon: Matt is a Microsoft Data Platform MVP and has worked with Microsoft data technology since 2000 and Azure AI since 2017. He is the leader of the Lexington, KY Data Technology Group and a frequent domestic and international community speaker. He's a Redgate Community Ambassador and an author of two books. His original data professional role was in database development, which quickly evolved into query tuning work as a DBA in the healthcare realm. He has supported several critical systems utilizing SQL Server, Azure SQL, and Microsoft Fabric and managed dozens of 24/7/365 data estates. As a consultant, he works with customers large, medium, and small to migrate to the cloud, make their data estate operate efficiently, and find the right tools and solutions within the Microsoft data & AI ecosystem. 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: LinkedIn, X, Bluesky, Github: @sqlatspeed 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

www.youtube.com

Data Streaming for Modern Applications in SQL Server 2025, Azure SQL, and Fabric SQL | Data Exposed

Change Event Streaming (CES) is now in public preview across all of Microsoft SQL. Learn about it, see some demos, and get the best tips and tricks. ✅ Chapters: 0:30 CES in public preview for SQL database in Fabric 1:00 Intro to scenarios for Change Event Streaming 3:15 Coupon microservice for bike sales demo / setting it up 6:00 How does CES work 7:13 What makes it different from CDC 8:44 Why mirroring vs CES 11:30 Tips and tricks ✅ Resources: https://aka.ms/ces-survey 📌 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

devblogs.microsoft.com

Bacpac and Dacpac, the similarities and differences - Azure SQL Dev Corner

When you need to move an entire database or move the objects in a database, bacpac and dacpac files often come up because of all of the tooling options to

techcommunity.microsoft.com

mssql-python 1.14.0: Faster Parameter Binding, Safer Errors, Correct Timeouts | Microsoft Community Hub

mssql-python 1.14.0 is now available on PyPI. This release moves the standard parameter detection and execution path into native C++, improving...

devblogs.microsoft.com

Beyond Vector Indexes: Azure SQL Brings Optimizer Intelligence to Vector Search - Azure SQL Dev Corner

Why production AI retrieval depends on more than vector index performance.  It's easy to think of AI retrieval as a vector search problem. For many

techcommunity.microsoft.com

Introducing Simplified Regional Limits for Azure SQL Managed Instance | Microsoft Community Hub

We are pleased to announce improvements to regional subscription limits for Azure SQL Managed Instance. These changes simplify subnet management and provide...

mrneilbryan.substack.com

The commercial case for database modernisation: why hybrid often wins

There’s a habit among technology leaders of treating database modernisation as optional housekeeping — a technical tidy-up to defer until the next budget cycle.

devblogs.microsoft.com

Outgrowing SQL Server Express? Upgrade to Azure SQL Database Free Tier in 3 Steps - Azure SQL Dev Corner

Upgrade from SQL Server Express to Azure SQL Database. You can build locally for free with Azure SQL Developer (a free container image of the Azure SQL Database engine, in preview) or deploy directly…

devblogs.microsoft.com

MSSQL Extension for VS Code: SQL Formatter, Azure SQL Database Provisioning, and More - Azure SQL Dev Corner

Explore the MSSQL Extension for VS Code v1.45 | What's New with SQL Formatter and Azure SQL Database features.

techcommunity.microsoft.com

Managing SQL Server on Linux Azure VMs with the SQL IaaS Agent Extension | Microsoft Community Hub

If you run SQL Server on a Linux virtual machine in Azure, the SQL Server IaaS Agent extension is the piece that connects your SQL Server instance to...

sqlreitse.com

SQL Server REGEX_LIKE confusion

I was trying out some things to learn more about RegEx when I ran into something weird. When using REGEX_LIKE in a query, I got an error in both SQL Server and Azure SQL Hyperscale. Now, I learned what will be shared in this blog from Cláudio Silva, Greg Low, and Erland Sommarskog. They were very kind to share their experiences and knowledge.