SQL Server Management Studio – Export Query Results to Excel
The easiest way I’ve found involves two steps: Adjust SSMS Settings Go to Tools->Options Query Results->SQL Server->Results to Grid Check “Include column headers when copying or saving results” Click OK. […]
Continue ReadingLinq to SQL: Cast Stored Procedure Results to Table Entities
So you can probably tell that I’ve been doing a lot of LINQ lately. 🙂 One thing I’ve found is that it’s easier for me to write complex queries in […]
Continue ReadingjQuery Cheat Sheet
Yeah so this isn’t brand new. But the jQuery Cheat Sheet is for version 1.2, at least. Visual jQuery (which I still use a lot) is only for jQuery 1.1. I […]
Continue ReadingGrouping in Linq to SQL vs SQL
I wanted to put up a few examples of SQL vs Linq to SQL for my future reference, since we’re using it in one of our social media projects for […]
Continue ReadingLinqDataSource doesn't load child tables
FYI, there’s a bug in the RTM LinqDataSource where child tables aren’t loaded unless you have updating or deleting enabled. Apparently if you have a LinqDataSource that doesn’t have updates […]
Continue ReadingMarch Portland Open Coffee Club
It’s time for web-centric coffee again … The Portland Open Coffee Club is meeting next Wednesday, 10am, at Pier Coffee (600 NW Naito Parkway, near Glisan & 3rd). Pictures below […]
Continue ReadingGrids for Project Management
I noticed an interesting post from Allison Beckwith about Project Planning Grids. She also provided links to Todd Warfel”s Task Analysis Grid and Blink Interactive”s Objects & Actions Analysis. All […]
Continue Reading