Debugging T-SQL using Visual Studio

This continues my series on auditing SQL Server. The fist parts covered discovery and documentation, server level hardware audits and SQL Server engine level audits. This section examines database configuration audits.

Announcement: System.Data.SqlClient package is now deprecated

SQL Server Performance Tuning Series

Microsoft. Data.SqlClient 5.2 preview 4 is out, and includes the new high performance SqlBatch API: execute multiple commands in a single network roundtrip 

Since 1999, SQL is not limited to the relational model anymore.
Back then ISO/IEC 9075 (the “SQL standard”) added arrays, objects and recursive queries. In the meanwhile the SQL standard has grown five times bigger than SQL-92. In other words: relational SQL is only about 20% of modern SQL.0 

The SQL Server Performance Tuning Tasting Menu
20 videos 

Top 8 Free, Open Source SQL Clients 

The TOPDB Top Database Index is created by analyzing how often database names are searched on Google 

GitHub Copilot Examples to Create SQL Server Indexes and Tune Queries