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 […]
Archive | 2010
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.
SSIS – Package Configurations
SSIS package configurations allow for portability of packages, password management, and security.
2008 Resource Governor – Does it work?
The resource governor in SQL Server 2008 is a powerful tool to help you gain control over your query runtimes.
SSIS Checksum – a must have skill
Overview When loading from source systems that don’t yet have the SQL Server 2008 Change Data Capture (CDC) enabled, using a checksum calculation to determine if data has changed is a critical Data Warehouse load concept to understand. This will allow you to read the source, that can have dozens of columns, and with a […]
StefBauer's Blog - @StefBauer 