Author Archives | stefbauer

PASS – part1

Introduction   Normally, my blog is technical in nature, and (hopefully) generally helpful. This series will likely be nothing like that…. maybe helpful for something, but most likely not. As I sit and write this introduction, I am aboard a United flight looking out the window at the Appalachian mountains en-route to Chicago and then […]

Leave a Comment Continue Reading →

Want To Upgrade?

Introduction I have seen several posts lately asking about ROI/Justifications etc about upgrades. There are LOTS of posts on this topic, and some really great documentation from Microsoft that covers this topic at great length. This post does not really add anything to those, other than distilling some of the key points from the Microsoft […]

Leave a Comment Continue Reading →

T-SQL Tuesday #009 – Beach Time

I almost missed this #Tsq2sday post, as I was on vacation last week, and am just catching up and digging out from my post-vacation pile. So this month’s topic “T-SQL Tuesday #009: Beach Time” is actually very timely! Honestly though, working in a small shop I need to bend the “turn off technology” rule just […]

3 Comments Continue Reading →

Warehouse Design Tip / Partitioning

Introduction This topic seems so simple, and so obvious to me, and do not mean to insult anyone’s intelligence.  However, it is shocking to me the number of people that I have talked to (running large databases) that are not taking advantage  of one of the best performance, and manageability enhancements out there!  Think about […]

1 Comment Continue Reading →

Presenting Data Warehouse Disk Configuration for PASS BI

I am honored to present Data Warehouse Disk Configuration to the PASS BI Virtual Chapter Thursday June 10th at Noon EDT via LiveMeeting! Details here. Speaker Rate Me! This is a FULL hour, normally a 75 minute presentation, so be prepared for a lot of information at a quick pace!  I hope you can join me for […]

Leave a Comment Continue Reading →

My Favorite New(ish) 2008 Feature (Resource Governor)

I have written in the past about setting up the resource governor, which I am counting as my favorite new(ish) feature, so I am taking this TSQL2sday post opportunity do my promised followup for monitoring of the resource governor. Introduction To start with, my advice about the resource governor is to start small.  Have some idea […]

4 Comments Continue Reading →

Richmond Codecamp 2010.1

First off, my blogg is normally technical, and (hopefully) informative…. this post is none of that, I just wanted to wrap-up my experience at Richmond CodeCamp with a few random thought about the event. I have been to plenty of conferences over the years, but never having never attended codecamp, I was not exactly sure what […]

2 Comments Continue Reading →

Richmond CodeCamp Disk IO Presentation

This is a very similar post to the one from the user-group presentation post… and in fact the presentation itself is very similar.  It has been updated, and a few things added since the last presentation, so I did want to post the updated version which was presented at codecamp.   I hope that the presentation left you […]

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 →