Tag Archives: Configuration

What does that checkbox do? (Redshift Encryption)

**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 […]

3 Comments 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 […]

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 →

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.

7 Comments Continue Reading →