SQL 2008

This tag is associated with 1 posts

Good Way To Start Your Day

By Thomas LaRock ⋅ February 23, 2010 ⋅ 2 comments

I have a lot of things to read on a daily basis. Some of them are recreational, but most of them are aligned with my technical interests. It is rare for me to have the time to sit down and read one book from cover to cover. So I have started reading a handful of [...]

SQL 2008 R2 Upgrade

By Thomas LaRock ⋅ November 25, 2009 ⋅ 3 comments

I set aside some time today to install the latest SQL 2008 R2 CTP. You can download the CTP yourself by clicking on this link. I have a handful of test servers that I can use to install the CTP onto, and the idea was to do an in-place upgrade on an existing SQL 2008 [...]

Policy Based Management Podcast – Part 3

By Thomas LaRock ⋅ August 21, 2009 ⋅ Post a comment

Brent and I sum up the podcast in this final piece. Trust us: PBM is awesome. It is a nice complement to your existing monitoring solutions. With a little T-SQL you can easily create your own policies on demand. Plus we also suggest that it might be time for others to join us in the [...]

Policy Based Management Podcast – Part 2

By Thomas LaRock ⋅ August 20, 2009 ⋅ 3 comments

Continuing from yesterday we have part two of our podcast where Brent and I continue our discussion of PBM.
In this part we discuss how to use Central Management Server to deploy one policy against multiple servers, show a major usability FAIL in the SSMS GUI, hear Brent say he will edit something out that he [...]

Policy Based Management Podcast – Part 1

By Thomas LaRock ⋅ August 19, 2009 ⋅ 5 comments

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

AutoGrow Apparently Means “I Don’t Care”

By Thomas LaRock ⋅ May 27, 2009 ⋅ 4 comments

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

By Thomas LaRock ⋅ May 7, 2009 ⋅ Post a comment

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

By Thomas LaRock ⋅ May 5, 2009 ⋅ 7 comments

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

By Thomas LaRock ⋅ May 5, 2009 ⋅ 8 comments

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

By Thomas LaRock ⋅ May 5, 2009 ⋅ Post a comment

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

« Previous —

My Book