How rewriting a MySQL query to use indexes properly improved performance from 10 seconds to 0.03 seconds.
A developer builds an FTP server bridge to access and manage Windows Azure Blob Storage, allowing file operations via standard FTP clients.
Explores whether programming languages inherently have performance characteristics by comparing Python and C implementations.
A developer's personal experience and key takeaways from attending the QCon London 2010 technology conference, covering talks on architecture and .NET.
A web-based tool for testing and understanding CSS3 structural pseudo-class selectors like nth-child and nth-of-type with live element manipulation.
A developer's postmortem analysis of a personal game project, 'A Geek Valentine', covering development time, graphics, and simple AI implementation.
How to resolve ORA-13757 error when deleting an active SQL Tuning Set in Oracle, including diagnostic queries and cleanup steps.
A personal recap of the author's experiences and key technical talks from days 2-4 of the PyCon 2010 conference.
Exploring GCC-CLI, an experimental GCC branch with a .NET CIL backend and frontend for compiling between native and managed code.
Discusses a security vulnerability in OBIEE's JMX remote access and provides steps to secure it with password authentication.
Troubleshooting an OBIEE authentication failure caused by an expired cookie from a misconfigured F5 load balancer in an EBS integration.
Explores the evolving role of the 'DevBA'—a database developer who incorporates DBA skills like performance tuning and using DMVs to build better systems.
Explains the Managed Extensibility Framework (MEF) using a shed-building analogy, focusing on its core concepts: export, import, and compose.
A free driver for Windows 7 Location API that provides geolocation to apps using Google's services via WiFi or IP.
Oracle's performance recommendations for OBIA 7.9.6, focusing on ETL improvements and hardware sizing.
Explains how to implement a queue processing system in SQL Server using table hints like UPDLOCK and READPAST to ensure reliable, concurrent processing.
A technical guide on safely converting a SQL Server primary key index from nonclustered to clustered (or vice versa) using a temporary unique constraint.
A guide to the simplest Mercurial workflow, 'Branch as Needed,' for small projects, contrasting with structured Git models.
A developer creates a Valentine's Day-themed game about a geek avoiding girls using traps and a time machine.
A personal recap of the first two days at PyCon 2010, covering the Language Summit and key Python community discussions.
