The TRIM function removes spaces from the ends of a string, and SQL Server has had it since 2017. The tests here show which characters TRIM leaves behind, the LEADING and TRAILING keywords, and a WHERE clause that read 884 pages against 3.
SharePoint Conference Singapore 2013: A Great Experience
I had the great pleasure of presenting at SharePoint Conference Singapore 2013, my second visit to the event. I shared three database tips in a session inspired by SQL in Sixty Seconds, and the room overflowed. Here is my recap, with photographs.
Grandfather-Father-Son Retention: Choosing Which Backups to Keep
Which backups survive when you keep three days, two weeks and two months? A small query answers it, and then you check the real files.
Designing a Date Dimension
A date dimension makes reporting calendars explicit with fiscal periods, holidays, weekdays, and a repeatable SQL Server build script.
Why Table Size Numbers Disagree: Reserved, Used and Unused Space
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.










