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 […]
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 […]
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 […]
T-SQL Tuesday #005: Cleanup Your Notification Emails With HTML Tables
Clean-up your email notifications with simple HTML tables. Easy to use, why sent plain text?Post (along with a poll) for #TSQL2sDAY
Help – My disk performance V
Part V in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers basic monitoring.