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 2012

Using a Symmetric Key

In my Encryption Primer talk, I do demo on symmetric key use, and wanted to document it here. Encryption is a serious subject, and please do your research and education, as well as testing, before you implement it.

This post will look at some simple encryption and decryption using symmetric… Read more

1 comments, 2,793 reads

Posted in The Voice of the DBA on 27 June 2012

Last Week to Enter the Exceptional DBA Contest

Just a reminder: you have until this Friday to enter the 2012 Exceptional DBA awards. I’m judging, and looking forward to reading the entries next week, so get them in.

A hint: communication skills matter. Take some time and think about what you want to write for each question. Read more

0 comments, 1,612 reads

Posted in The Voice of the DBA on 27 June 2012

Down and Dark

I came back from vacation to find the home DSL line bouncing up and down a bit. I wasn’t overly worried, and the kids knew to restart the router when it went down, crossing their fingers for a good connection. I suspected the router might be dying, and was getting… Read more

0 comments, 1,551 reads

Posted in The Voice of the DBA on 26 June 2012

Almost an MCSA

I took four beta tests earlier this year for SQL Server 2012. I had debated writing another book, and I’ve worked on a few of the cert books in the past, so I thought this would be a good chance to look at the tests. Since I had free invites… Read more

0 comments, 1,275 reads

Posted in The Voice of the DBA on 25 June 2012


Sort of.

I’m off for a week to Camp Alexander near Pikes Peak for Boy Scout summer camp. My 13year old is attending and working his way toward Eagle Scout. He’s a Star scout now, and with any luck, this week we’ll get 3 more of the Eagle required… Read more

0 comments, 840 reads

Posted in The Voice of the DBA on 18 June 2012

T-SQL Tuesday #31 – Logging

It’s T-SQL Tuesday time again, and this month Aaron Nelson (blog | @sqlvariant) is hosting. The topic is logging, and if you’re like to participate, read Aaron’s post and learn the rules. We do this on the second Tuesday of every month.

If you’d like to host, contact… Read more

0 comments, 1,635 reads

Posted in The Voice of the DBA on 12 June 2012

Slipping in a Break

I know some people like long holidays, but I tend to prefer short ones. Today is one of those breaks for me. I’m coming back from Pensacola and SQL Saturday #132, taking the day off as I spent Sunday and the morning with my daughter.

This was a combination of… Read more

0 comments, 853 reads

Posted in The Voice of the DBA on 11 June 2012

The Exceptional DBA Awards – 2012

Who will be the Exceptional DBA of 2012? I’ll be judging.

It’s hard to believe that it’s time for the Exceptional DBA awards once again. It was just a few months ago that I watched the presentation of the award to Jeff Moden in Seattle. However time flies, especially as… Read more

0 comments, 2,567 reads

Posted in The Voice of the DBA on 11 June 2012

Contained Databases – Preventing Collation Conflicts

One of the demos from my Contained Databases talk looks at the issues you can have when your database collation does not match your server collation. I’ll walk through the issue here. I’ll show the issue, and then the fix with contained databases.

First, let’s create a database and a… Read more

0 comments, 2,321 reads

Posted in The Voice of the DBA on 7 June 2012

Creating a Filetable

How do you create a filetable? I assume you’ve enabled Filestream and created a filegroup for your filestream and filetable data. Then you just do this:

-- Create a filetable
CREATE TABLE AuthorDrafts 
  AS FileTable

The only optional part of this statement is the table name. No other… Read more

0 comments, 3,278 reads

Posted in The Voice of the DBA on 5 June 2012

Back to Pensacola and SQL Saturday #132

This will be my fourth trip to Pensacola for SQL Saturday #132. I’ve enjoyed going every time and I usually take a day or two off from work on the trip to spend with my daughter. Last year we both got shirts, and had a good time at the… Read more

1 comments, 962 reads

Posted in The Voice of the DBA on 4 June 2012

The Standing Desk – Week 1

I finally got my standing desk working last weekend and started on Tuesday (after Memorial Day) working at it on a regular basis.

This was the initial setup

I used a box of books, with 4 more under the keyboard and another box for the mouse. I had two monitors… Read more

0 comments, 1,111 reads

Posted in The Voice of the DBA on 1 June 2012