SQL Server

SSRS, SharePoint 2013, and SQL 2012 Standard Edition

When building out a new farm using SQL 2012 Standard and SharePoint 2010, a multi-server farm deployment with a dedicated SSRS server was possible. In SharePoint 2013 with SQL 2012 SP1, not so much possible, but […] Read More

First WordPress Post

I finally moved off of Community Server as my blog engine and migrated to this site using WordPress.  It’s all new to me so I’m still figuring out the settings, but with the help of […] Read More

Test Twitter Notifier from Live Writer

Trying out the Twitter Notifier using Live Writer.  Found in the Live Writer SDK for Technical Preview.  This should show up on my Twitter feed.

Nuggets from Working with Large Lists White Paper

Other than the obvious benefit of learning the best methods for dealing with large lists, there are a couple related nuggets covered in the white paper titled Working with Large Lists in Office SharePoint Server […] Read More

Using a CTE for Heirarchical Query

A project I did a few years back was for a large company with thousands of employees.  The project was essentially building a system to allow managers to evaluate employees and give them quarterly bonuses.  […] Read More

MyGeneration Released

On another project at my current client the developers decided to use a code generation tool to help them save some time.  They ended up using MyGeneration, which at the time was in beta, to […] Read More

SCHEMABINDING Option

I’ve never run into the situation where I was worried about a table being accidentally dropped (maybe I should have been?) as I usually let a good security model restrict that.  But, accidents do happen. […] Read More

Conditional JOIN’s

A co-worker asked me earlier today if there was a way to do a conditional join. Meaning he had two tables and he wanted to join to one or the other within his query, depending […] Read More