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: November 2009

What’s Using Space in Tempdb?

It happens, not often, but I do regularly see people talking about their tempdb growing too large. Often that means that people have not properly sized tempdb to me, but there could be legitimate reasons why it’s grown large.

This is one reason that I’d like to see a separate… Read more

1 comments, 9,054 reads

Posted in The Voice of the DBA on 30 November 2009

When it rains…

It pours.

I come back from 4 days unwired, a bunch of writing done, to a laptop that’s head, a site that won’t take posts, and a ton of email and articles.

At least my external HDD reader is reading the drive. I’m copying stuff off now, but it’s not… Read more

2 comments, 548 reads

Posted in The Voice of the DBA on 30 November 2009

Unwired

I didn’t have Internet access for 4 days while we were in the mountains. Actually I could have purchased it, but for uploading blogs it didn’t seem like a great idea. Plus I’d be tempted to work if I did that.

So I did some offline blogging, but for the… Read more

1 comments, 562 reads

Posted in The Voice of the DBA on 30 November 2009

Picking a Branch

Do you know that there are actually two branches of SQL Server 2008 code right now? Actually I would bet there are 3 branches, but we have two publically available branches to choose from:

  • The RTM branch
  • The Service Pack 1 branch

I’ve known this for awhile, but haven’t thought… Read more

1 comments, 355 reads

Posted in The Voice of the DBA on 27 November 2009

Adios

If all goes well, by the time you read this on Thanksgiving I’ll be up in the mountains of Colorado. No SQL Server questions to answer, no editorials to write, no articles to edit.

I think I say it often, but it bears some repeating. Get away from your day… Read more

1 comments, 264 reads

Posted in The Voice of the DBA on 26 November 2009

In Charge

I had to run our weekly conference call this week. My boss is out of the office, but he’s been trying to get everyone to participate by having different people run meetings on different weeks. I’m not the best employee in this sense, and not always prepared, so I’ve tried… Read more

0 comments, 253 reads

Posted in The Voice of the DBA on 25 November 2009

Cleaning out Tempdb

I saw a post recently about the tempdb being overly large and causing issues for a user. The person was having issues shrinking the files and wasn’t sure what to do. Someone else responded that snapshot isolation might be an issue and I found that interesting. I hadn’t thought about… Read more

0 comments, 1,286 reads

Posted in The Voice of the DBA on 25 November 2009

Balancing Time Today v Time Tomorrow

I’ve always thought that you should invest where you can. Make a little effort now that will pay back later, in life and in your job.

I read a blog recently from Mike Walsh that talks about making that investment. If you do something that can save time later, that… Read more

2 comments, 266 reads

Posted in The Voice of the DBA on 24 November 2009

The Car Update – Prius Sales

I haven’t done a car update in some time, and I’d like to get back to them. Surprisingly quite a few of them provoke some amazing reactions from people. Especially when I talk about my Prius.

I don’t think the Prius is for everyone, but it is a great car… Read more

0 comments, 245 reads

Posted in The Voice of the DBA on 23 November 2009

I’m Missing Data

One of the things that I thought about doing after the 2008 PASS Summit was to bring someone along with me as a photographer/videographer that would take lots of pictures and video of the event. I thought about bringing my wife, but that didn’t work out and I dropped the… Read more

4 comments, 246 reads

Posted in The Voice of the DBA on 20 November 2009

Licensing For Everyone

I used to really try not to over-license in the small companies I worked at. It seems I’d spend a few days every quarter or two counting up usage, asking people what they did, looking at logs, and eventually calculating our needs. Then compare the needs to what we’d purchased… Read more

2 comments, 275 reads

Posted in The Voice of the DBA on 19 November 2009

It's Getting Confusing Talking Platforms

There was a time that Windows ran on multiple architectures. We had the PowerPC, Alpha, and MIPS CPUs in addition to the Intel x86. That ended with Windows NT as it seemed those other architectures didn't generate a lot of sales and Microsoft discontinued the porting of the OS.

For… Read more

0 comments, 232 reads

Posted in The Voice of the DBA on 18 November 2009

Workflow is important

I have a pretty good administrative system here at SQLServerCentral for managing the site. The upgrades we made in 2007 really simplified some of the back end work, and while there are bugs and issues, it has made it easy for people to submit articles, scripts, and questions online. I… Read more

0 comments, 251 reads

Posted in The Voice of the DBA on 17 November 2009

Blowing Off Steam and Recharging

I’ve written a few things about why conferences and events are good, or why it’s valuable for an IT worker to go to them (Being Around Smart People is Exciting, The Conference ROI). I believe that if you take a motivated employee and send them to an… Read more

3 comments, 255 reads

Posted in The Voice of the DBA on 16 November 2009

PASS Summit 2009 - Media

There were tons of people taking pictures and video during the PASS Summit. I found a number of pictures on the Flickr Feed under the #sqlpass tag, and there are plenty more on Twitter as well.

A few of my pictures:

OK, I had to post this one because… Read more

0 comments, 384 reads

Posted in The Voice of the DBA on 13 November 2009

The SQLServerCentral Party

I think it went off well this year, and it looks like it will be around next year as well. My initial conversations with PASS have gone well, and I expect a contract as soon as the staff recovers from the Summit.

Pat Wright, former PASS Board member, and… Read more

2 comments, 242 reads

Posted in The Voice of the DBA on 12 November 2009

PASS Summit 2009 – Keynotes

I’m not going to look back at the keynotes since I blogged about them. If you are interested, you can read about them:

Instead I’m going to focus on… Read more

0 comments, 224 reads

Posted in The Voice of the DBA on 12 November 2009

PASS Summit 2009 – Fun

I’m not a big party guy, and in fact, more than a few people can attest to the fact that I’m likely to duck out early at evening events. However there are some fun things at PASS that I wanted to mention, and let you know what you can (likely)… Read more

2 comments, 266 reads

Posted in The Voice of the DBA on 11 November 2009

PASS Summit 2009 – Overall Event

I thought that we got a great Summit from PASS in 2009. This week I’ll be looking back at some of the things that occurred and give you some notes from my perspective on the event. I’ll also include some pictures from myself and others, along with a few videos… Read more

1 comments, 238 reads

Posted in The Voice of the DBA on 10 November 2009

The Nook

Barnes and Noble recently announced their new e-book reader, the Nook. It looks pretty cool, and in some ways I think it really blows past the Kindle. There is another reviews from Technology Review.

There are two big features that make me think this is a great new… Read more

0 comments, 246 reads

Posted in The Voice of the DBA on 9 November 2009

Older posts