Links for the Week of 2009.07.31
SQL SERVER
Fast Running Totals solution with ordered CTE update? Who says you need a cursor to get a running total? I’ve typically done these kinds of things with expensive CROSS JOINs and/or nasty INNER JOINs. Good to know there’s a nicer way. Extended Events Manager Update: Now A SSMS Addin SQL 2008 Extended Events are a powerful new way of troubleshooting problems with SQL Server. One short coming is that there is no UI support for this new feature. (Fromcodeplex)
DEVELOPMENT
Think First, Doing Is For Later A non-TDD approach to solving programming problems. Branch Per Feature Source Control Part 2: How (Theory) Basecamp, now with more vroom Ever wonder how people go about testing applications to see where there hardware starts to fall apart? Mark over at 37signals did just that and blogged about how they got some impressive performance gains fairly quickly.