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

A Vacation and Traveling to Sacramento

I’ve got a couple days off, starting today after my webinar on Preparing for When Disaster Strikes. I’ve got some family in town, and since I haven’t taken vacation in some time, I’m looking forward to being unwired for a couple days.

On Thursday my daughter and I head… Read more

0 comments, 879 reads

Posted in The Voice of the DBA on 23 July 2013

Energy news that caught my eye

I’ve been a big fan of nuclear energy ever since I worked at a power plant. Before that I was terrified and didn’t think it was a good idea, but I learned quite a bit about how it works and while there are issues, I think it’s a good source… Read more

0 comments, 986 reads

Posted in The Voice of the DBA on 19 July 2013

The Stairway to Deployment

Next week I travel to Sacramento, CA for the SQL in the City Seminar – Stairway to Deployment on Friday, July 26, 2013. It’s a half day event where Grant Fritchey and I will look to lead you through the idea of implementing continuous integration and continuous deployment for databases… Read more

0 comments, 1,069 reads

Posted in The Voice of the DBA on 17 July 2013

Disable the Charms Bar – Making Windows 8 Better

One of the things that’s bothered me is the way the charms bar frequent popping out as my mouse moves to the upper or lower right. I do this as I’m trying to reach the “x” to close a window or adjust time zones. The bar pops out and it’s… Read more

0 comments, 952 reads

Posted in The Voice of the DBA on 17 July 2013

SQL Server Needs Tempdb

I saw a post recently where someone noted they had moved tempdb like this:

USE master; GO ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'c:\tempdb.mdf'); GO ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = 'c:\templog.ldf')

This gives you the… Read more

1 comments, 1,184 reads

Posted in The Voice of the DBA on 15 July 2013

Two Weeks until SQL Saturday #222 in Sacramento

It’s just two weeks until my next trip. It feels like I just got back from London, and one again I’m prepping to leave again. This is my only trip in July, which I appreciate. It’s been a busy year so far, with lots of travel for me and I… Read more

1 comments, 980 reads

Posted in The Voice of the DBA on 12 July 2013

Test Your Restores

Test your restores: he first tip in my Hard Earned Lessons of a DBA piece.

I can’t emphasize this enough. I’ve been called in as an employee and consultant to companies that never had tested a restore. Quite a few of those times there has been data loss.

Filed under:…

Read more

0 comments, 827 reads

Posted in The Voice of the DBA on 11 July 2013

T-SQL Tuesday #44–Second Chances

It’s T-SQL Tuesday time again. This is the monthly blog party, started by Adam Machanic. If you’d like to participate, write a post on the topic and publish it on the second Tuesday of the month. If you’d like to host, contact Adam.

This month the topic is hosted by… Read more

2 comments, 1,075 reads

Posted in The Voice of the DBA on 9 July 2013