SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

Archives: May 2008

Kindle Part 2

Or maybe part 3, depending.

 Amazon reduced the cost of the Kindle yesterday. It's $40 off, a 10% discount, down to $359 from $399 and that's tempting. I've got some Amazon credits, about $100, and since I could conceivably deduct this as a business expense, review it for the site,… Read more

0 comments, 1,679 reads

Posted in The Voice of the DBA on 28 May 2008

Backups of Backups

After being gone for 4 days, I've got a little catching up to do. I try to be prepared before I leave, but I also like to be ahead of the curve, especially with the daily grind of articles, QODs, scripts, and of course, editorials.

 I took my video laptop… Read more

0 comments, 1,494 reads

Posted in The Voice of the DBA on 27 May 2008

Collation Issues

 This is really interesting to me:


 CREATE TABLE #TEMP (name varchar(80))
  INSERT INTO #TEMP values ('Malteser Schloßschule')
  INSERT INTO #TEMP values ('Malteser Schlossschule')
  CREATE TABLE #TEMP1 (name nvarchar(160))
  INSERT INTO #TEMP1 values ('Malteser Schloßschule')
  INSERT INTO #TEMP1 values ('Malteser Schlossschule')

Read more

0 comments, 708 reads

Posted in The Voice of the DBA on 19 May 2008

The Little Things

This year I've been lucky enough to have been offered some prizes or promotions from a few different companies for different things. I don't really want to name names, because I think the offers or awards were nice gestures and made with the best of intentions to me and others.… Read more

0 comments, 1,195 reads

Posted in The Voice of the DBA on 15 May 2008


 Some very interesting responses to my CLR editorial today including some good details that I haven't seen elsewhere. I'm still thinking that we're missing a lot of examples that might convince people to give the CLR a try, or implement it in their applications and I'm going to try and… Read more

0 comments, 898 reads

Posted in The Voice of the DBA on 13 May 2008

A View Variable

 I saw that Erland Sommerskag posted a Connect item that asked for a "View Variable" to be added to the SQL language. The idea is that you would be able to declare a variable that was a query of some sort and then use that in places where you might… Read more

0 comments, 1,240 reads

Posted in The Voice of the DBA on 9 May 2008

Kindle Research - Procs and Cons with the Sony Reader

 After the editorial on the Kindle, which got quite a few responses, I've continued to look around and research things. I saw an interesting comparison with a husband and wife who have both. There are some interesting things on the Sony reader, especially in the comments, but I'm not… Read more

0 comments, 946 reads

Posted in The Voice of the DBA on 8 May 2008

Podcast Upgrades

A minor change for the podcasts next week. I got my wireless microphone, and I'm working with it a bit for Monday. It's nice, especially as I have to get up, change clothes, adjust things, etc. In the past I've had to worry about undoing the mic so I could… Read more

0 comments, 1,908 reads

Posted in The Voice of the DBA on 2 May 2008

Are Backup Devices Obsolete?

I thought they were, but I've had a bit of a debate in the forums with someone. There was a question on backup schemes and one person mentioned they use backup devices and send the full and differentials to one file behind the device and logs to another.  We went… Read more

0 comments, 686 reads

Posted in The Voice of the DBA on 2 May 2008


I've never really been a big fan of many of the aggregation sites. As such I have never really used Digg, Delicious, etc. However we heard at the recent MVP Summit that Technorati was used by Microsoft in their examinations of the community. So I decided to check it out… Read more

0 comments, 709 reads

Posted in The Voice of the DBA on 1 May 2008

The Post Count

One of the things that I made a conscious effort to do last summer was make a regular effort to post in the forums at SQLServerCentral.com. I'd been neglecting them for a couple years, rarely tracking anything other than the Editorials, Suggestions, and Anything Not SQL forums and putting posts… Read more

0 comments, 718 reads

Posted in The Voice of the DBA on 1 May 2008