Featured

Other Posts

Richmond Codecamp 2010.1

First off, my blogg is normally technical, and (hopefully) informative…. this post is none of that, I just wanted to wrap-up my experience at Richmond CodeCamp with a few random thought about the event. I have been to plenty of conferences over the years, but never having never attended codecamp, I was not exactly sure what […]

2 Comments Continue Reading →

Richmond CodeCamp Disk IO Presentation

This is a very similar post to the one from the user-group presentation post… and in fact the presentation itself is very similar.  It has been updated, and a few things added since the last presentation, so I did want to post the updated version which was presented at codecamp.   I hope that the presentation left you […]

1 Comment Continue Reading →

Richmond Users Group Disk IO Presentation

 A sincere thank you to everyone that came out to my presentation on disk IO.  I hope that you had as much fun as I did, and (hopefully) took away a few things to think about.  I would appreciate your feedback , I enjoy speaking, and the feedback helps me build better presentations for the future. […]

Continue Reading →

T-SQL Tuesday #006: Configure Filestream Storage for BLOBS

Introduction This is my post for the monthly TSQL Tuesday Blogging event.  With the release of SQL Server 2008, among the many new features was one that at first I took little notice of, FILESTREAM storage options. It did not take long to realize that this new feature has some powerful storage capabilities. You can […]

1 Comment Continue Reading →

Help me pick a winning title!

Help me pick a winning presentation title!

1 Comment Continue Reading →

SSIS – Load Audit

Audits in SSIS create reusable packages that are easy to maintain, and provide valuable information about the data they are affecting.

2 Comments Continue Reading →

T-SQL Tuesday #005: Cleanup Your Notification Emails With HTML Tables

Clean-up your email notifications with simple HTML tables. Easy to use, why sent plain text?Post (along with a poll) for #TSQL2sDAY

4 Comments Continue Reading →

SSIS Design Tip – Build For Restartability

SSIS package restartability is an important thing to think about as you think about design. It will allow for supporability, as well as ease and speed in new development.

Leave a Comment Continue Reading →

Data Warehouse – AutoShrink how-to

Introduction Space management is always a challenge in any system, however, in systems that are designed to grow-grow and grow, it seems to be a particularly big challenge as to how best manage space.  This post will give you an overview how to set the auto-shrink correctly to allow for even distribution of data within […]

Leave a Comment Continue Reading →

Warehouse Design Tip -Schema’s

Data Warehouse design tip, and example for the use of schemas. The ability to override a description in a dimension.

1 Comment Continue Reading →