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 2007

Walking the Line

I have the best job here at SQLServerCentral.com. I work from home, I get to be creative, writing about what I want to write about and work on my own schedule. I've gotten free admissions to the PASS Summit, TechEd, and the MS BI Conference and been offered others.

However…

Read more

0 comments, 557 reads

Posted in The Voice of the DBA on 28 June 2007

Keep a Spare

I wanted to get working on Katmai a little, but not being brave and seeing the release notes that it can't run side by side with SQL Server 2000 (who decided that?), I wanted to put it in a VM.

So I fired up Virtual PC, created a new VM,…

Read more

0 comments, 527 reads

Posted in The Voice of the DBA on 20 June 2007

Back to Work (Some days it flows)

My job here at SQLServerCentral.com is mainly as editor. This means that for the most part I edit articles, schedule them for release, work with authors, build questions of the day, correct mistakes in questions of the day, and of course write editorials.

Last week I was on vacation, so…

Read more

0 comments, 573 reads

Posted in The Voice of the DBA on 20 June 2007

Katmai Manageability

The database manages itself. Not totally, but close to it. It was an analogy made by Dan Jones with cars. Auto shop isn't really offered in high school anymore, people don't "tinker" with their cars much anymore.
If this is true, we have more time for data design, data architecture.…

Read more

0 comments, 594 reads

Posted in The Voice of the DBA on 6 June 2007

SQL Server 2005 Security

It's a similar theme, off by default if it makes sense, minimize surface area.
Recommendations: for new installs, leave stuff off unless you need it. Minimize connectivity. for upgrades, turn things off if you do not truly use them.
SQLSAC - Surface Area tool, launch from command line or setup.…

Read more

0 comments, 597 reads

Posted in The Voice of the DBA on 6 June 2007

Southern BBQ

Last night I went out with Tony Davis of Simple Talk and Alan White, a longtime author for both here and Simple Talk. After satisfying their need for microbrewery beer, we ended up at a Southern BBQ. They enjoyed it, despite having to join me in choking down American beers.

Read more

0 comments, 571 reads

Posted in The Voice of the DBA on 6 June 2007

DBCC Internals

CHECKDB
- needs consistent view of the db. Needs to do this without locking. In SQL Server 2000 log analysis is used. Almost everything is logged and once the database is read, the log is read and inside checkdb, recovery is performed to reconcile the differences. If there was a…

Read more

0 comments, 695 reads

Posted in The Voice of the DBA on 5 June 2007

Beyond Relational

I missed this yesterday, but I saw it on the schedule again, and I knew I had to make this one. It's titled "Beyond Relational", which I expect to mean it's focused on enhancements not necessarily related to rows and columns. But I didn't see the abstract, so I'm not…

Read more

0 comments, 635 reads

Posted in The Voice of the DBA on 5 June 2007

Maintenance in SS2K5

Andrew Kelley from Solid Quality Learning did this one, which was good. I was worried it would be about maintenance plans, but it wasn't. Instead it was on good real life maintenance for your server and how to handle it. He did start out talking at the Maintenance Plans abstract…

Read more

0 comments, 618 reads

Posted in The Voice of the DBA on 5 June 2007

SQL Server Always On

Everyone wants 5 9's of uptime, 24x7 support, and instant fixes for issues with their database server. Never mind that I'd argue that most DBAs don't really need the "Always On" technology, but it's something that sells. So I thought Kim Tripps "Demo Fest" would be a cool…

Read more

0 comments, 898 reads

Posted in The Voice of the DBA on 5 June 2007

SQL Server 2005 Tools

A good talk on the tools from the guy that's responsible for SSMS, Configuration Manager, Maintenance plans, Surface Area Configuration Wizard, and a few more.
Initially I thought this might be a dud, with him showing some of the basic features of Configuration Manager and Surface Area tools,but then he…

Read more

0 comments, 208 reads

Posted in The Voice of the DBA on 5 June 2007

Reunion

We're not partners anymore in SQLServerCentral.com, but Andy, Brian, and myself got together last night for dinner. We haven't seen each other since the PASS Summit and this was a good time to get together. We had a nice dinner, reminiscing about the site a bit, them giving me some…

Read more

0 comments, 228 reads

Posted in The Voice of the DBA on 5 June 2007

Working Afternoon

I ended up driving around Orlando this afternoon to get books. We'd printed the next version of our Two Minute SQL Server Stumpers and I'd had it shipped down to a friend's house. He didn't make it down to TechEd, so I drove up and picked up the books. So…

Read more

0 comments, 201 reads

Posted in The Voice of the DBA on 4 June 2007

First Session

I dropped into Brian Knight's "Clustering in 60 Minutes" to say hi. If you've never seen this, it's pretty cool and worth the watch. Brian makes clustering look pretty easy, and he really sets up a cluster in the session from scratch, so check it out. It's updated for 2005,…

Read more

0 comments, 183 reads

Posted in The Voice of the DBA on 4 June 2007

Tech Ed - Keynote

These will get pretty long as I'm kind of wordy, but these are impressions as things are occurring.
Registration is a little crazy. I'm not sure who desgined this conference, but it's split among the two sides of the conference center in Orlando. I've attended 3 or 4 Tech Eds,…

Read more

0 comments, 236 reads

Posted in The Voice of the DBA on 4 June 2007