Friday, February 13, 2009

Download details: Business Contact Manager Database Admin Tool

A while back I wrote about using Business Contact Manager in office 2007.  A few people in our office wanted to use it and wanted to be able to share their contacts as a workgroup.

Initially, we looked at it using the standard setup where one person basically has the ‘Master’ copy of the database, and the rest just share it.  Since our group is a small group, this looked like a good fit at first, but quickly we realized that if the master guy was out, there were problems sharing data and we lost our major advantage we had gained.

I then found this tool that allows you to create a database on a machine that doesn’t have office 2007 installed.  So I ran it on my file server and it worked perfectly.  Now people connect to the central database and keep in sync at all times.

The only thing is, that the database needs to be backed up properly.  I created this script and set it to run through the scheduler:

backup.cmd

   1: @echo off


   2:  


   3: set SQLCMD="c:\program files\microsoft sql server\90\tools\binn\sqlcmd.exe"


   4: set DBSERVER=MYSERVER


   5: set DBINSTANCE=MSSQLSERVER


   6: set DBPORT=1433


   7: set DBCONNECT=tcp:%DBSERVER%\%DBINSTANCE%,%DBPORT%


   8:  


   9: set DBNAME=%1


  10: set BACKUPPATH=E:\backup\bcm


  11: set BKFILE=%BACKUPPATH%\%DBNAME%.bak


  12: set BKRESULT=%BACKUPPATH%\%DBNAME%_BackupResult.txt


  13: set ZIPCMD=e:\software\util\7za.exe a -tzip


  14:  


  15: DEL %BKFILE%.zip


  16:  


  17: %SQLCMD% -E -S %DBCONNECT% -Q"SET NOCOUNT ON; SELECT '%DBNAME% Backup started at - ' + CONVERT(varchar, GETDATE());" > "%BKRESULT%"


  18:  


  19: %SQLCMD% -E -S %DBCONNECT% -Q"BACKUP DATABASE %DBNAME% TO  DISK = N'%BKFILE%' WITH FORMAT, INIT,  NAME = N'Full Database Backup', SKIP, STATS = 10" >> "%BKRESULT%"


  20:  


  21: %SQLCMD% -E -S %DBCONNECT% -Q"SET NOCOUNT ON; SELECT 'Backup completed at - ' + CONVERT(varchar, GETDATE());" >> "%BKRESULT%"


  22:  


  23: %ZIPCMD% %BKFILE%.zip %BKFILE% >> "%BKRESULT%"


  24:  


  25: DEL %BKFILE% >> "%BKRESULT%"


Tuesday, February 10, 2009

ONLY A foolish MAN WOULD ATTEMPT THIS

My wife forwarded this to me last night…Just try reading this without laughing till you cry!!!

Pocket Tazer Stun Gun, a great gift for the wife. A guy who  ScreenShotpurchased his lovely wife a pocket Tazer for their anniversary submitted this:

Last weekend I saw something at Larry's Pistol & Pawn Shop that sparked my interest. The occasion was our 15th anniversary and I was looking for a little somethin g extra for my wife Julie. What I came across was a 100,000-volt, pocket/purse- sized tazer. The effects of the tazer were supposed to be short lived, with no long-term adverse affect on your assailant, allowing her adequate time to retreat to safety....??

WAY TOO COOL! Long story short, I bought the device and brought it home. I loaded two AAA batteries in the darn thing and pushed the button. Nothing! I was disappointed. I learned, however, that if I pushed the button and pressed it against a metal surface at the same time; I'd get the blue arc of electricity darting back and forth between the prongs.

AWESOME!!!

Unfortunately, I have yet to explain to Julie what that burn spot is on the face of her microwave.

Okay, so I was home alone with this new toy, thinking to myself that it couldn't be all that bad with only two triple-A batteries, right? There I sat in my recliner, my cat Gracie looking on intently (trusting little soul) while I was reading the directions and thinking that I really needed to try this thing out on a flesh & blood moving target. I must admit I thought about zapping Gracie (for a fraction of a second) and thought better of it. She is such a sweet cat. But, if I was going to give this thing to my wife to protect herself against a mugger, I did want some assurance that it would work as advertised. Am I wrong?

