Learn why setting application names in SQL Server connection strings is crucial for monitoring and debugging, with practical examples and tips.
Learn to play multi-player Texas Hold'Em poker using T-SQL stored procedures in Azure SQL DB, with commands to join, bet, fold, and more.
Brent Ozar explains why wide columns in SQL Server tables may not increase logical reads, using database animations and sp_tableoption.
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++.
Explores surprising SQL Server behavior where TRY_CAST and TRY_CONVERT return non-NULL values for empty strings when casting to certain types, with a type-by-type analysis.
