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: June 2013

Don’t Use MD5

“The hashing alone being MD5 tells me that they really don’t care about their passwords too much, so it’s probably some pre-generated site.”

That was from this article on an Anatomy of a Hack. It’s an interesting quote, and it shows a few things.

First, we have a history… Read more

1 comments, 908 reads

Posted in The Voice of the DBA on 24 June 2013

Speakers: Rehearsals Help

Today was a rehearsal day. Actually the last 2-3 days of work have been split between rehearsing talks that I’m giving at SQL in the City this week, and handling the other daily work I need to do. With an extra load of family chores this week, I’ve had some… Read more

2 comments, 824 reads

Posted in The Voice of the DBA on 18 June 2013

SQL in the City Goes Mobile

This week is the kickoff of the third year of SQL in the City from Red Gate. As we have the other years, we start 2013 off in London, and I’ll be leaving Wednesday on a quick trip across the water to speak. I’m looking forward to seeing lots of… Read more

0 comments, 949 reads

Posted in The Voice of the DBA on 17 June 2013

T-SQL Tuesday #43–Hello, Operator?

It’s T-SQL Tuesday time, and this one is a bit of a challenge for me. Rob Farley is hosting, and asking for people to write on Plan Operators, those various elements that go into the execution plans in T-SQL. I don’t dive too deeply into these items, unlike… Read more

2 comments, 927 reads

Posted in The Voice of the DBA on 11 June 2013

CHOOSE in SQL Server 2012

The CHOOSE command is new in the T-SQL as of SQL Server 2012. I hadn’t ever had the chance to work with it, but after seeing someone submit a piece recently, I decided to play with it a bit.

This feature is essentially an indexing value from an array. Here’s… Read more

1 comments, 1,329 reads

Posted in The Voice of the DBA on 4 June 2013