So, there I sat in a pair of shorts and a tank top with my reading glasses perched delicately y on the bridge of my nose, directions in one hand, and tazer in another. The directions said that a one-second burst would shock and disorient your assailant; a two-second burst was supposed to cause muscle spasms and a major loss of bodily control; a three-second burst would purportedly make your assailant flop on the ground like a fish out of water.

Any burst longer than three seconds would be wasting the batteries.

All the while I'm looking at this little device measuring about 5" long, less than 3/4 inch in circumference; pretty cute really and (loaded with two itsy, bitsy triple-A batteries) thinking to myself, 'no possible way!' What happened next is almost beyond description, but I'll do my best.. .?

I'm sitting there alone, Gracie looking on with her head cocked to one side as to say, 'don't do it dipshit,' reasoning that a one second burst from such a tiny little ole thing couldn't hurt all that bad. I decided to give myself a one second burst just for heck of it. I touched the prongs to my naked thigh, pushed the button, and . .

HOLY MOTHER OF GOD . . WEAPONS OF MASS DESTRUCTION . . . WHAT THE HELL!!!

I'm pretty sure Jessie Ventura ran in through the side door, picked me up in the recliner, then body slammed us both on the carpet, over and over and over again. I vaguely recall waking up on my side in the fetal position, with tears in my eyes, body soaking wet, both nipples on fire, testicles nowhere to be found, with my left arm tucked under my body in the oddest position, and tingling in my legs? The cat was making meowing sounds I had never heard before, clinging to a picture frame hanging above the fireplace, obviously in an attempt to avoid getting slammed by my body flopping all over the living room.

Note: If you ever feel compelled to 'mug' yourself with a tazer, one note of caution: there is no such thing as a one second burst when you zap yourself! You will not let go of that thing until it is dislodged from your hand by a violent thrashing about on the floor.. A three second bu rst would be considered conservative?

IT HURT LIKE HELL!!!

A minute or so later (I can't be sure, as time was a relative thing at that point), I collected my wits (what little I had left), sat up and surveyed the landscape. My bent reading glasses were on the mantel of the fireplace. The recliner was upside down and about 8 feet or so from where it originally was. My triceps, right thigh and both nipples were still twitching. My face felt like it had been shot up with Novocain, and my bottom lip weighed 88 lbs. I had no control over the drooling.

Apparently I pooped on myself, but was too numb to know for sure and my sense of smell was gone. I saw a faint smoke cloud above my head which I believe came from my hair. I'm still looking for my nuts and I'm offering a significant reward for their safe return!

P.s... My wife, can't stop laughing about my experience, loved the gift, and now regularly threatens me with it!

If you think education is difficult, try being stupid !!!

Thursday, February 5, 2009

Google Latitude: Tell Your Friends Where You Are - BusinessWeek

Can you imagine a service that would keep tabs on you by hooking into the GPS on your cellphone and showing the world where you are right now.  Not only that, but someone could keep tabs on everyone they know this way that had the service set up.

What a crazy thing to do…

Google Latitude: Tell Your Friends Where You Are - BusinessWeek

Sunday, February 1, 2009

Please spare me…

This message is for any Canadian parent who has the audacity to think that it is their right to teach their children to be ashamed of their country because the anthem does not conform to their own ideals (or lack thereof)…

I have never been more offended than when I read this article in the globe and mail about how a school in New Brunswick has effectively banned the playing of our national anthem because the phrase “God keep our land” is not inclusive of the entire class.  Spare me your self-righteous indignation…

I remember back in the early 80’s while I was in Junior high school, our school band did a sort of exchange trip with the junior high school in Bellisle outside Saint John.  At the time it was to me like the ‘town at the end of the highway’ with perhaps a little corner store and a gas station and not much else.  God only knows what kind of place it has become, but from the sounds of this, if the folks in that area don’t stand up and be proud of their country, it isn’t a place I would want to return to.

I’m sorry, I like to think of myself as tolerant, but this crosses a line for me.  If you don’t like the anthem, get the heck out of the country…I’m disgusted that these parents and this school administrator have kowtowed to some over-zealous, unpatriotic, special interest group that could not possibly represent the views of the people of this country.

The principal needs a backbone and stand up to this kind of pressure.  I’d be happy to give a civics lesson to any one of these people.