**EDIT** I don’t normally go back and edit things in a prior post… but… in this case the additional link to Werner Vogels blog that came out after I wrote this is worthwhile to the topic at hand. **EDIT** As I alluded to in the prior post, I have been busy… I have actually been busy […]
Tag Archives: Configuration
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 […]
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.
StefBauer's Blog - @StefBauer 