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 […]
Archive | Configuration RSS feed for this archive
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. […]
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 […]
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 […]
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.
Help – My disk performance VI
Part VI in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers additional monitoring, and wraps ups some leftovers from this series.
Help — My disk performance IV
Part IV in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers database filegroups and files.
Help – My disk performance III
Part III in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers database partitioning and compression.
Help – My disk performance II
Part II in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers physical connection, and LUN layout on a SAN.
StefBauer's Blog - @StefBauer 