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

The Gift Count

I went by Best Buy this afternoon, with my updated budget, to grab 2 last gifts and blow out the money. We’re now at 65 gifts, according to my daughter’s count. Lots of DVDs and books, but I’ve added in a few nicer things that we’ll randomly give away:

  • A…

Read more

1 comments, 583 reads

Posted in The Voice of the DBA on 31 October 2009

Fun in Seattle

I know there are a number of people heading to Seattle this weekend for the PASS Summit next week. I am coming in on Monday, leaving Fri, and pretty much stuck with work all week.

However I know some of you are going to be in town early or late,… Read more

6 comments, 674 reads

Posted in The Voice of the DBA on 30 October 2009

Running to the PASS Summit

Well, not literally. I’m not going to run to Seattle from Denver, but I’ll be running at the Summit.

Last year when the Summit took place, I was about 70 days into my running streak. I was worried about keeping it going at the Summit since it’s a busy week… Read more

1 comments, 572 reads

Posted in The Voice of the DBA on 30 October 2009

There was a rancher who had a DBA.... (Getting prepped for PASS)

and B-I-N-G-O was his game-o.

Maybe not that funny, but I think that SQL Bingo will be a fun time. If you haven't heard of it, check out the link. Stuart Ainsworth, Blythe Morrow, and Brent Ozar have put together a fun networking game sponsored by Quest and SQLServerPedia. They've… Read more

5 comments, 352 reads

Posted in The Voice of the DBA on 29 October 2009

My Schedule for the PASS Summit 2009

For the most part, I have an easy schedule. I’ll be in the 600 hallway most morning after the keynote on one of the couches. Likely I’ll have a few friends nearby.

While I pop in and out of some sessions, I’m really there to meet people, catch up with… Read more

2 comments, 280 reads

Posted in The Voice of the DBA on 28 October 2009

How Many Rows Have Changed?

One of the things that I've asked DBAs, and I see asked often, is how much does your data change? That affects the transaction log sizes (and backups), the load on your server, possibly the tuning and specs you want to implement, etc. But most DBAs don't have any clue… Read more

1 comments, 1,370 reads

Posted in The Voice of the DBA on 28 October 2009

Deterministic Functions

Do you know what determinism is? It's something that comes up periodically in Books Online as various SQL objects require deterministic functions. Things like indexes views.

I ran across a question on this for our ASK site, and thought it was interesting. I started to reply, then had to double… Read more

1 comments, 855 reads

Posted in The Voice of the DBA on 27 October 2009

Expert SQL Server 2008 Encryption

Encryption is a tough subject, but it’s one that’s fascinated me for years. I downloaded PGP when it came out nearly two decades ago, and learned about the intricacies of symmetric and asymmetric keys. I thought it was fun, even when I couldn’t convince many people to consider using it. Read more

0 comments, 375 reads

Posted in The Voice of the DBA on 26 October 2009

One Week until PASS 2009

It's one week until the PASS Summit. At this time next week I'll be on a plane, heading to Seattle with a weeks worth of clothes and a bunch of prizes to give away. This will be my 8th or 9th Summit, and the 5th or 6th one I've attended… Read more

0 comments, 249 reads

Posted in The Voice of the DBA on 26 October 2009

Not Pointing Fingers - Microsoft and Sidekicks

Someone posted a note on Twitter about the Sidekick fiasco. Apparently the servers that lost data weren't Microsoft servers. They were actually Oracle, Sun, and Linux servers that were at a Verizon data center. Microsoft bought Danger last year, and when they had issues, they spent time and resources… Read more

1 comments, 277 reads

Posted in The Voice of the DBA on 23 October 2009

Opinions about PASS

There has been quite a discussion today on the direction of PASS (the Professional Association for SQL Server) and some controversy about the opinions, blogs, and whining (yes, someone said whining) that’s been taking place. I’ve certainly had my say, with an editorial and a couple of blogs on… Read more

5 comments, 221 reads

Posted in The Voice of the DBA on 22 October 2009

Transparency and PASS

I hate to start a blog war, but maybe there's one going on. The recent PASS 2009 election concluded a couple days ago and 3 new board members were elected.

That's 3 from 4 candidates, which is a little silly, IMHO opinion. As Geoff Hiten said in his PASS Fail… Read more

14 comments, 698 reads

Posted in The Voice of the DBA on 22 October 2009

Do You Trust Google?

I have a friend, he’s a technology guy and fairly savvy with hardware and software. We were talking recently and he said that he didn’t see the point in performing backups or even buying software for his machine anymore. He runs Windows and *Nix in various places, but uses GMail… Read more

3 comments, 342 reads

Posted in The Voice of the DBA on 21 October 2009

Old Inventory

Each year at the PASS Summit I have run a party on opening night. The last 4 or 5 years we've had a casino theme, with real dealers coming in and letting people try their luck at blackjack, poker, roulette, craps, etc. It's a good time, and we hand out… Read more

0 comments, 249 reads

Posted in The Voice of the DBA on 20 October 2009

Images in your blog

In a recent talk I gave, I recommended using images to spice up your blog. I think it's great, and I often include images in my posts where I can. I typically grab screen shots, or use pictures I have, but I have linked from the Internet.

However someone asked… Read more

3 comments, 252 reads

Posted in The Voice of the DBA on 19 October 2009

Shipping

I've got a conference to attend in a few weeks, and needed to get some things out the door. Every year we give away a lot of shirts and prizes at a party, and typically I have the person I order shirts from send them to the conference. However this… Read more

8 comments, 234 reads

Posted in The Voice of the DBA on 16 October 2009

PASS Board of Directors Debate - Transparency and Vision

There is an amazing debate occurring on Brent Ozar's blog where he interviewed Matt Morollo. Being a little out of touch this week, it's incredible to me there is so much passion about the election, but not so much on most other issues. Even the East Coast v West… Read more

5 comments, 589 reads

Posted in The Voice of the DBA on 16 October 2009

Dev Days

I heard about the Stackoverflow Dev Days earlier this year and thought it was an interesting idea. We had talked about doing a similar type event for SQLServerCentral, or even at my other company, SQLShare, but the logisitics and costs are substantial. As a way of researching the due… Read more

2 comments, 416 reads

Posted in The Voice of the DBA on 16 October 2009

Separating Out Indexes

I saw a post recently where someone was asking how to separate out all indexes from the data into a separate NDF file. This was the same post that I wrote about recently with the thread myth.

The poster seemed confused on a couple points. The first was that he… Read more

6 comments, 433 reads

Posted in The Voice of the DBA on 15 October 2009

Dev Days – Austin

I’m out of the office today, in Austin, TX (yee-haw!) at the Stack Overflow Dev Days – Austin. There are a few more around the country coming up, and if you’re a developer, I’d go check it out, just for the speakers. I’m not sure you’ll learn a ton… Read more

0 comments, 297 reads

Posted in The Voice of the DBA on 14 October 2009

Older posts