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: June 2008

More Kindle

 I'm still on the fence here about a Kindle. I pinged someone that bought one and he said they're returning it. Not that they don't like it, but his wife reads too much now, so she's spending more $$ and they'd like to slow down. Also, he doesn't see enough… Read more

0 comments, 505 reads

Posted in The Voice of the DBA on 26 June 2008

One Note - Part II

 Apparently other people like One Note. Microsoft is using it for learning content, and I think that's a cool idea. I might find some issues with that over time, but at first glance I think it's a good idea. Read more

0 comments, 496 reads

Posted in The Voice of the DBA on 25 June 2008

One Note

Lately I've been trying out a few new pieces of software to see how well they work. One is Twitter, and if you're really interested, you can follow me there. A few people do, though I'm not sure why. I follow a few people and might cut my list down… Read more

0 comments, 694 reads

Posted in The Voice of the DBA on 20 June 2008

Asking a SQL Question

I've been a little surprised lately by some of the questions I've seen in our forums at SQLServerCentral.com with questions that weren't questions. I've seen people post things that make it hard for people to help them. Among those items:

  • statements, and never really ask a question.
  • An error message…

Read more

4 comments, 601 reads

Posted in The Voice of the DBA on 18 June 2008

TechEd - Execution Plans

Randy Dyess of Solid Quality Mentors had a session and since I'd just gotten a copy of Grant Fritchey's book with the same name, I wanted to check it out.

There are 3 types of plans: graphical, text, and XML.

Graphical is cool, looks good, but it doesn't have enough… Read more

0 comments, 247 reads

Posted in The Voice of the DBA on 13 June 2008

TechEd - Day 3

I left my laptop at the Red Gate booth, and then managed to wander up to a Data Compression talk from Sunil A. from Microsoft. It was a great presentation, and despite some extensive reading and researching earlier this year, I learned quite a bit about how it works. There… Read more

0 comments, 225 reads

Posted in The Voice of the DBA on 12 June 2008

TechEd - Query Performance

A program manager asked the question at the start:  Who's had a query performance issue where a query "went bad" on the server?

Lots of hands up, and that was one of the things I wanted from this session.

What's reliability? MS sees this as two things

 - Quality: Given… Read more

0 comments, 386 reads

Posted in The Voice of the DBA on 12 June 2008

TechEd - Data Corruption

I went to this one, mostly because I don't understand coruption that well and Paul Randal is a great speaker. Worth going to see him if you get the chance. 

Run CheckDB. It's important.

You need to know how long checkdb takes to run. Checkdb is optimized to run for… Read more

0 comments, 561 reads

Posted in The Voice of the DBA on 11 June 2008

TechEd - IO and Wait Stats

Andrew Kelley, SQL Server MVP, is a good speaker, so I'd recommend his sessions if you want good technical information.

IO Stats are a snapshot in time since the instance was restarted, so you must have at least two reads to compare the data. Stats are a snapshot. They are… Read more

0 comments, 1,406 reads

Posted in The Voice of the DBA on 11 June 2008

TechED - Building an SOA Data Center

Talking about heterogenous systems, usually legacy systems. How do you move to a new architecture?

You must start with the old systems, often you cannot throw it away and need to mitigate the risks of migration to newer systems. One way of doing this is to rip out the presentation… Read more

0 comments, 218 reads

Posted in The Voice of the DBA on 10 June 2008

TechEd - Designing a Global Database

I was going to hit a Powershell lab because the Scripting Guys at TechNet write great columns, but it filled up, so I went to my second choice: Building  a Global Database.

 

What does this mean? If you are building a database that handles all types of languages and… Read more

0 comments, 529 reads

Posted in The Voice of the DBA on 10 June 2008

Building Software is Like

I still remember hearing an executive in IT at Virginia Power start a sentence like this, and he went on to say it's like a house before chastising the developers for being slow. I was on the ops team and liked the analogy, finding it funny. Course I hadn't done… Read more

0 comments, 217 reads

Posted in The Voice of the DBA on 6 June 2008

Know Your Equipment

Today I ran to the co-location facility for FourDeuce and End to End Training, to upgrade our database server to SQL Server 2005. We've been wanting to do it for awhile, but since most of our SQL code is fairly simple and generic, we haven't needed it.  The old SQL… Read more

0 comments, 203 reads

Posted in The Voice of the DBA on 5 June 2008

A New Logo

For SQL Server, it's coming soon. Surprisingly, when I was up in Redmond, quite a few people were asking about this, and wanted to have a new logo. I somewhat agree that the old logo was a little tired and it would be good to see something new.

I saw… Read more

0 comments, 204 reads

Posted in The Voice of the DBA on 4 June 2008

DIY

Last month the LCD screen on our treadmill went out. We bought it last Christmas (06) as a present for my wife and I and with all the snow in 07, it was a nice addition to the household, letting us work out with bad weather outside. However the LCD… Read more

0 comments, 200 reads

Posted in The Voice of the DBA on 2 June 2008