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

PC Sales Declining

About 3 or 4 years ago I was talking with my wife and a colleague of hers that worked in the mobile industry. This person and my wife thought that the mobile industry would explode, and it’s impact and expansion would dwarf the PC revolution that had most of our… Read more

2 comments, 1,387 reads

Posted in The Voice of the DBA on 31 May 2013

Exploring a Database in Azure

After creating my Azure account, I wasn’t sure where to go next. Fortunately I had an immediate project that occupied my attention: a public Adventureworks database.

As we noted, Red Gate and SQLServerCentral agreed to host the database and cover costs. Once Jamie Thomson transferred the database to my subscription,… Read more

2 comments, 1,643 reads

Posted in The Voice of the DBA on 30 May 2013

The 2013 SQL in the City Tour

Once again, Red Gate is planning on a tour of the US for the SQL in the City events. Last year we had a large tour, hitting 6 cities in the US during October and November of 2012. It was great fun, and very well received by the attendees.… Read more

0 comments, 850 reads

Posted in The Voice of the DBA on 27 May 2013

When will we look back at this?

It’s amazing how software has advanced. I look at the software I use, and I’m amazed. I still remember texting to 40404 for basic twitter usage on my Windows 6.5 Mobile. That seems miles away from the apps I know use on my current iPhone 4S. I almost can’t comprehend… Read more

2 comments, 2,037 reads

Posted in The Voice of the DBA on 24 May 2013

Starting with Azure

I’ve been meaning to do this, and I finally had the chance recently to start working with Azure. Red Gate is investing in cloud tools, and more development tools, so it’s something I need to work on.

I went to the Azure page, and noticed a “Member Offers” link.

When… Read more

0 comments, 2,538 reads

Posted in The Voice of the DBA on 23 May 2013

The Bicentennial SQLSaturday–#200 Philadelphia

When Andy Warren (b | t | Li)started SQL Saturday with #1 in Orlando, we weren’t sure it would succeed. After a few events, we dreamed and wondered if we’d ever get to 50 events. Despite our success in the past, we weren’t sure if a free event,… Read more

0 comments, 898 reads

Posted in The Voice of the DBA on 22 May 2013

Getting Information from a Database using Dynamic SQL

I ran across someone that was building a restore script to automated their restores. This person wanted their script to work with any instance, and that means they’d need to find the path for the database files, if the database already existed.

It was interesting to me, and I decided… Read more

3 comments, 939 reads

Posted in The Voice of the DBA on 20 May 2013

Software Design and Schizophrenic Windows 8 Part 2

I know it’s not schizophrenic, but that sounds better. It’s really a split personality.

I wrote recently about Windows 8 and what I consider to be poor design in the update system. Today I want to look at another aspect that troubles me.


I’ve gotten used to the… Read more

0 comments, 1,154 reads

Posted in The Voice of the DBA on 17 May 2013

Not My Google Reader Replacement

Someone suggested Newsblur to me, and I went to their home page. Like many sites, it asks you to sign up, so I decided to give it a try.

The import from Google Reader caught my attention, so I clicked it. It asked for an authorization from Google, and then… Read more

1 comments, 807 reads

Posted in The Voice of the DBA on 15 May 2013

T-SQL Tuesday #42–The Long and Winding Road

It’s T-SQL Tuesday time, this month hosted by Wendy Pastrick who asks you to talk about the Long and Winding Road. Wendy asks us to talk about your job, your road map to the future, and what might be in store for you.

T-SQL Tuesday is a monthly blog… Read more

0 comments, 886 reads

Posted in The Voice of the DBA on 14 May 2013

Schizophrenic Windows 8

I’ve been using Windows 8 almost exclusively for about 3 weeks. I got a new desktop a couple months back, which has only had Windows 8 installed on it. My new laptop arrived about 4 weeks ago and a week later I finally abandoned my Macbook Air and moved fulltime… Read more

4 comments, 1,006 reads

Posted in The Voice of the DBA on 10 May 2013

Starting with Git for Database Development

One of the tools that Red Gate Software makes is SQL Source Control. It’s a plug in to SSMS that allows you to hook your database up to version control. I’ve used it a few times in the past in conjunction with Subversion to demo the product. However I hadn’t… Read more

1 comments, 8,315 reads

Posted in The Voice of the DBA on 8 May 2013

Donating for a little kid

One of my authors sent me this note:

I know you only know me as a writer for SQLServerCentral, but I have a friend whose son is really bad. He is at the hospital and the cannot pay it. It is very expensive. The family is desesperate. They live… Read more

2 comments, 689 reads

Posted in The Voice of the DBA on 6 May 2013