Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: September 2010

Is Your Database “Web-Scale”?

It’s not safe for work (NSFW), so be sure that you’ve implemented a cone of silence as appropriate for your environment.

It’s a parody of the Evo v iPhone video (also NSFW), this time looking at NoSQL and MongoDB v RDBMS systems.

Read more

2 comments, 266 reads

Posted in The Voice of the DBA on 10 September 2010

Goal Update - Misc accomplishments

I have been trying to better track my goals this year, and find myself failing at some, exceeding at others. I’m not sure if that means that I did a poor job setting goals, or that I’m not so good at following through. I’ll have to evaluate that in December. Read more

0 comments, 90 reads

Posted in The Voice of the DBA on 10 September 2010

Cloning Virtual Box Images in Windows 7

I use VirtualBox from Sun to do SQL testing since it supports 64-bit guest images, which I want need for some things, like Windows 2008 R2, which only comes in x64.

However I hate reinstalling stuff that I don’t need to. And with a multitude of SQL versions, and a… Read more

1 comments, 662 reads

Posted in The Voice of the DBA on 10 September 2010

T-SQL - Is Saving Space Worth It?

I ran across this blog post on Joe Celko’s Restaurant Seat Assignment Problem that found a way to implement the smallest amount of storage for a classic problem. It’s more of a challenge than a real solution.
Or at least I hope so.
The solution actually uses some bitmasking to…

Read more

3 comments, 105 reads

Posted in The Voice of the DBA on 9 September 2010

Common SQL Server Mistakes – GUID as a Clustered PK

I haven’t been thrilled with GUIDs as primary keys, mainly because I think that it’s hard for humans to work with GUIDs. A GUID, or uniqueidentifier, looks like this:

ECB6ECB4-ACCB-4382-84D1-19990D59CA2F

Not exactly something I want to try and type or include in a query. Cut and paste works, but it’s… Read more

0 comments, 637 reads

Posted in The Voice of the DBA on 8 September 2010

Virtual Labs - A Great Resource for SQL Server

I had someone send me a note recently asking some questions about how to get set up to work with SQL Server. This was a person that had used SQL Server in the past, but had become a manager and then lost their job. So they wanted to start working…

Read more

2 comments, 384 reads

Posted in The Voice of the DBA on 7 September 2010

Labor Day Bloopers

Happy Labor day to everyone. A day off for me, but I’m posting a few bloopers from the past couple months. These are the raw files, and I had about 40 minutes of stuff that I just dumped out raw and uploaded in four parts to YouTube.

Enjoy

Bloopers Part…

Read more

0 comments, 468 reads

Posted in The Voice of the DBA on 6 September 2010

Six Trips

Six trips left to close out this year. Most are very short, so that’s good, but still, it’s a bunch of packing and prepping to do.

Here’s my list:

Sept 25 - SQL Saturday #52, Denver Tech Center, OK, so not a real trip, but still I’ll essentially be… Read more

4 comments, 89 reads

Posted in The Voice of the DBA on 3 September 2010

Another E-Reader

No, it’s not a new device. This time it’s my son, Delaney, who has been reading on my old iPhone regularly.

He started when he got through a series of science fiction that I had purchased in paperback and wanted to read the last book. Unfortunately I only had it… Read more

1 comments, 86 reads

Posted in The Voice of the DBA on 3 September 2010

I Hate Planes

A few short bloopers, just for a few friends that fly planes.

YouTube Link (in case the embed fails)

Read more

1 comments, 141 reads

Posted in The Voice of the DBA on 2 September 2010

SQL Saturday Advice - PhotoJournalism

I try to carry a camera, and a video camera, most of the time when I’m traveling. I have a camera on my iPhone as well, and for all that, I tend to just forget to take enough images when I travel. Especially at events where I’m often talking to…

Read more

4 comments, 122 reads

Posted in The Voice of the DBA on 2 September 2010

Common SQL Server Mistakes - SELECT *

I’ve been trying to work on some new presentations so that I have a variety, including some spares, when I go to events. One of the topics that I think has some value, especially for .NET and sysadmin groups, is a list of common mistakes, how to fix them, and… Read more

19 comments, 1,817 reads

Posted in The Voice of the DBA on 1 September 2010

Newer posts