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: November 2011

Forgiving Mistakes

My main phone line at the house has been on the fritz for about 3-4 weeks. Yes, we still have a main line and it’s a legacy holdover from having that number for a decade and it links do our DSL account. We may get rid of it at some… Read more

3 comments, 2,413 reads

Posted in The Voice of the DBA on 30 November 2011

Shutting down for a week

I try to speak and write about career things on a regular basis because I think they’re important topics for those of you working with SQL Server. Arguably they are as important as the technical stuff. One of the things I try to preach is “balance” and making sure that… Read more

3 comments, 1,658 reads

Posted in The Voice of the DBA on 17 November 2011

The First Thing To Do After Creating Keys

I’ve been looking at some security code in preparation for a few talks I plan on doing next year and there’s one thing I don’t see in many of the samples: backups.

When you get ready to encrypt data in a table, or you enable Transparent Data Encryption (TDE), you… Read more

0 comments, 1,205 reads

Posted in The Voice of the DBA on 15 November 2011

SQL Inspire NYC – 2011

The lineup for SQLInspire

I spoke at the SQL Inspire event this last weekend and it was a greart experience. This event was sponsored by Linchpin people (founded by Andy Leonard, Brian Moran, and Matt Velic) and supported by Robert Pearl, Melissa Demsak, and others in the New York/New Jersey… Read more

1 comments, 1,490 reads

Posted in The Voice of the DBA on 14 November 2011

Quite a salary

If this article is true, and I suspect it is for some software engineers, why aren’t more people learning programming?

I think that we have a few problems in the industry, and I have an editorial coming out soon on this. One is that this type of money is rare.… Read more

0 comments, 1,054 reads

Posted in The Voice of the DBA on 8 November 2011

A view has no data

I have seen quite a few posts and questions lately from people that are trying to change the data in a view, or move data in a view.

A view has no data.

It’s that simple. If you have something like this in AdventureWorks:

SELECT firstname
, lastname
 FROM HumanResources

Read more

0 comments, 1,924 reads

Posted in The Voice of the DBA on 8 November 2011

Slide Decks for PASS, SQL in the City, and SQL Server Connections

I’ve sent my slide decks to the organizers, but I know they don’t always get posted. So I’m putting a few links up here for my talks.

If you check the page for my Preparation for Disaster talk, you’ll find I have links for the two recent events to the… Read more

0 comments, 937 reads

Posted in The Voice of the DBA on 7 November 2011

Get Inspired – SQL Inspire 2011 New York

Coming up next week is the SQL Inspire 2011 event in New York City. It’s an event with a number of SQL Server community speakers that are here to inspire you in your career, your life, and with SQL Server. The talks cover a variety of topics, and they look… Read more

3 comments, 1,671 reads

Posted in The Voice of the DBA on 1 November 2011