Aaron Bertrand 10 March 2023

Build a Better WordPress Archives Page Using MySQL

0 Uncategorized

I recently wrote about a way to generate visual, interactive calendars in HTML by combining a calendar table with data from an events table (part 1 and part 2). This technique could be used to overlay any type of data onto calendars, but my specific goal was to make the monthly archives page on my … Read more

0 Uncategorized

Aaron Bertrand 23 February 2023

Find 40 Problems in this SQL Server Stored Procedure

T-SQL Programming

I’ve been at this for a while now, and have a very particular set of rules and coding conventions that I follow when writing and, more importantly, reviewing T-SQL code. I often perform code reviews and thought it would be fun to frame this exercise: a completely fictitious stored procedure hits my desk, I’ll reject … Read more

T-SQL Programming