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 […]
Archive | SQL Server 2008 RSS feed for this archive
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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. […]
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 […]
Help me pick a winning title!
Help me pick a winning presentation title!
StefBauer's Blog - @StefBauer 