If you are not one of the few lucky folks who scored a ticket to SQL Inspire this weekend (where I will be giving my talk that I have simply named “SQL Someday”) and you are looking for something to do this weekend with all your spare time, I have a suggestion for you: go [...]
SQL 2008
Why You Can’t Trust sysdepends
One thing I learned early on in my former life as a production DBA was the old motto “trust but verify”. Such is the case when it comes to relying on system information in order for your tools to work properly. An example that comes to mind immediately is the use of the sysdepends system [...]
Good Way To Start Your Day
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
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
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
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 [...]