Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: January 2011

A SQL Azure Customer

Not me, though I’m not necessarily against Azure in principle. I had a friend ask me for a SQL Server hosting provider the other day, saying they had built a web front end, and had a web host, but were thinking to separate out some data to a separate provider.… Read more

0 comments, 280 reads

Posted in The Voice of the DBA on 26 January 2011

Backing up the log in simple mode

Someone posted a note saying that their backups were really large and slow. So they were trying to manage their backup scheme and ensure some level of recovery.  I was going back and forth, along with others, talking about the way your recovery would go and the merits of that… Read more

1 comments, 842 reads

Posted in The Voice of the DBA on 25 January 2011

Coming to SQL Saturday #60 in Cleveland

It’s just a couple weeks away, on Super Bowl weekend. I can’t believe this is event #60, still in shock that this amazing franchise has grown to large.

I’ll be at SQL Saturday #60 in Cleveland on Feb 5, 2011, with my good friend Allen White (blog | @SQLRunr),… Read more

1 comments, 253 reads

Posted in The Voice of the DBA on 24 January 2011

Disk Partition Alignment–MCM Prep

Does disk partition alignment matter to SQL Server? Without a doubt. When new disk partitions are created, there could be a reserved set of sectors that could differ across disks because of the way that the hardware interacts. In the white paper, Disk Partition Alignment Best Practices for SQL Server,… Read more

0 comments, 694 reads

Posted in The Voice of the DBA on 21 January 2011

You Need Two SLAs for Disaster Recovery

Continuing on with my MCM prep, I was listening to the High Availability/DR prep module today and I was once again surprised by something. Typically I have heard all kinds of talk for SLAs, usually in terms of network traffic. For databases, I have had SLA conversations that were for… Read more

3 comments, 859 reads

Posted in The Voice of the DBA on 19 January 2011

Isolation Levels–MCM Prep

I was watching the Isolation Levels video for my MCM prep and learned something about the isolation levels. I knew there were four levels, but I hadn’t realized that SQL Server used the default of level 1, out of the 4 ANSI levels. The levels are:

  • 0 – Read Uncommitted…

Read more

0 comments, 500 reads

Posted in The Voice of the DBA on 17 January 2011

Multi-tenant Architecture

When you design a database, or at least when I do, I think it’s important to build a database schema that is flexible, and anticipates change. You can’t foresee every change required, but you can consider the types of changes that might be required, the places where data can grow,… Read more

0 comments, 1,662 reads

Posted in The Voice of the DBA on 14 January 2011

CTRL Scroll and Getting Old

The handiest thing that I’ve used lately for a computer is the Ctrl button and the scroll wheel on my mouse. If you’ve never tried it, do it now on this web page. Scroll different directions and you’ll see what I mean.

Here’s the default view of my blog:

It’s… Read more

1 comments, 428 reads

Posted in The Voice of the DBA on 11 January 2011

Thinking about goals for 2011

The SQL community is inspiring, and there are a lot of people that work hard to contribute to it. With all the efforts (I hesitate to use the word “competition”), it inspires others to try harder and do more. It’s no wonder we have a huge number of SQL Server… Read more

1 comments, 314 reads

Posted in The Voice of the DBA on 10 January 2011

Consolidating My Brand

I decided that I really like the WordPress platform, and more importantly, that I need to consolidate all the work I do on my career.

With that in mind, www.voiceofthedba.com should now point here to this blog, where I’ll keep the editorials, and my blog going, as well as presentations… Read more

0 comments, 291 reads

Posted in The Voice of the DBA on 8 January 2011

Windows Experience on W510

I toyed with the idea of using the SSD for my main drive, but I’d really like to get the VMs running quicker and in the end decided to use that as my secondary, as the location for the VHD and VDI files.

As a result, my Windows Experience Index…

Read more

1 comments, 477 reads

Posted in The Voice of the DBA on 7 January 2011

The laptop rebuild continues

Not done yet, but I have been slowly patching and installing software over the last few evenings, stuck at my desk most days. It’s amazing how little software I have on DVD, and how little I need. Once I got Win 7 installed, I needed to grab the wireless driver… Read more

3 comments, 237 reads

Posted in The Voice of the DBA on 7 January 2011

Rebuilding the W510 – DVD Driver Issues with x64

I backed up my machine, copied a bunch of data to both a thumb drive as well as the second hard drive on my W510, and get ready to install Windows 7 x64.

First I had to add memory. I had put 8GB in the bottom slot, but to replace… Read more

0 comments, 276 reads

Posted in The Voice of the DBA on 6 January 2011

Rebuilding the W510 - DVD Driver Issues with x64

I backed up my machine, copied a bunch of data to both a thumb drive as well as the second hard drive on my W510, and get ready to install Windows 7 x64.

First I had to add memory. I had put 8GB in the bottom slot, but to replace…

Read more

2 comments, 424 reads

Posted in The Voice of the DBA on 5 January 2011

MCM Prep – Sliding the test

If you can’t cram enough for the test, what’s the thing to do? Slide the test. I realized last night that I was scheduled for this Friday, but I’m nowhere near prepared. Not that I’ll be totally prepared, but I’d like to be well prepared in my mind and I… Read more

0 comments, 230 reads

Posted in The Voice of the DBA on 4 January 2011

MCM Prep – Only ONE Transaction Log File

Unlike for data files, SQL Server does not use multiple files for the transaction log in any way that improves performance. The writes are not striped across files. Instead SQL Server will write to one file, then the next, then the next, wrapping to the first file when all the… Read more

1 comments, 311 reads

Posted in The Voice of the DBA on 4 January 2011

MCM Prep - Sliding the test

If you can’t cram enough for the test, what’s the thing to do? Slide the test. I realized last night that I was scheduled for this Friday, but I’m nowhere near prepared. Not that I’ll be totally prepared, but I’d like to be well prepared in my mind and I… Read more

3 comments, 251 reads

Posted in The Voice of the DBA on 4 January 2011

MCM Prep - Only ONE Transaction Log File

Unlike for data files, SQL Server does not use multiple files for the transaction log in any way that improves performance. The writes are not striped across files. Instead SQL Server will write to one file, then the next, then the next, wrapping to the first file when all the… Read more

0 comments, 289 reads

Posted in The Voice of the DBA on 4 January 2011

MVP 2011

I was awarded the MVP status from Microsoft for 2011 on Jan 1, 2011. This is my fourth consecutive award and I am honored to be recognized for my efforts in the SQL Server community.
When I opened the email last Saturday morning, I had mixed feelings. On one hand…

Read more

10 comments, 450 reads

Posted in The Voice of the DBA on 3 January 2011

Back to Work

It's actually nice to be back to work. It's been a great holiday season for me, lots of family time and un-wired time, but I'm ready to get back to my routine and learning some SQL. There was a severe lack of studying over the last week, however with relatives…

Read more

0 comments, 275 reads

Posted in The Voice of the DBA on 3 January 2011