Search
MSSQL
Cloud Computing Conference
I took part in a one day conference today on cloud computing. It took place at the Harvard Club in Boston, which was an interesting choice to have the event. I had never been to the Harvard Club before, and I enjoyed the history displayed all around me. I did not wear a coat and [...]
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 [...]
Backing Up SSAS Databases
As we get more involved with the BI stack of tools we find ourselves learning some of the nuances of supporting all of these new environments. One such example is SSAS. When people build and deploy cubes to an instance of SSAS they (eventually) get around to asking about restores and recovery. And since the [...]
SQL University Hoops Practice
OK folks, sorry about having to cancel practice last week but we didn’t want to take any chances with the current swine flu pandemic that is sure to be made into a TV movie to be shown during May sweeps next year. I know that many of you had a chance to practice on your [...]
New Tip Over at MSSQLTips
Ever have a customer request that you take a backup of a database, a restore using that backup, and then tell you that it is the wrong data?
Every now and then it happens, so I decided to put together some t-sql to display details on what was done. The script essentially details when the restored was [...]
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 [...]
Policy Based Management Podcast – Part 1
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 [...]
MSSQLTips – Backup History Tip
A few weeks back I was asked how long a backup took for a specific database. I knew the info was in the msdb somewhere so I pieced together a bit of code and then thought to myself “hey, this might be a good thing to share with others at MSSQLTips”. Well, OK, I actually [...]
PASS 2009 Summit Early Bird is Ending!
I have been quite busy the past few weeks. So busy that I completely forgot to blog about this last Friday. Oh well, better late than never.
The early bird discount for the PASS 2009 Community Summit ends this Friday, May 1st. For a complete price breakdown, check out this page. If you (or your boss, [...]
My Book
Categories
