Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Maintenance Poll

By Steve Jones,

Part of working in Information Technology is working during off hours. In one company we had a standing maintenance window every Friday night. It was annoying for the family, but it did build a nice bond among the production staff during our many Friday night dinners together. Another company allowed maintenance only from midnight Saturday to 6am Sunday, once a quarter. Those restrictions, while annoying, certainly taught us to prepare and test everything in advance.

The systems we build and support are often in use during the business day by our companies and clients. That usually means that patches or changes to the applications take place in off hours, and that means the IT staff is used to working at night and on weekends to make changes. This Friday I'm wondering what that means for the SQL Server community.

What type of maintenance windows do you typically operate under?

Do you have regular maintenance scheduled? When you patch systems or make changes, how does that impact your schedule during the week? Do you get any comp time or flexible scheduling to accommodate patches?

It's interesting right now with SQLServeCentral. Since most of the staff at Red Gate operates on GMT and most of the audience is in one of the US timezones, it's preferable for changes to the systems to be made early in the morning in Cambridge. An 9-10am change window occurs at 4am EST/1am PST, and a relatively small amount of our audience is affected. These changes also mean that there are plenty of people in the office to respond if there are issues.

In most companies I've worked in, we had limited change windows, and restrictions at different times of the year, but overall we had regular maintenance scheduled and available to allow us to maintain our systems and allow staff to plan for work during off-hours, with some type of flexible time for employees stuck working after hours. Let us know today if that's the case at your job.

Steve Jones


The Voice of the DBA Podcasts

We publish three versions of the podcast each day for you to enjoy.

Everyday Jones

The podcast feeds are available at sqlservercentral.mevio.com. You can also follow Steve Jones on Twitter:

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. They have a great version of Message in a Bottle if you want to check it out.

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: 120 | Views in the last 30 days: 2
 
Related Articles
BLOG

The Podcast is in the Windows Store

If you’ve got a Windows Phone, or any of the Windows devices that support podcasts, the Voice of the...

BLOG

Podcast Upgrades

A minor change for the podcasts next week. I got my wireless microphone, and I'm working with it a b...

BLOG

Podcasting

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

FORUM

Podcast Problem

Podcast Problem Blocked by group policy

ARTICLE

Podcast Announcements

Podcast Feeds

Tags
editorial    
friday poll    
 
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