A reminder to cancel free tech event registrations if you can't attend, freeing up spots for others on waiting lists.
A guide to displaying generated SQL queries in the Rails 3 console by configuring ActiveRecord's logger to output to STDOUT.
Explains the GROUPING SETS operator in SQL Server for flexible data aggregation, comparing it to UNION ALL and WITH CUBE approaches.
A technical guide on optimizing SQL queries with wildcard-prefixed LIKE conditions using indexed computed columns for better performance.
A personal recap of attending SQLBits VI, covering sessions on SQL Server performance tuning, parallel query execution, and the query optimizer.
Explains how to optimize SQL query performance by avoiding functions in WHERE clauses, using date filtering as a key example.
A technical guide showing how to get the UNIX timestamp for New Year's Day in MySQL, Excel, and Visual BASIC.
A technical guide on integrating OpenSER with FreeRADIUS, covering patching, configuration, and database schema modifications.
