Dew Drop - July 21, 2026 (#4716)
Summary of July 21, 2026 tech links covering PowerShell, .NET MAUI, Azure AI, web dev, AI agents, and Windows development.
Summary of July 21, 2026 tech links covering PowerShell, .NET MAUI, Azure AI, web dev, AI agents, and Windows development.
SQL Server diagnostic queries for July 2026, covering configuration, performance, and T-SQL scripts for various versions.
Roundup of T-SQL Tuesday #199 blog party discussing the challenges and considerations of moving back to on-premises from cloud computing.
SQL Server diagnostic queries for performance and configuration analysis, covering versions from 2005 to 2025 and Azure.
SQL Server diagnostic queries for May 2026, covering configuration, performance, and memory analysis for multiple SQL Server versions.
SQL Server diagnostic queries for performance and configuration analysis, updated for April 2026.
A blog post urging SQL Server DBAs to upgrade SSMS, highlighting new features like improved code completion and easier installation.
Overview of official documentation, learning resources, and training materials for Microsoft SQL Server 2025.
Explores new SQL Server 2025 T-SQL features: the || string concatenation operator and the ||= compound assignment operator.
Explains the new UNISTR() T-SQL function in SQL Server 2025 for handling Unicode strings, emojis, and escape sequences.
Announcing a full-day SQL Server performance monitoring and troubleshooting PreCon session at SQLSaturday NYC 2025, led by a former Microsoft PM.
A technical guide on using jOOQ to pass table-valued parameters (TVPs) to T-SQL functions from Java, with code examples.
Guide to resolving common U-SQL syntax errors caused by capitalization and missing semicolons, especially for T-SQL users.
Explores MERGE DML statement support for Graph tables in SQL Server and Azure SQL Database, focusing on UPSERT operations for node and edge tables.
Announcing a free, open-source tool for collecting and parsing SQL Server deadlock graphs from system memory, aiding administrators and developers.
Discusses the importance of naming conventions and coding style for readability and productivity, with examples from SQL and C++.