Changing primary key index structure
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 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.
Explores the minimum delay for JavaScript timers like setTimeout, revealing browser-specific limits and implications for accurate timing.
A personal recap of the first two days at PyCon 2010, covering the Language Summit and key Python community discussions.
Announcement and preview of SQLBits VI, a free SQL Server conference in London focused on performance and scalability.
Compares the committer models and development processes of three Python projects: Unladen Swallow, PyPy, and Django.
A presentation on developing and deploying PHP applications on Microsoft's Windows Azure cloud platform, including slides and sample code.
Explains why using explicit, meaningful names for SQL constraints is better than relying on autogenerated names for easier maintenance and safer deployments.
A developer's solution for using Managed Fusion URL Rewriter to proxy requests from an IIS server to an internal Apache server.
Analysis of Oracle's fragmented online support ecosystem, comparing official blogs, forums, and communities to the effective Oracle-L mailing list.
Introduces Sharpy, an ASP.NET MVC view engine using Smarty syntax for cleaner, designer-friendly templates with extensibility via MEF.
Explains how to optimize SQL query performance by avoiding functions in WHERE clauses, using date filtering as a key example.
Explains how to use C# LINQ expressions to automatically generate null-safe property access, eliminating repetitive null-check code.
A developer details the process of converting a personal blog to HTML5, covering semantic elements, CSS adjustments, and IE compatibility.
A technique for creating custom checkboxes and radio buttons using CSS sprites, improving on an existing method for better image control.
A satirical take on becoming a 'superstar' developer is contrasted with genuine advice for becoming a truly productive 10x programmer.
A demonstration of recreating the iPhone keyboard interface using only CSS3, including gradients, shadows, and custom fonts.
Explains how to use the SP:StmtCompleted SQL Profiler event to identify slow individual statements within a stored procedure.
A developer shares their solution for managing asset loading sequences in ActionScript 3, using QueueLoader to handle dependencies on XML.