This is the first post in a series on Upgrading to SQL Server 2012. Tips, tricks, hazards, pitfalls, and real world experiences. Why upgrade? As with any piece of software, we need to weigh the business benefits against the time, effort and cost associated with an upgrade. I believe the most compelling reason to
Thomas LaRock in his Meme Monday series asks us to write about: List out all the little things you do as a DBA, since the term DBA means so many different things in each shop. Here’s my list: Backups/Restores Test Restores – that’s a biggee Troubleshoot performance issues New Technology cheerleader to the masses Poorly
I am honored to be selected by the NTSSUG program committee and PASS to present at SQLRally on May 10-11. I will be speaking on Upgrade Roadmap: Let’s Delve into SQL Server 2012. Basically this is my Upgrade Roadmap – taking you to R2 talk updated for SQL Server 2012. I will be working on
I have been playing around with Ola Hallengren’s Maintenance Solution for some time on our Test and Dev SQL Servers. This week I began deploying it to production. Our previous maintenance solution was a cobbled patchwork of home grown scripts, and some stuff from the Microsoft AIT Automation scripts that badly needed an update. One
My adventure started on Friday when I climbed aboard an AirTran flight from Akron/Canton airport to Orlando. I love flying out of CAK. It’s so friendly and easy. We had a great flight down to Orlando. After landing, I called Chad Miller (Blog | Twitter) who had graciously volunteered to pick me up at MCO.
I’ll be speaking at the IT Pro Camp in Orlando on Saturday January 21, 2012. Hope to see you there. It appears that the event is set up largely like a SQL Saturday, which piqued my curiosity. But it has broader appeal, hence the “IT Pro” moniker. I submitted 2 sessions for the event and
2011 Year recap (or from 0 to SQLSaturday) Looking back, this year has been a pivotal one. I can note that I am not going to review goals hit / missed because I did not have any goals for 2011. I can say that 2011 was the year of the SQL Saturday. Coming into the year,