Aaron is an architect at Wayfair. We don't want to say he's old, but his experience dates back to a time when SQL Server 6.5 was considered "modern." He writes here at sqlperformance.com, over at sqlblog.org, and at MSSQLTips.
There is a very common anti-pattern you should avoid, involving updating a row if it exists and inserting it if it doesn't. See how to avoid race conditions and deadlocks.
Altering a fixed-width column on a large table can often mean either a lot of planning or a lot of downtime, but in some scenarios there may be an easy out.
Aaron Bertrand starts a series explaining how he evaluated the default trace and decided to replace it with a slimmer Extended Events session across all of production.
Aaron Bertrand continues his series on large table compression with results from row and page compression as well as a process involving scheduler manipulation.
