Archive | SQL Server 2008 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 →

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

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

Help me pick a winning title!

Help me pick a winning presentation title!

1 Comment Continue Reading →