SQLLawman

Family man and SQL Geek

Are All Test Environments Created Equal?

By MichaelDeputy, 1 year and 4 months ago

I don't know about your environment, but at mine we have two classes of systems: Prod and Test.  So as you can guess, anything that is not Prod is Test.  That's a pretty simple definition.  Further defined anything that has a DR priority of 6 or less is PROD and anything 7 or greater (or not graded) is test.  This makes live very simple, or so it would seem.  So that brings me back to my question: Are All test environments created equal?  On the one hand an answer of «yes» lets everyone know what to expect.

Keep reading →

Home PC Backups

By MichaelDeputy, 1 year and 4 months ago

I have been noticing a scary trend over the last few years.  Home computers have gone from a techno-toy (like a DVD player) to an important part of everyone's life.  I have also noticed that computers are becoming 5 year assets.  People are replacing them every 5 years.  Today they are inexpensive enough to do that.  But the trend I am seeing is that the old PC is not being replaced, but a notebook is being added to the home computer.  So I have a lot of family and friends with 4 to 5 year old desktop PCs, and hard drives are beginning to fail.  Since most PCs came in as toys, disaster recovery is typically not considered by the home user.  Does the thought of loosing all you digital pictures, your password database that you are allowing your web browser of choice manage for you, or any document you have created scare you?  It should.  A couple of people have asked me my strategy so here it is.  I use a three pronged approach.  I have a wireless network in my house.  Every night at 2:00 am (wow, now that I think of that it is a really bad time to choose now that Indiana is on daylight saving time) *Note to self reschedule backups*.   I copy my documents folder to another PC that is on different power circuit in a different part of the house.  I also copy that data to a USB connected disk.  Please note, this is not a backup plan.  I cannot step back in time and get an old version of a changed file.  But in most cases I don't need that.  Then once a month, I burn what I feel is most important (pictures, keepass password database, e-mail archive) to DVD and store it off-site.   I point all my applications to store their data in that location.  I am not saying this is the best strategy, but I would like you to at least think about your strategy.  The day after a hard drive crash is not the time to consider this.  Just remember, that e-mail and web surfing appliance is becoming a critical part of your life.  Protect it.

Keep reading →

Renaming a SQL server

By MichaelDeputy, 1 year and 4 months ago

Here's a little simple one that I'll probably need again, so I thought I'd just blog it:

Keep reading →

Cleaning up the disk

By MichaelDeputy, 1 year and 4 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 4 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.

Keep reading →