Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: 88 | Views in the last 30 days: 2
 
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...

ARTICLE

Objects, Relationships, Systems, And Processes

What is the difference between an expert DBA and a Master DBA? This piece from William Talada talks ...

Tags
editorial    
upgrading    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones