Monthly Archives: May 2011

Identity Reseeding

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

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

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

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

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)

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

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

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

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

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 , ,