Category: Uncategorized

The more I think about this, the more I think it should be built into SQL Server as a default. Why not ask for the information to create an operator and email at install and then create a few nice default alerts, like one for which log is full.

It’s such a common problem, why not get people to enable DBMail and enter their email address during installation? For the people that really need to lock down their servers, they could skip it, but for the average person, it might save some headaches if they knew when their log was 80% full.

If you want the general steps for creating an alert, it’s on MSDN.

I started watching Leverage this season, after it was recommended by Wil Wheaton (blog/twitter). For those of you that don’t know Wil, he is an actor and writer, best known by me for playing Wesley Crusher on Star Trek: The Next Generation. I had been working my way through Seasons 1, 2, and 3 while running this year and started following him on Twitter.

He talked a bunch about Leverage over the summer, where he was a guest in one of the episodes. I was hoping he’d be in more, but his excitement while shooting the show got me to tune in, and I’m hooked. I record it every week on my TiVo and bought the first season so I could watch it while running.

What does this have to do with Vegas?

Nothing really, but the characters on Leverage are thieves, and con artists, and it entertains me. So when looking for some new books to read, I plugged in "grifters" and "con artists" in Amazon and came up with a few by James Swain.

He has a series of novels starring Tony Valentine, who tries to catch those people that a ripping off casinos. There’s the Vegas tie-in 🙂

I’ve read a couple of them, Mr. Lucky and Grift Sense, and am working on the third. I’m not much of a gambler, but I enjoy reading about it and sleight of hand entertains me immensely.

That’s my preparation for Vegas, and SQL Connections. That, and picking out a few sessions to attend.

I noticed that the keys on my laptop were pretty dirty the other day. The heavily used ones have a nice brown stain in places, mostly from just skin oils, and normally I don’t notice them, but it bugged me one afternoon, so I wanted to clean them.

How do I do it? I haven’t ever really worried about it, not traveling as much with laptops as I have with this one, and not using them as much as I have in the last year with this one. It gets used almost every day, moves from the basement to the bedroom, and I wanted to be clean it up.

So I asked my Twitter community the question and got these suggestions:

• qtips and rubbing alcohol do a nice job of getting in between keys’ (@SQLDBA)
• Baby Wipes.  (@RossMistry)
• Turn it off. Turn upside down. Beat vigorously with broom. Turn back over. Wipe down with very wet cloth. Let dry. Turn on; use! (@ChristyLeonard)
• distilled water and a tooth brush. Then let it dry for a day or two before reusing.  Or chuck it and get a new one. (@MrDenny)

I decided to try a few things and document it so hopefully someone else has an easier time. Here’s a before picture, so you can see how things look.

(ignore the date, I didn’t set the date on my camera)

I then started with baby wipes. We keep a few around since they are handy to clean up, or wipe off kids’ skin even at 8 years old! I turned off the machine and lightly wiped a few of the keys. As you can see, it seemed to clean off the keys pretty well. It didn’t take much elbow grease, just a couple minutes of rubbing across them.

My next experiment was to try rubbing alcohol and Q-tips. A quick search of the bathroom netted me some supplies, and I started on the other keys. Here’s the before:

and the after

I think that this worked as well as baby wipes, but it was definitely more effort. After a few minutes the colors was back to white, and the keys felt fine. The alcohol evaporated, and even the smell was gone quickly.

I declined to try Christy Leonard’s solution of using the broom, and I cleaned up the keys enough to not worry about the distilled water and toothbrush. I’ll let someone else try those.

My suggestion if your keyboard is dirty? Use baby wipes. You can pick up a small travel pack cheap, and almost anywhere. You can throw them in your laptop bag, but unless they’re sealed well, they will dry out quickly.

Business conventions are important because they demonstrate how many people a company can operate without.

Since I got to so many, perhaps I’m not that valuable?