Introduction I have to say that this has not turned into the “series” that I projected so optimistically as I departed for the PASS summit. It may still be a series, who knows, but for now, as I sit in the airport waiting for my flight back home I figure I would get a few thoughts […]
Want To Upgrade?
Introduction I have seen several posts lately asking about ROI/Justifications etc about upgrades. There are LOTS of posts on this topic, and some really great documentation from Microsoft that covers this topic at great length. This post does not really add anything to those, other than distilling some of the key points from the Microsoft […]
Warehouse Design Tip / Partitioning
Introduction This topic seems so simple, and so obvious to me, and do not mean to insult anyone’s intelligence. However, it is shocking to me the number of people that I have talked to (running large databases) that are not taking advantage of one of the best performance, and manageability enhancements out there! Think about […]
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 […]
Help me pick a winning title!
Help me pick a winning presentation title!
SSIS – Load Audit
Audits in SSIS create reusable packages that are easy to maintain, and provide valuable information about the data they are affecting.
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
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.
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 […]
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.