Recently Posted Videos

Summary InfoQ presents a one hour video from the APLN Leadership Summit at Agile2006, where a panel of business leaders spoke about their experiences: Bud Phillips (Capital One Financial), Israel Ganot (BMC Software), Steven Ambrose (DTE Energy), Peter George (Cronos Inc.). Topics included top-down vs. bottom-up adoption, making the leap of faith to enterprise adoption and the value of the PMO....

Summary We wrap up Adam Cogan month with a thorough view under the covers of VSTS/TFS. Adam shows us things like how to modify the VSTS GUI and integrate VSTS with your databases, web services and exchange servers. Thanks for a great series Adam! Bio Adam Cogan is the Chief Architect at SSW, a Microsoft Certified Partner specializing in Visual Studio .NET 2005, Windows and Web, SQL Server, OLAP...

The 'select' command allows you to select (pull out) specific pieces of information from a database.

Pivot tables don't automatically update. Episode 267 will explain why and how to solve this.

They say that every data set has errors. Once you are able to summarize those 50,000 rows to a 5 line summary, people start spotting all kinds of errors. Wait a second! We never sold that product to this customer! You can double click to view the detail behind any pivot table cell. Episode 266 shows you how.

There is an annoying limitation when you try to insert new rows in a pivot table. Episode 265 shows you the limitation and walks through how to solve it.

How to change an existing pivot table. Episode 264 shows you how.

You have 50,000 rows of transactional data and you need to produce a 3 line summary. Use a pivot table to solve this problem with just a few clicks. Episode 263 will walk you through creating your first pivot table.

Patrick Crowley gets you up to speed on using Haml and Sass. Haml is a drop in replacement for ERB that turns your views into beautiful code poetry. Sass does the same for CSS.

One of the great things about Photoshop is being able to easily fake real world objects. In this episode of Quicktips I show you how to easily create a neon sign using layer styles in Photoshop.