Articles I read in 2008

It's a new year, and it's time to share a list of most articles I read the last year. Hopefully you find it interesting and useful.

2007 list can be fond here

• Sanity Checks for Your ASP.NET Web Site
• ICallback and JSON-Based JavaScript Serialization
• .NET Tip: Creating a Thread-Safe Singleton
• Interviewing thread on altdotnet
  
• 5 Tips for Becoming a Better Data Modeler
• When GETDATE() is not a constant
• When a Function is indeed a Constant
• SQL Server 2008 Launch - The Day After
• Exporting data to a remote server with SQL Express
• Creating objects - Perf implications
• Reading Code Is Hard
• The First Rule of Programming: It's Always Your Fault
• Updated SQL Injection
• Write Readable Code By Making Its Intentions Clear
• Short, concise and readable code - invert your logic and stop nesting already!
• Invert your logic part 2: For loops and while loops
  
• The HierarchyID Datatype in SQL Server 2008
• Column-Store Databases and DW Appliances: How to Make the Right Choice
  
• 4 Simple Rules for Handling SQL NULLs
• Standard Query Operators with LINQ
• Which to use: "<>" or "!="?
• 1753, datetime, and you
• Analysts: Upgrading to Vista SP1 on Intel Chips? Proceed with Caution
• More about sparse columns and column_sets
• Entity-Attribute-Value model
  
• Gotcha! SQL Aggregate Functions and NULL
• An editor's top six pet peeves
• Reviewing Article Submissions
  
• The Case of the Skewed Totals
  
• The "Numbers" or "Tally" Table: What it is and how it replaces a loop.
  
• Simplify SQL Server 2005 queries with a Dates table
• Name Value Pair - Part II
  
• Google and the Wisdom of Clouds
• IFileOperation in Windows Vista
• Is a Temporary Table Really Necessary?
  
• Implementing Table Inheritance in SQL Server
• Implementing Table Interfaces
• AOP Using Spring.NET - Part 1
• Five things you should never tell your boss
• Five things you should always tell your boss
• Correlated Joins Using "Apply"
• Introduction to JavaServer Faces
• How to solve Windows system crashes in minutes
• The 10 Commandments of Web Design
• 10 of the Biggest Platform Development Mistakes
• Programmer Competency Matrix
• Calculating Age
• Return Query Text Along With sp_who2 Using Dynamic Management Views
• Log Shipping vs. Replication
• The New ETL Paradigm
• Bookmark Lookups
• The Great Debate: Security by Obscurity
• Security by Obscurity?
• Outer joins and ON clauses vs. WHERE clauses
• Digging into IDisposable
• Warning: SharePoint can create chaos if not used properly
• Tough Choices: How Making Decisions Tires Your Brain
• Linus Torvalds, Geek of the Week
• Deployment Pipelines: Revolutionizing Release Management
• 7 Ways to Improve Your Software Release Management
• Quality Doesn’t Just Happen
• Four Qualities of a Top Performing IT Department
  
• Dynamically generating typed objects in .NET
• IDictionary options - performance test - SortedList vs. SortedDictionary vs. Dictionary vs. Hashtable
• Software Tool design: The Three Rs - Part 1: The Three ‘R’s – Research, Research & Research
• JSON and other data serialization languages
• Five Things Linus Torvalds Has Learned About Managing Software Projects
• Is unit testing doomed?
• Microsoft worried over .NET fragmentation
• How do Convert IP Address to Country Name
• ASP.NET gets no Respect
• Google App Engine: Getting Data Out Ain't Simple. Yet.
• Top 10 Performance Improvements in IIS 7.0
• The Agile System Development Lifecycle (SDLC)
• 7 Agile Leadership Lessons for the Suits
• Has Agile Peaked? Let's look at the numbers
• Agile Adoption Rate Survey: February 2008
• Local Temporary Tables and Table Variables
• Design pattern – Inversion of control and Dependency injection
• Design Patterns: Dependency Injection
• Management Studio Improvements in SQL Server 2008
• Changing Good Programmers into Great Programmers
• Ten career-damaging behaviours to avoid
• Threat Modeling: Uncover Security Design Flaws Using The STRIDE Approach
• Cloud computing is a trap, warns GNU founder Richard Stallman
• Speeding up the Performance of Table Counts in SQL Server 2005
• Does Your Database Contain Sensitive Data?
• Brad's Sure DBA Checklist
• Using Covering Indexes to Improve Query Performance
• Why This SQL Server DBA is Learning Powershell
• Five old-fashioned Web concepts that need to die
• How Cloud Computing Works
• At Your Service: Versioning Options
• Moving Large Table to Different File Group
• SQL Server 2008 SSMS Enhancements - Debugging Support
• Engineering 7: A view from the bottom
• Everything You Know About CSS Is Wrong
• Microsoft to unveil tools to push identity platform into the cloud
• PDC: Anders Gets Dynamic on Future of C#
• Microsoft Delivers Oslo Components
• Microsoft Launches Windows Azure for the Cloud
• Get Rid of the Performance Review!
• Ten Tech Interview Errors
• Architecting .NET Web Applications for Scale & Performance (A Practical Guide)
• The inside view of Microsoft's cloud strategy
• Patterns in Practice: Cohesion And Coupling
• Super Sizing Columns in SQL Server
• Once Thought Safe, WPA Wi-Fi Encryption Is Cracked
• Microsoft: 'Geneva' Will Help Change Access Paradigm
• Security Quiz: Test Your Security IQ
• Agile SDL: Streamline Security Practices For Agile Development
• Test Run: Group Determination In Software Testing
• Service Station: Authorization In WCF-Based Services
• SQL Server 2008 Top 10 List for Developers
• Invoking Stored Procedures through a One Line Native .NET Method Call
• Restore Transaction Logs for Point in Time Recovery
• New Features in Visual Studio 2010 and the .NET Framework 4.0
• Notes from Microsoft PDC 2008
• Test-Driven Development of T-SQL Code
• Implementing Change Data Capture in Microsoft® SQL Server 2008
• Auto generated SQL Server keys - uniqueidentifier or IDENTITY
• Normalizing-Denormalized Tables
• Selecting Rows Randomly from a Large Table
• Is It Worth Upgrading to SQL Server 2008
• A journey into Expressions
• Using SOAP Faults
• AnemicDomainModel
• Inversion of Control Containers and the Dependency Injection pattern
• Five Strategies Microsoft Got Right
• Filtered Indexes in SQL Server 2008
• .NET Garbage Collector PopQuiz - Followup
• Cheat Sheet – patterns & practices Security Engineering
• Does Google Have a Secret OS?
• Power and Deception of CTEs
• SQL Server Data Warehouse Cribsheet
• ASP.NET MVC 101
• How To Avoid Msg 106
• It's Time to Get Good at Functional Programming
• Ten Commandments of Egoless Programming
• Inside VSTS: Code Metrics
• 5 Reasons for Software Developers to Do Code Reviews (Even If You Think They're a Waste of Time)
• The A-Z of Programming Languages: F#
• KBSoft IP Locator
• 10 Useful Techniques To Improve Your User Interface Designs
• Validate Business Objects Declaratively