Simon Frazer

Free SQL Server Internals Sessions at EightKB 2024

1st August 2024

Don’t Miss EightKB: A Free Online Conference on SQL Server Internals EightKB is a free online conference dedicated to SQL Server internals. The next event is scheduled for Thursday, August 8th, starting at 13:00 UTC (which is currently 14:00 UK time). Why Attend EightKB? Kicking off with a 10-minute welcome, EightKB dives straight into five […]

Free SQL Server Internals Sessions at EightKB 2024 Read More »

Small wooden blocks with 4 of them spelling the word DATA

SQL Server’s Order of Execution

23rd July 2024

Lets start with something simple. I used to wonder why column aliases were valid in an ORDER BY clause, but not in a WHERE clause. It took me a few years to actually look this up and find out what’s going on, so today I’m sharing the answer with you in the hope it gets

SQL Server’s Order of Execution Read More »