links for 2011-03-11
The Joel Test: 12 Steps to Better Code - Joel on Software
Author Archive
T-SQL: Splitting one row into many
Something for your SQL toolbox…
I was recently challenged with needing to split a row into multiple rows (a quantity across multiple dates).
We were using a CURSOR, but the performance was horrible. When I converted it to a recursive CTE it went from 6+ minutes to a few seconds!
Below was my “theorem proof” before I implemented [...]
links for 2010-12-14
How to Customize/Change Windows 7 Logon Background Wallpaper Screen
(tags: win7 windows7 windows os customize)
links for 2010-12-10
SQL to Select a random row from a database table
(tags: sql random database programming reference db tips)
links for 2010-12-07
Built-in WPF IValueConverters - Stack Overflow
(tags: wpf converter)
diff/merge configuration in Team Foundation - common Command and Argument values - James Manning's blog - Site Home - MSDN Blogs
(tags: TFS diff merge compare tools)
Windows 7 – VHD Boot – Setup Guideline - knom's developer corner - Site Home - MSDN Blogs
(tags: windows7 vhd microsoft windows virtualization)
Download Microsoft’s Learning Center “Snacks”
Use the “Video Snack Downloader” to download all of the Microsoft Learning “Snack” Videos to your local machine! Video Snack Downloader is a small, open source application for discovering the videos available on the Microsoft Learning “Snacks” website and downloading them to your local machine for offline viewing.
Effective Branching and Merging in TFS 2010
Many people still struggle with effective branching and merging in TFS; either in understanding the concepts or applying them. I have attempted to address this through a demo using TFS 2010 and Microsoft’s TFS Guidance from the Patterns & Practices and “ALM Rangers” teams.
Microsoft also released the ability to customize the TFS process template guidance [...]
Microsoft’s “Dynamic IT” 7-year anniversary at Tech·Ed!
MS Tech·Ed North Ameria has been running this week in New Orleans…
Watch the Tech·Ed videos online - The keynotes (1 and 2) have great insight into Microsoft’s vision; how their 7-year old promise of “Dynamic IT” is just beginning to be realized this past year and even more so with their Azure cloud computing platform, System Center 2010, and [...]
Windows Service Accounts: Finally Avoid the Maintenance Nightmare!
You either love or hate “Local Service”, “Network Service”, and “Local System”. Have you ever avoided setting up individual Service Accounts for SQL Server, IIS, SharePoint, or other enterprise applications and simply defaulted these built-in accounts? Perhaps you didn’t know that it’s “best practice” to use domain accounts for these services. Or, perhaps you knew [...]
Forrester Blogs Revamped - Making Leaders Successful
Most of us use Forrester, Gartner, and any number of other aggregated information hubs for reducing the communication clutter to make effective decisions. Forrester recently revamped their blogging strategy and platform to improve information access and updates. Inevitably, this social aspect of Forrester’s research will provide insight that wasn’t possible through the standard email alerts, [...]
