Upgrading To SQL 2012: Ten Things You Don’t Want To Miss
Many novice administrators make the common mistake of believing that the SQL Server upgrade process for a database server is as easy as pressing a few buttons.
upgrade
7 Mistakes You Can’t Afford To Make When Upgrading to SQL 2012
It’s new, it’s shiny, and it smells like frozen yogurt. No, it’s not the blender you got for Christmas. It’s SQL 2012 (formerly known as codename ‘Denali’). And it’s here. And you want to use it, you know you do. As much as you would like to believe that migrating to SQL 2012 is as … Read more
Refresh Your Views With sp_refreshview
With SQL Server 2008 R2 having been released it seems like a good time to remind people about the sp_refreshview system stored procedure. How are those two things related? Great question. When migrating or upgrading to newer versions (such as R2), you need to be aware that a simple restore is not always enough. First, … Read more
