A weekly tech review about .Net , Cloud, web, and so much more!

Want to run a fully managed SQL Server in Azure without paying a cent? The Azure SQL Managed Instance free offer gives you just that. With 720 vCore hours of compute, 64 GB of storage you can have up to 500 databases for free for 12 months. Strahinja will show how to create a free SQL Managed Instance from the Azure portal, walk through what the free offer actually covers, and connect to it so you can start testing real workloads today. ✅ Chapters: 0:40 What is the free offer for Azure SQL Managed Instance 1:19 Details of what exactly you get for free 2:00 How long you can run it and how start/stop works 3:38 Limitations in the offer 4:05 Free and generous but not recommended for production 5:15 What's not supported 5:35 Expiration and upgrade process 6:02 Demo - how to get started 7:30 Demo - once it is created 8:10 Demo - how to connect with public endpoint 9:00 Demo - how to do a native restore into Azure SQL Managed Instance 10:15 Demo - how the restore works 10:40 What prerequisites do you have to have to get a free Azure SQL Managed Instance 11:48 Demo - how to monitor your free credits 12:35 Demo - how to switch to the paid tier 13:40 Demo - tips and tricks for getting started ✅ Resources: Create Free Azure SQL Managed Instance: aka.ms/create-free-sqlmi-de Learn more: aka.ms/freesqlmi 📌 Let's connect: Strahinja Rodic - https://www.linkedin.com/in/strahinjarodic/, @Strale15 on X 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

Learn how to troubleshoot SQL Server blocking problems, identify head blockers, diagnose long-running transactions, and resolve common scenarios.

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.

Where does AI actually make a difference and where doesn't it? Davide Mauri shares a real-world example of using AI to help developers find the resources they need faster, without changing the core purpose of the application. #ai #developers #azuresql #softwaredevelopment #cloudcomputing

#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

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

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

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

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

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

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.

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…

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

PowerShellでSQLの操作をしたことがなかったので、ついでにとAzureSQLに対してやってみようと思います。今 ...

New to Azure and not sure where to start? Davide Mauri shares his first recommendation for developers looking to build a full-stack AI application without breaking the bank. #azure #ai #developers #cloudcomputing #azuresql

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

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.

Learn how Microsoft.Data.SqlClient configurable retry logic handles transient SQL Server failures with built-in retry policies, without requiring Polly.

Hybrid search is usually described as combining keyword search with vector search. Microsoft SQL does that, for sure, but we do quite a bit more right out

Zone redundancy for Azure SQL Managed Instance Next-Gen GP is now in public preview, delivering a 99.995% availability SLA with Availability Zones.