This is the second post in a series on Upgrading to SQL Server 2012. Tips, tricks, hazards, pitfalls, and real world experiences. Your Upgrade Strategy A big part of the upgrade strategy should be how we do it. There are three basic approaches to the problem. There is no right answer, as it depends
The next 2 months are looking to be very busy for me. On April 12th, I will travel to Columbus to present to the Columbus CBusPASS chapter on Upgrading Server Server to 2012. I was in Columbus for the SQL Server Special Ops tour and the CbusPASS folks are great people and I’m happy to
The SQL Server 2012 Upgrade Advisor has a poorly undocumented prerequisite. If you go and try and install the Upgrade Advisor off of the SQL Server 2012 RTM media, you will get the following error: The installer is looking for the SQL Server 2012 Transact-SQL ScriptDom component which is found as part of the SQL
I attended the Special Ops Tour (AKA the SQL Server 2012 Launch Event) in Columbus earlier this week. I was really looking forward to the event. The Columbus user group (CBusPASS) partially hosted the event. I got there a little early so I could help out setting up but there wasn’t really anything to do.
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