Brent Ozar (@BrentO) and I got together for a quick podcast on SQL 2008 Policy Based Management. In part one we discuss how to import the sample policies that are included with SQL 2008 by default (but not enabled), find some databases that Brent has placed the data and logs on the same drive, and [...]
SQL 2008
AutoGrow Apparently Means "I Don’t Care"
Well, at least that is the impression I have from Operations Manager. Let me explain why.
It all started around the time we were making some adjustments to one of our servers that was not performing as well as our end users would have liked. The short end of that story is that we ended up [...]
PASS Webinars Coming Up in May
PASS has started up a monthly email newsletter for people interested in attending upcoming free webinars. If you want to subscribe and get on the mailing list just drop an email to Blythe Morrow. Did I mention that these webinars are free? Check out the names listed and tell me if you are going to [...]
SSAS Weird Science
The other day we did an install of SSAS on a server without loading the database engine. Everything went fine, the end user started accessing the service and then we started talking about how we should make certain we are taking backups of the objects that are being created. Now, how would you think to [...]
Predictive Analysis
Quick question: Where would you go to find some basil in your local grocery store? Did you say “by the other herbs?” Or did you say “by the tomatoes?” If you are like me, then you would go looking for basil by the other herbs because, well, that is a natural, logical grouping of products. [...]
There’s a SQL In My Pocket
While shuffling some books around at home today I came across the SQL 2008 Administrator’s Pocket Consultant by William Stanek. I cannot imagine the person who has pockets big enough for this book other than the Jolly Green Giant. But since I have never met Mr. Stanek I suppose it is possible he could have [...]