SQL Server Diagnostic Information Queries for September 2025
Updated T-SQL diagnostic queries for SQL Server (2005-2025) and Azure SQL to analyze instance configuration and performance.
Updated T-SQL diagnostic queries for SQL Server (2005-2025) and Azure SQL to analyze instance configuration and performance.
Explains how Azure Arc provides unified management for hybrid and multi-cloud environments, bringing on-prem and other cloud resources into Azure's control plane.
Analyzes Apple's shift from ObservableObject and @Published to the @Observable macro, highlighting gaps in the new Observation framework for SwiftUI developers.
Explains how to create custom AI personas in GitHub Copilot Chat for specialized tasks like security reviews, documentation, and refactoring.
A tutorial on setting up a three-node Postgres cluster using EDB's PGD CLI for high availability and logical replication in AWS.
Microsoft announces Visual Studio 2026 Public Preview with performance improvements, new features, and the new Insiders channel.
Explores color sensitivity in AI models when reading text from a canvas, noting issues with red text on dark backgrounds.
Explores using Azure's global services like Front Door and CDN to reduce latency and improve app performance for users worldwide.
A developer shares their troubleshooting journey fixing a broken SSH connection on Ubuntu after an update, caused by a problematic systemd socket override.
A security researcher details a SQL Server auditing bug that allows low-privilege users to exfiltrate sensitive data without detection.
Expert tips and best practices for designing and troubleshooting secure Azure network solutions, focusing on hub-and-spoke topology.
A guide to profiling Java applications on Cloud Foundry using the cf CLI Java plugin for heap and thread dumps.
Strategies for scaling and optimizing Apache Iceberg data compaction jobs, including parallelism, checkpointing, and failure recovery.
A guide to using Azure Cost Management and Budgets for monitoring, analyzing, and optimizing cloud spending to prevent cost overruns.
The development story of Circuits Royale, a fast-paced, communal web-based word game powered by LLMs for real-time validation.
A guide for .NET developers to build an AI chat app with RAG and image generation using .NET, MCP, and Hugging Face in under 10 minutes.
Explores designing a multi-agent AI system by creating autonomous agents that play the word game Taboo, focusing on agent communication and orchestration.
Explores the role of Large Language Models (LLMs) in AI, covering major model families, providers, and concepts like hallucinations.
A guide to creating custom chat modes in GitHub Copilot, with examples for Azure Bicep to define specialized AI agent roles.
Explains how ToDictionaryAsync in Entity Framework Core retrieves entire database objects, impacting performance, and provides a solution using Select.