Archive | Configuration RSS feed for this archive

PASS – Part 2

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

1 Comment Continue Reading →

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

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

1 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 →

SSIS – Package Configurations

SSIS package configurations allow for portability of packages, password management, and security.

4 Comments Continue Reading →

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.

1 Comment Continue Reading →

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.

4 Comments 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 →

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.

2 Comments Continue Reading →

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.

Leave a Comment Continue Reading →