SQLLawman

Family man and SQL Geek

Cleaning up the disk

By MichaelDeputy, 1 year and 5 months ago

When I became our companies MSSQL DBA I inherited an smooth running machine.  My predecessors were extremely talented and their scripts did everything we needed done.  But I can't just live off their hard work, I need to leave my mark on the environment.  So I am tweaking some of their scripts to get rid of what annoys me.  The current task is old backup files.  The scripts they wrote do this awesome thing that archives a backup if the archive bit has not been cleared.  This is so cool.  If NetBackup has a problem, the old backup file that hasn't gone to tape/disk is moved to an archive folder and then the new backup file is created.  But what happens when after the file is backed up and the archive bit is cleared.  It just sits on the disk and is backed up again with every full backup that occurs.  That makes the backups bigger and take longer.  So I added a job that deletes all *.bak files that have their archive bit cleared.  That was so much easier than I expected it to be.

Keep reading →

Blog Direction

By MichaelDeputy, 1 year and 5 months ago

I was looking over my blog and I noticed that it was heading in a direction I didn't like.  I had stared down the path of a whiney, ranting, complaining, negative blog that way too many blogs have gone.  So I am stopping it now.  I need to get more SQL and positive posts to offset some of the negative I am seeing in the blog world.  So here is the positive for today.  I am going to focus on the positive of the «special needs» part of my world.  My eleven year old daughter was born with Down Syndrome and congenital heart defects.  At eleven months she had open heart surgery to repair those holes.  At seven years old she was diagnosed with leukemia and fought to beat that beast for two and a half years.  To put it plainly, she is a fighter.  That is the background for her newest endeavor.  She recently began theraputic riding at a local stable, and her instructor was so impressed with her abilities that she promoted her to horse riding lessons and has now begun to ride full sized horses without side walker assitance.  She also joined 4-H and is working on halter class for this years county fair.  She will be competing against typically developing kids in this class, and that's the way she like it.  So her battle for inclusion continues as she continues to impress and break stereotypes.  She may be «special needs» but if you are competing against her in anything, don't take her lightly, or she will take you.  Perhaps I'll tell you about her Karate touranment last year some time.  Inclusion does work, her life is proof.