SQLLawman

Family man and SQL Geek

Today's PSA

By MichaelDeputy, 1 year and 1 month ago

According to the American Red Cross here are 10 facts about the need for blood donation.

Keep reading →

Pay a Compliment

By MichaelDeputy, 1 year and 3 months ago


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 →

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 →

SuperStart

By MichaelDeputy, 1 year and 6 months ago

Today was the end of an excellent conference for 4th, 5th, & 6th graders.  SuperStart is a production of CIY.  If you have a child in that age group and you have the opportunity to go, it is so worth your time.   If your church is hosting the conference it is a total blast to volunteer.  Our day started at 6:30 am at Meijer to pick up 66 dozen donuts, yes, that is 792 donuts to pump into kids to get the day started.   Believe it or not, all the donuts actually made it to the church.  There were over 1300 kids and leaders preregistered for the conference.   Then we helped get the breakfast line setup, then it was off to fun.  My wife and I ran the «arcade» room.  That consisted of 7 Wiis and a Xbox360.  All of these were connected to projectors and projected up on the walls.    Our job was to let the kids have fun.  With that hardware, failure was not an option.  We rotated every 4 to 5 minutes to get everyone a chance to play.  There was also three inflatable obstacle courses.  I snuck in there and raced our middle school pastor through one of the courses.  He won.  But I'm sure I get a re-match in the future.  Then the kids went onto the program.  It had incredible praise and worship by Yancy and a three session program focusing on being friends all wrapped around a competition by two illusionists to see who was best.  The kids voted by means of a decibel meter.  112 db of screaming pre-teens was the winning score.  It was incredible.  The CIY team were awesome people, very organized, very competent, and connected instantly with the kids.  I would never spoil the outcome, but these illusionists were quite good.  I really enjoyed their competition.  One of the parts of the day is called plug and play.  During this time, our church rented out a local skating rink and we all went skating.  We had a great time and my kids are getting better at skating.  In conclusion,  SuperStart was excellent and my kids can't wait for next year.  So if you have kids that age and have the opportunity, it is well worth the small fee (less than $50.00 for the conference)

Keep reading →

20 Week Challenge

By MichaelDeputy, 1 year and 7 months ago

I had plopped onto my recliner over the weekend and looked around at my family.  I noticed that there seemed to be more of us than I had remembered.  Since the summer/fall ended we had begun become sedentary.  A family that swam, biked, and ran all summer and fall, were turning into couch blobs.  I wondered to the bathroom and stepped on the scale, yep, 15 lbs since my Hawaii trip.  So I came up with a challenge.  What I proposed was a 20 week challenge.  Here's the challenge:  On the first week, everyone will do at least 5 minutes of aerobic activity every day Monday through Saturday.  During the second week, the time increased by 6 minutes each day.  The third week, 7 minutes and so on.  The payoff?  If all four of us can perform this 80% of the time over the 20 weeks, I will take the family to Great Wolf Lodge for a weekend.  (interestingly enough, 20 weeks is about the end of the school year.)  Today was day one.

Keep reading →

The joys of home ownership

By MichaelDeputy, 1 year and 8 months ago

I was trying to be the good homeowner.  It had been six months it was time to flush the water heater.  The process was going flawlessly until I was starting to re-light the heater.  I noticed a drip, drip, drip.  There is nothing good that can come from that.  I started to investigate.  The shutoff valve to the heater input was dripping.  I guess I was stronger than I though when I shut off the water.  Then I realized I have lived in the house for 10 years and I didn't know where the main water shutoff was located.  So I had to investigate.  I followed the pipes to quickly find the shutoff.  Once I had the water shut off, I took the broken valve apart and a few inches of telfon tape later, the drip stopped.  The water is heating up and I lived to blog about it.

Keep reading →

Miami Dolphins

By MichaelDeputy, 1 year and 8 months ago

Dolphins win the AFC East. From last to first in one season!!!!
Congratulations Dolphins.


Keep reading →

16 things about Michael Deputy

By MichaelDeputy, 1 year and 8 months ago

I was reading a post by T.J. Belt where he listed 16 things about him.  It was quite interesting.  He has had quite an interesting life.  So here are my 16

Keep reading →

Dog Stories

By MichaelDeputy, 1 year and 8 months ago

Along with our two dogs, we are dog sitting for my brother-in-law as his family is out of the state.  Shipley, their German Shepard is a really good dog.  It has been fun watcing the dynamics of the dogs.  My dog Zoe, American Staffordshire Terrior mix, has assumed the role as alpha female.  This gives her the unique opportunity to be left out when the two shepards play.  But since she is fairly lazy, that doesn't bother her too much.  Right now they are all lying down surrounding me.  It's pretty peaceful in the house right now.  My shepard/akita mix, Belle, is lying beside me asking for attention.  That does make blogging a bit more difficult.  My wife and kids are watching  «Journey to the Center of the Earth» with Brandon Frazier again.  Yes, you can guess why my wife is watching it.

Keep reading →