Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Moving Day

By Steve Jones,

You have completed your testing, you’ve got the new hardware setup, the software is installed, a checklist by your side and a full pot of coffee. The big day is here and it's time to migrate to that new SQL Server instance. It's exciting, and terrifying, all at the same time. Something could go wrong, but you've tested the upgrade and are confident that things will go smoothly.

But did you clean house? In other words, while getting ready for this upgrade, planning, testing, and preparing, did you re-examine your system to see if there were objects, users, jobs, or something else in your database server that is old, obsolete, and ready for retirement? Did you look for things to delete while you were getting ready to make everything else better?

It seems that often people in technology are willing to rebuild or migrate systems, add enhancements, or even re-architect systems to make them better, but we rarely want to remove anything old. We don't look to disable, or delete, old logins, jobs, or code on the off chance that it might be used again someday. That's something I've done in the past, not deleting old objects, and it has resulted in some complex systems that eventually become almost un-maintainable because of all the extra "stuff" that is left on the system.

It's funny because lots of IT workers I know are driven to keep things orderly. They don’t want any extra logins, jobs, of even objects in their databases. I know a few that clean up their systems regularly, but most don't.

I think this would be a great place for a series of enhancements in SQL Server. Allow us to mark an object as "deprecated" ourselves, and set a default time after which it could be removed. Even give us a "deprecated objects" backup, and an audit log. Now that would be handy.

Steve Jones


The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are available at sqlservercentral.mevio.com. Comments are definitely appreciated and wanted, and you can get feeds from there.

You can also follow Steve Jones on Twitter:

Overall RSS Feed: or now on iTunes!

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

 
Total article views: 91 | Views in the last 30 days: 1
 
Related Articles
ARTICLE

Podcast Announcements

Podcast Feeds

FORUM

Podcast Problem

Podcast Problem Blocked by group policy

BLOG

Podcasting

A new video setup is on the way!!!! Actually I'll do a couple podcasts on podcasting over the hol...

BLOG

SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio

By default, SQL Server system objects are listed in Object Explorer in Management Studio. These syst...

BLOG

SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio

By default, SQL Server system objects are listed in Object Explorer in Management Studio. These syst...

Tags
editorial    
upgrading    
 
Contribute