Monthly Archives: May 2011

Identity Reseeding

Posted on May 31, 2011 by

I love the identity property. I use it in many of my tables, mostly because it gives me a fairly reliable surrogate key that I can use in my tables, especially when testing something. I often do something like this: … Continue reading →

Posted in Blog | Tagged ,

The Ad Hoc Change

Posted on May 31, 2011 by

How many times have you been asked to change data in a production system? If your career has been like mine, it’s probably too many times to count. It seems that there are always data issues in production, and the … Continue reading →

Posted in Editorial | Tagged

Better Writing from Hemingway

Posted on May 30, 2011 by

These are five rules for writing from Ernest Hemingway, which I like and recommend for use in your communications. Definitely try to incorporate them into your writing, especially being short and positive. (Cross posted from The Modern Resume)

Posted in Blog | Tagged ,

More Bloopers for Memorial Day

Posted on May 30, 2011 by

It’s Memorial Day, and as usual, I have a blooper reel for the editorial. However I couldn’t fit everything in there, so I’ve pulled out a few more items. Mostly body mistakes or movements and some speaking issues. Enjoy! The … Continue reading →

Posted in Blog | Tagged ,

The Backup Passwords

Posted on May 26, 2011 by

One of the things that my boss was excited to implement a few years back were passwords for our backups. Actually we were using a third party backup utility, like SQL Backup, for our SQL Server instances. We purchased the tool … Continue reading →

Posted in Editorial | Tagged

Greed Is Good (for IT)

Posted on May 26, 2011 by

I think that the lottery mentality that so many executives of companies have these days is bad for business. The idea that someone can be promoted from a director or vice president to CEO and then earn enough money in … Continue reading →

Posted in Editorial | Tagged

No Shrink-y Tempdb

Posted on May 26, 2011 by

I caught the end of a Twitter conversation the other day between Wes Brown (Blog | @WesBrownSQL), Paul Randal (blog | @PaulRandal), and Aaron Bertrand (blog | @aaronbertrand) talking about shrinking tempdb and the potential issues. I’ve never thought about … Continue reading →

Posted in Blog | Tagged , | 1 Comment

The Exceptional DBA for 2011

Posted on May 25, 2011 by

Once again we’re running a contest to find the Exceptional DBA around the globe. I’ve been a judge the last three years, and it’s been a hard choice trying to pick from some great applications. This year the judges are … Continue reading →

Posted in Blog | Tagged , ,

Treat People Like People

Posted on May 25, 2011 by

Millennials, the next generation of college graduates are coming out of school and looking for work. These are people who have grown up with technology all of their lives, and probably can’t imagine living without a computer, much less Internet … Continue reading →

Posted in Editorial | Tagged

Fun with Light Bulbs

Posted on May 24, 2011 by

I needed an image of a “great idea”, and decided to use a light bulb. I started looking through Flickr and then realized I could just as easily do my own picture. So I enlisted Kendall for this series of … Continue reading →

Posted in Blog | Tagged , ,