Rehearse a piecemeal restore that brings PRIMARY and current data online first, then restores archive filegroups with the right log chain.
SQL SERVER – Basic Explanation of Query Hint NOWAIT – How to Not Wait on Locked Query
Everybody knows NOLOCK, but not everyone knows NOWAIT. A question at a Bangalore User Group session led me to explain how NOWAIT skips waiting on a lock.
SQL SERVER – How to Use Instead of Trigger
Triggers come in two kinds, Instead of and After. Here is how an Instead of Trigger can intercept an insert, update or delete on a table, with an example.
TRIM Function in SQL Server: SQL in Sixty Seconds #040
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.