Reconcile table size reports by reading reserved, used, data, index, and unused pages from sys.dm_db_partition_stats on SQL Server.
SQL SERVER – A List of Various SQL Server RTM and Service Pack Number
Which SQL Server version are you running, and is it the latest? My list of RTM and Service Pack Number values to check your production server against.
SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 4
A recap of this case of redundant indexes, from Jon and Mike’s basics to the demos where redundant indexes are useful with small and large result sets.
Configure Database Mail in SQL Server: SQL in Sixty Seconds #039
To configure Database Mail, you need an SMTP account, a profile and permission to use it. The tests here build all three with T-SQL on SQL Server 2025, show the exact errors for missing access, and follow a failed send through the mail log.
SQL SERVER – Introduction of Showplan Warning
SQL Server can be your performance tuning teacher. Vinod Kumar explains the Showplan Warning in execution plans and what each warning is telling you.
CONTEXT_INFO: Passing a Value Through a Session
CONTEXT_INFO lets you attach a small value to a session and read it anywhere in that session, even inside a trigger. This post tests SET CONTEXT_INFO on SQL Server 2025, uses it to log who changed a price, and compares it with SESSION_CONTEXT.
Making SSIS Packages Faster
Make SSIS packages faster by measuring each flow, using fast load, sizing buffers from row width, and replacing row-by-row work.