Author Archives: jrothmanshore

Performance: Alter a table’s clustered index in SQL Server while keeping the table online

Back in the old SQL Server 2000 days, creating an index was a major operation that would prevent queries and data modifications until it had completed. Unless the index could be created in a few seconds, any new indexes had … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

Join.me – free desktop sharing so easy, even my mom can do it

Okay, that’s a little unfair to my mom, since she is a relatively tech savvy person who sports an iPhone and uses a gmail account. But the point is, the people at Join.me (the same people behind LogMeIn) have done … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Mourning the loss of my Italian coffee maker, but not for its coffee

It’s been four months since my Italian coffee maker died, and today I have finally come to the hard decision that it is time to move on and buy a new one. I’m not very particular about the coffee itself. … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Egypt proves Malcolm Gladwell was wrong about social media… and right

In October 2010, Malcolm Gladwell published an article in the New Yorker entitled “Small Change: Why the revolution will not be tweeted“.  In the article, he rejects the idea that social networking tools like Twitter and Facebook will be agents … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

I’ve written over 1000 tweets in the last 15 months. How much time have I wasted?

I started experimenting with Twitter (and social networking in general) 15 months ago, and just this week, I sent my 1000th tweet.  It seems like a good time to take a step back and ask whether this is a good … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Skip the line at the rental car desk and use the self-service kiosk

We recently took a trip out to California for a family event, which meant a cross-country flight with a six month-old-baby and an almost three-year-old.  After surviving the flight with only one melt down, we made it off the plane, … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

Kick off a Cygwin script from a windows bat file with a different working directory

I recently created a script that would pull the Tomcat log files from a group of web servers and then run my 95th percentile awk script to generate a summary of response times for the 100 most popular pages.  I … Continue reading

Posted in Uncategorized | Tagged , , , | 6 Comments

Performance: Hyper-threading actually does boost server capacity

We recently noticed some odd behavior with one of our servers during a deployment.  Several machines were removed from the traffic pool to receive updates, and during this time, the other machines were shouldering the extra load.  We have significant … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

Silly trick to avoid accidentally sending an email before it’s ready

One of the plot lines in last night’s Modern Family revolved around the repercussions of an email that was sent before it was finished.  This reminded me a trick I use to avoid the problem, so I thought I would … Continue reading

Posted in Uncategorized | Tagged , | 3 Comments

Performance: Query the sqlserver plan cache to find queries that use a particular index

Part of keeping a SQL Server database running smoothly is to keep indexes well tuned. As database schemas or usage change, indexes that were once important may fall out of use. Eliminating unnecessary indexes helps speed up inserts/updates/deletes, and it … Continue reading

Posted in Uncategorized | Tagged , , | 3 Comments