Azure Weekly

Issue 580

20th September 2026

Highlights this week include:

🤖 AI

🔎 Analytics

  • Implementing Type 4 Slowly Changing Dimensions in SQL Server Type 4 SCD separates current and historical data to enhance query performance for dynamic attributes like bank customers' loan repayments while maintaining complete audit trails.
  • Running Fabric Pipelines from a Notebook Fabric REST APIs allow notebooks to trigger pipelines by polling activity-level statuses to ensure every individual task reaches a terminal state before proceeding.
  • What Does It Mean to Make Data AI-Ready? Making Data AI-Ready involves ensuring data accuracy, clear semantics, governance, accessibility, and business context enrichment.
  • Agent experience with data in Onelake using Fabric IQ Fabric IQ performs conversational analytics on integrated third-party and ERP data in Onelake, normalizing inputs such as misspelled city names to swiftly identify top revenue stores and customer footprints during retail promotions.
  • Foreign Keys and Performance in a Microsoft Fabric Warehouse Microsoft Fabric warehouses ignore foreign key constraints during query execution, meaning developers must enforce data integrity at the ingestion layer to ensure performance.

🖥️ Compute

🚢 Containers

🗄️ Databases

🛠️ Developer tools

🔩 DevOps

  • Dashboards are for AI agents too, not just humans Azure SRE Agent shows how AI interprets and acts on dashboards similar to human operators using Grafana data to diagnose lengthy GitHub Copilot sessions.
  • Tell AI Everything Twice, Then Tell It a Second Time LLMs suffer from context drift during long coding sessions, so developers should implement automated check gates and persistent rule files to enforce critical requirements.
  • Patching in 2026 with Susan Bradley Susan Bradley discusses how patching in 2026 is complicated by increased vulnerability disclosures, growing patch volumes, and slow vendor responses to drivers and firmware updates, creating a heightened pressure on sysadmins to balance security with operational stability.
  • Unexpected error when using the wrong ADO build agent Using an ADO self-hosted agent in a mixed public/private Azure environment can cause deployment errors due to its restricted network configuration preventing access to publicly accessible resources needed for the build process.
  • Ctrl+Alt+Azure Episode 360 - GitHub Enterprise explained 360 explains GitHub Enterprise, covering essential features, compliance options, licensing models, total cost of ownership, and recommended deployment strategies for organizations of any size.
  • Fixing complex bugs with AI - A deepdive into the PowerShellScriptAnalyzer The PowerShellScriptAnalyzer identified and partially fixed a bug causing Get-Command errors with AI assistance, emphasizing the necessity of thorough performance optimization.

🧬 Hybrid + multicloud

🎭 Identity

🔌 Integration

💡 Internet of Things

🎓 Learning and Certifications

⚖️ Management and Governance

🌐 Networking

🔐 Security

📦 Storage

💻 Virtual Desktop Infrastructure

Get Azure Weekly in your inbox every Sunday

Sign up to receive the email every week and keep on top of all the announcements.

Don't forget to confirm your subscription. We have a double opt-in sign up process to prevent spam.

We will never provide your details to any third parties. We don't spam.

Azure Weekly Logo