Shawn Weisfeld

I find when I talk to myself nobody listens. - Shawn Weisfeld
posts - 365, comments - 180, trackbacks - 34

My Links


Shawn Weisfeld's Facebook profile

The views expressed in this blog are mine and mine alone, not that of my employer, Microsoft, or anyone else’s. No warrantee is given for the quality of any material on this site.


Post Categories

August 2007 Entries

Jax CodeCamp Presentations

Here are my two presentations from the Jax CodeCamp. OOP Robot Vision

posted @ Sunday, August 26, 2007 2:09 PM | Feedback (0) | Filed Under [ .NET C# Robotics ]

Factory Pattern

I was asked a question last night about the factory pattern. Factories construct and return an instance of a class type. Why you might ask, well first all the creational logic for my classes exist in one place. Secondly no modifications are needed to the factory if a new implementation is created (i.e. the factory is not tied to any specific concrete implementation). Here is a reference implementation:     /// <summary>    /// Base Class for all accounts    /// </summary>    public abstract class Account    {        /// <summary>        /// Override of the ToString so we can see what type of account we have        ///...

posted @ Friday, August 24, 2007 5:19 PM | Feedback (0) | Filed Under [ .NET C# ]

A Gift for Teaching Push for Pencils & Earthquake in Peru

At the last few user group meetings ( we have been collecting schools supplies for needy children in Central Florida. In total we have collected over 1400 items: including 432 crayons, 428 pencils, 228 colored pencils and 210 pens. Thank you to everyone that has contributed! We also collected $50 in donations for the Earthquake victims in Peru at the meeting last night. The donation has been forwarded to the American Red Cross.   Here are PDF's of the Thank you letters ONETUG got from A Gift for Teaching and the Red Cross

posted @ Friday, August 24, 2007 2:19 PM | Feedback (0) |

Flatten a Hierarchy in SQL Server 2005

Hierarchies are common in many applications today. Some classic examples are the reporting chain in your company. For example you are an employee and you report to another employee and that employee. A common way to represent this is utilizing an "Adjacency List Model". A good explanation of this can be found in Joe Celko’s book and on this website ( The basic idea is that a boss column exists on the employee table a unary relationship. So utilizing the new common table expression ( in sql server 2005 it is easy to build a hierarchical query. Once the hierarcial...

posted @ Tuesday, August 21, 2007 9:11 PM | Feedback (0) | Filed Under [ Microsoft SQL ]

SPN’s (Service Principal Names)

Having problems authenticating? Maybe you need an SPN? Here is some information on SPN’s (Service Principal Names), but basically SPN’s allow a client to find a service for Kerberos authentication. SPN information from MSDN SPN information from TechNet SPN information from SQL Server Docs

posted @ Thursday, August 16, 2007 1:54 PM | Feedback (0) | Filed Under [ .NET ASP.NET Microsoft Windows ]

Other Orlando UG’s & TSQL Random Raffle Picker

So this has been a busy week for me. Tuesday I went to my first Orlando SQL Server UG meeting ( and Wednesday I went to the first Orlando SharePoint UG meeting ( A big thumbs up go to both groups for very successful presentations. So Andy from OPASS did something very interesting at his meeting he challenged all the attendees to figure out a puzzle. Go here ( to get the full details of the puzzle but basically the task was to build a random raffle picker utilizing TSQL and data from the Adventure Works database in SQL Server...

posted @ Thursday, August 9, 2007 2:13 AM | Feedback (0) | Filed Under [ Microsoft SQL ]

Powered by: