Posted on Leave a comment

Calling SQL gurus – Is there a way to programmaticly prove data accuracy?

Say I have an existing MS SQL database with many tables. Now I’m going to import many more records. From a quality assurance standpoint, I’d like to be able to confirm that the existing data prior to the import was not inadvertently altered during the import of the new data (since the import includes some manipulation of the new data).

Is there a magical way to do this. I’m stuck on comparing record counts but that does really tell me if the existing data was altered during the import process.

Conceptually, I’d like to be able to essentially do something like a hash of the complete dataset before the import. Then after the import, query for all the old records, rehash and compare the two hashes.

Thoughts?

Posted on 1 Comment

No monsters in the shower

Dear Family,
I am aware that some of you are afraid there are monsters hiding in the shower so you leave the shower curtain open. I would prefer it closed. The benefits of closing the shower curtain after your bath or shower are that the curtain is less likely to mildew plus you can read that cool periodic table of elements. I believe I have a solution! I have mounted a video camera in the shower. Simply point your browser to 192.267.0.389:null and you can see that there are no monsters in the shower.
That is all. And thank you for your cooperation!
Love, Dad

Posted on Leave a comment

Are you real?

My answer to Scott Jordan’s question "So, how close are you to your online persona?" (see also Facebook):

I’ve always said that the online persona is but a keyhole view of the real person’s life. That said, I am who I am. I tell my children not to lie because it is difficult to live to lives (the truth, and the lie which must co-exist). As such, what I post reflects me. As a humorist, that is not to say I do not embellish or intentionally provocative. In the real world, I might be a little less open with my opinions (particularly in business circumstances in this Biblebelt southern town). I’ve seen many a social climber in real life put on facades. In wealthy Germantown, TN, there were elegant homes with manicured lawns with no furniture inside because the home owners were mortgaged to the hilt for impressions. I won’t live that way in the real or virtual world.

I am who I am. And I hope that is agreeable to most.

I implore those who disagree with my opinions online, or take a distaste to me online, to meet me in person to see if they see the real world (IRL) person differently. We can disagree on politics, religion, lifestyle, and many other things, and still like each other.

I have few filters online. You know me.

I wrote this About Me many years ago and it seems to have stood the test of time: http://realityme.net/about/why-i-blog/
I also wrote an excerpt for my employers: http://realityme.net/employers-pls-read/

[Source, Google+, Scott Jordan]

Posted on Leave a comment

Range Anxiety? No.

I woke this morning to see our electric car (ev) parked in front of the house. That means it wasn’t charged overnight. My initial response was panic. No way will we have enough juice to go anywhere today. Oh well, I decide to simply get it plugged in. While parking it I look down to see that we have more than enough range even without charging to have a very full day.

Posted on Leave a comment

I live in your future

I am living in the future. The future is now. Most people are living in the past. Those who use words such as "glasshole" simply are adverse to change or do not have the vision to see that we will all be using such technologies soon or be relegated to the non-trainable generation often associated with grandparents. I used text messaging aggressively before it was vogue. My family organized our lives and social schedules with T9 SMS while those around me decried "put your phone down." Little did they know how active and involved my life was because of those texts. Today those same people we see typing away endlessly and making fewer phone calls. Five years before it took off, I begged for using technology, such as iPads, as learning tools in our schools. People shunned my suggestions stating, "that will never happen." Now politicians are running on platforms based on getting tablet computers into every students’ hands.

There are many futures I have missed either from lack of skills, such as mechanical engineering, lack of money, or lack of time. For instance, I’ve missed the 3-D printing revolution. I’ll be a participant but as one who lived in the past. 3-D printers have come. Commonplace 3-D printers, like our now disposable inkjet printers, will soon be in everyone’s homes.

I am participating in one of your futures. I very much participate in the Internet of Things which connects our physical world to the virtual world. Today I installed a Nest Protect which is a smoke and carbon monoxide detector far more sophisticated, yet kept incredibly simple, than traditional smoke alarms. The Nest Protect speaks in addition to its alarm so if you have several in the house, they all go off via wireless interconnection and speak the problem location, "smoke detected in the hallway" or "carbon monoxide danger in the den." The Nest Protect has motion detection so it turns on a night light when someone moves under it. This motion detector talks to our Nest Learning Thermostat so that the thermostat can automagically adjust the temperature in the house based on whether or not people are home. Both the Nest Protect and Nest Thermostat are connected via the Internet to my cell phone so that I can set the temperature of the house while I’m anywhere in the world, I can know the home is safe, and I know when there is activity in the house.

Another one of your futures that I am participating in is the Quantified Self. I use the accelerometers, gyroscopes, magnetometers, GPS and other sensors in my various devices to track myself. Those living the past reactive with "creepy" and "loss of privacy" but I am enhanced. The quantified self has memory beyond the fallible human mind. My applications tell me exactly where I was and when. I never have to ponder, "what was I doing last Thursday?" My health is improved because I am aware via the tracking of my self. Loss of privacy? Not really but that’s a different post. Join me in your future! It’s a neat place.