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

Encryption and Full Text Search at The Mandalay Bay (DevConnections)

It’s just a week until Dev Connections.  This is one of the great conferences for the hybrid technology person, with a variety of technologies being talked about, all for a single admission price. I’ll be speaking at SQL Server Connections, but wandering over to the development side at… Read more

0 comments, 669 reads

Posted in The Voice of the DBA on 23 September 2013

The Dangers of Detach

I ran across a twitter conversation about a post recently. The post talks about detaching or attaching databases in bulk.

I agree that detaching databases in some cases is bad, but it’s not necessarily something I’d avoid. Detach is a good way to prep for upgrades, movement, etc. It may… Read more

0 comments, 880 reads

Posted in The Voice of the DBA on 18 September 2013

Backups, Encryption and Branding in San Diego

This weekend is SQL Saturday #249 in San Diego. I’m looking forward to the trip for a few reasons, but mostly because I used to live in the Northern San Diego area and love going back to spend time near the beach. I’m not sure what I’ll have time to… Read more

3 comments, 818 reads

Posted in The Voice of the DBA on 16 September 2013

Managing Data in a FileTable with T-SQL

I wrote a post about creating a Filetable, which just covered the basics of how to build one. How do you work with the data in this table? In this post I’ll look at a few things you can do from the T-SQL side.

From the last post, I… Read more

0 comments, 1,055 reads

Posted in The Voice of the DBA on 11 September 2013

T-SQL Tuesday #46–The Rube Goldberg Machine

It’s T-SQL Tuesday time again. This is the monthly blog party where we all write on a topic. This month the topic is the Rube Goldberg Machine, as it might relate to SQL Server. You can read the invitation linked above from Rick Krueger and write your own post… Read more

0 comments, 1,008 reads

Posted in The Voice of the DBA on 10 September 2013

Be Careful in Business

I like most of the SQL Server people I meet. Most of you are polite, cheerful, friendly, and it’s nice to share a few minutes of my life with you, chatting about anything. Whether that’s technical issues with SQL Server, running, books, or anything else, I often find my life… Read more

0 comments, 849 reads

Posted in The Voice of the DBA on 6 September 2013