2009 August | SQLRockstar

PASS Is For Everyone

By Thomas LaRock ⋅ August 30, 2009 ⋅ 3 comments

Last week I received an email from @wnylibrarian:
Hi Thomas,
I’ve been thinking about registering with PASS, but I just feel slightly uneasy doing so because I’m what you would refer to as an “accidental” DBA. I hold no certifications, but have a Master’s Degree in Library Science. I worry sometimes about what I can contribute. My [...]

What Time Is It?

By Thomas LaRock ⋅ August 28, 2009 ⋅ 7 comments

Joe the DBA sent me the usually morning email, detailing the failed custom collections in Operations Manager. I had asked for Joe to do this routinely so that we could monitor our monitoring system, as any good DBA with OCD would do. With our recent push for server consolidation I have been spending more time [...]

PASS Board of Directors Nominations

By Thomas LaRock ⋅ August 26, 2009 ⋅ 18 comments

The PASS call for nominations to the Board of Directors will be ending soon at noon PT, September 3rd. If you have not yet taken the time to fill out your application, do not wait until the last minute. If you are looking for someone to make you feel loved, then this is the blog [...]

User Resynch

By Thomas LaRock ⋅ August 21, 2009 ⋅ 11 comments

Quick question for everyone this week: how do you resynch your users after a database restore?
For same server restores you do not have this issue, but when restoring from prod to test, for example, you will find that the sid’s do not match and thus you either need to resynch the users or to drop/add.
Our [...]

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

24 Hours of SQLRockstar

By Thomas LaRock ⋅ August 16, 2009 ⋅ 6 comments

Have you heard about the upcoming FREE training event sponsored by PASS? Have you been wondering how you could register? Have you been thinking “maybe I will wait and see what sessions they have lined up before I decide to register?” Have you also been sitting there and wondering “how can I get more of [...]

Once Was Not Enough

By Thomas LaRock ⋅ August 14, 2009 ⋅ 8 comments

PASS has sent out the call for nominations as part of the election process for the Board of Directors. I was notified through some members of the community yesterday about the announcement. I then took some time contemplating what I wanted to do: should I run again? If so, why? I mean, the bacon at [...]

More About Me

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

As if having a blog wasn’t enough self promotion, I have even more to offer.
I recently sat down with Christian Hasker (@chasker) of Quest Software as part of a “Meet the Experts” series of interviews. Since the expert they had scheduled failed to appear they asked if I would like to sit down and talk [...]