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
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
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
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 [...]
Policy Based Management Tip at MSSQLTips
I had another tip go live over at MSSQLTips today, this one involves the use of Policy Based Management to verify that your backup files are still available on disk. I had recently published a similar tip that was just a script that used the undocumented stored procedure xp_fileexist to achieve the same goal. I [...]
Reattach Will Reset Database Chaining
We came across this little nugget the other day. There is a vendor application that likes to create databases on the same drive and override the default file locations we have defined. Yeah, I know, hard to believe yet another vendor product can go out of their way to take a perfectly good server and [...]