A technical guide on reducing SQL database size by normalizing repeated data like IPs and User Agents into separate relational tables.
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.
SQL queries to analyze and identify performance bottlenecks in Oracle Data Integrator (ODI) batch jobs with many tasks.
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 on extending the QUERY_TEXT column length in OBIEE usage tracking to prevent SQL truncation errors.
Explains and solves the Oracle SQL error ORA-00922 when changing a user password, highlighting the need to quote passwords starting with numbers.
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.
