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

Mini-Me

By Steve Jones,

This editorial was originally published on Nov 21, 2008. It is being re-run as Steve is out of the country.

Andy Warren and I have been business partners for years, first starting this site, and now with JumpStartTV and End to End training. In that time we've built quite a few systems to manage the business and learned some things about software development. One thing we've learned is that we're no better than anyone else and sometimes cut corners in software development to get things done, but that's another story.

As we've built systems, one thing we always discuss is what we have to watch out for, or what problems might occur in the data. For example we use DRI to ensure that we don't have orphaned children and good relations, but we do note things like "what if all the emails don't go?" or "what if this email for xxx notification isn't sent?"

Andy, having embraced Agile development and pre-writing test cases, has often made notes and then written "checks" as we go along that will look for issues. We run those as a series of scheduled jobs with SQL Agent and their sole purpose is to ensure that one (or both) of us is notified of issues so we can handle them.

I have written a few in the past, but never with focus that Andy brought to our companies. So for this Friday's poll I wanted to see if any of you do something similar.

Do you write queries to check things for you?

By this I mean do you build up a series of custom queries or alerts that might look for technical or business issues and alert yourself (or your team)? Are you using SQL Agent or some third party software to do this?

I think it's a great idea and any place that you find something slipping through the cracks, it is probably time to write a new check and schedule it to run regularly. For Andy and I (and our other partner Brian), we're busy, we have other jobs, and we can't act as dedicated system administrator or DBA. Writing these checks is a way to leverage the SQL Server platform to do our work for us.

Kind of like a "mini-me" to help out.

Steve Jones


The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are now available at sqlservercentral.mevio.com to get better bandwidth and maybe a little more exposure :). Comments are definitely appreciated and wanted, and you can get feeds from there.

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

Podcasting

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

ARTICLE

Podcast Announcements

Podcast Feeds

BLOG

The Quickest Podcast in the Business

I almost forgot to record the podcast for tomorrow's editorial. In case you're a glutton for punishm...

BLOG

Podcast Upgrades

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

FORUM

T-SQL Development Standards

Writing corporate development standards

Tags
administration    
editorial    
monitoring    
 
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