A guide to using EXPLAIN and EXPLAIN ANALYZE in PostgreSQL, including JSON output and visualization tools for query execution plans.
A comprehensive list of reserved keywords in JavaScript, detailing their evolution across different ECMAScript versions and usage rules.
An open letter advising government CIOs to adopt lean, iterative, decentralized, and open development practices for better tech outcomes.
Guide to running Oracle OBIEE SampleApp 305 on VMware Fusion instead of VirtualBox, including VM setup and tools installation.
A technical article proposing a null model to analyze age and multiple infection effects in Sudden Oak Death disease dynamics, using mathematical modeling.
Explores the need for responsive images in web development, analyzing performance benefits and implementation challenges.
Developer creates an open-source web app to calculate screen DPI/PPI, detailing the project's inspiration, features, and development process.
Compares file sizes between SQL Server Extended Events and deprecated SQL Trace, finding XML format adds ~29% overhead.
A technical article explaining how to count character frequencies in a text file using Objective-C and Grand Central Dispatch for asynchronous file I/O.
A statistics professor details his hardware and software setup, including Mac laptops, R, LaTeX, and plans to learn JavaScript.
Explores Java generics, type erasure, and how to retrieve generic type arguments at runtime despite common misconceptions.
Explores using LLVM and Go to statically recompile NES games into native executables, detailing technical challenges and solutions.
A summary of upcoming technical talks on statistical computing, rare DNA variant analysis, and handling large datasets with R and SQL.
Cimbalino Windows Phone Toolkit v3.0.0 released, featuring async/await support for WP7 and new services, requiring Visual Studio 2012.
Mitchell Hashimoto shares his lifelong passion for automation, from cheating Neopets to creating Vagrant, highlighting how it shaped his career.
A review of the 2013 'beyond tellerrand' conference, highlighting talks on web sustainability, design, and development.
Fixing a SQL Server 2008 R2 in-place upgrade error related to service account logon format (UPN vs. Down-Level Name).
A tutorial on using Git's sparse checkout feature to clone only specific directories from a large repository, saving disk space.
Explains how to configure the `top` command in OS X to sort by CPU usage by default using a shell alias.
Explains the importance of Vertical Rhythm in web design and provides a step-by-step guide to implementing it for a more professional website layout.
