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: February 2011

Test Complete – MCM

I took the MCM test today, and finished it. I needed the time allotted and it was, well, an experience.

I’m glad it’s done as I have a number of other things to work on. I’ll get results in a few weeks and in the meantime, I’ll get permission to… Read more

3 comments, 1,759 reads

Posted in The Voice of the DBA on 25 February 2011

You Can’t Disable the CLR in SQL Server – MCM Prep

At least not completely. There are some functions in SQL Server that are built on the SQL CLR, and even if you have disabled the CLR for user written code, it still loads app domains and functions for system code.

An example of this is the spatial data type. It’s… Read more

0 comments, 909 reads

Posted in The Voice of the DBA on 23 February 2011

T Minus Three Days to the MCM Test

I take the MCM test on Friday. I’ve been watching videos and reading white papers and blogs for the last few weeks and I know that I don’t necessarily know enough. To some extent I have an advantage since I test well on multiple choice tests and I have a… Read more

9 comments, 1,342 reads

Posted in The Voice of the DBA on 22 February 2011

Backups after a DR Restore – MCM

If you have a disaster, and you need to restore to some point in time prior to the last log backup you have, what’s the first thing you should do at this point in time?

Make a full backup, of course.

Actually anytime you complete a restore sequence, you want… Read more

1 comments, 783 reads

Posted in The Voice of the DBA on 21 February 2011

T-SQL Tuesday Topics – Feb 2011

I was looking for a static list of all the T-SQL Tuesday topics and couldn’t find one. The domain moves around to the current hosting blog, so when it was my turn to host it, I made a list just so I could reference what was out there.

After a… Read more

0 comments, 882 reads

Posted in The Voice of the DBA on 11 February 2011

I make myself smile

Sometimes, usually when I’m editing video, I see myself do something silly. Today was one of those times, and these two bloopers, kind of a spur of the moment thing while I was recording, came out funny.


My son thought this was pretty funny as well.

Filed under: Blog

Read more

2 comments, 688 reads

Posted in The Voice of the DBA on 9 February 2011

T-SQL Tuesday #15 – Automation

It’s that time of the month again, and this month Pat Wright and his SQL Asylum are hosting the T-SQL Tuesday #15 party.

If you want to learn more about the party, read Adam Machanic’s intro post (Blog|Twitter). If you’re interested in hosting from your blog,… Read more

0 comments, 1,001 reads

Posted in The Voice of the DBA on 8 February 2011

SQL Saturday Advice–Upload Decks Early

One of the neat features for the SQL Saturday site is that it allows the speakers to upload a deck that is attached to their session. If you go to the schedule after the event, and pick a session you attended, you can get the Powerpoint deck, the code, anything… Read more

0 comments, 1,398 reads

Posted in The Voice of the DBA on 3 February 2011

A Full Backup can Impact a Log Backup–MCM Prep

In the early days of SQL Server you could not run a log backup while a full backup was running. In fact,you tried to schedule them apart from each other early in my career to prevent collisions. Nothing bad happens, but it does cause failures in your monitoring and those… Read more

13 comments, 2,895 reads

Posted in The Voice of the DBA on 2 February 2011

Work Isn’t the Most Important Thing

I had quite an adventure today, away from work. We had a pipe freeze in the house, a sick kid, and then a plumber call when the pipe broke. All in all, with school closed and kids home, I haven’t gotten much work done. My wife ended up also… Read more

2 comments, 1,076 reads

Posted in The Voice of the DBA on 2 February 2011

What’s a Passive Server?

Licensing software is often a more complicated process than I think it should be. Licensing database software seems to be even more difficult to understand, especially when you start to talk about the various high availability (HA) scenarios, virtualized  servers, separate machines to process SSIS packages and who knows what… Read more

1 comments, 5,121 reads

Posted in The Voice of the DBA on 1 February 2011