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: March 2010

The Vacation Crash

The family returned back from the UK last night, after traveling for something like 14 hours, plus an early morning wake up. I was up at 5am, GMT, for a 9am flight. Got to Denver around 5pm MST, and then it took a couple hours to clear customs, luggage, etc.… Read more

3 comments, 609 reads

Posted in The Voice of the DBA on 31 March 2010

Home

And glad to be back in the US.

Read more

3 comments, 556 reads

Posted in The Voice of the DBA on 30 March 2010

Red Gate and Hyperbac

Imagine my surprise when I arrived at the Red Gate offices Monday morning to find Jeff Aven at the office. I had a double take since Jeff is one of the founders of Hyperbac, and since Red Gate has SQL Backup, I’m surprised that Jeff was even allowed in the… Read more

8 comments, 971 reads

Posted in The Voice of the DBA on 25 March 2010

A Fan and a Friend

I went to the UK SQL Server User Group in Cambridge on Wednesday. I’m not sure it’s the Cambridge group since they seem to move it around at times, but this time it was at the Red Gate offices, so I stuck around to see who showed up and how… Read more

1 comments, 237 reads

Posted in The Voice of the DBA on 25 March 2010

Meeting Offsite and a Little Vacation

I’m heading to our “publishing summit” today at one of the Cambridge University buildings. I’m a part of the group that brings you SQLServerCentral, Simple Talk, various books, and probably other stuff I’m not aware of. Not sure if the PInvoke site is owned by us, but… Read more

1 comments, 251 reads

Posted in The Voice of the DBA on 24 March 2010

Why I Don’t Run for the PASS Board

It’s getting close to that time of year when you can apply to run for the PASS Board of Directors. Each year we have 3-4 openings that need to be filled as the current board members move on. Last year there was a bit of controversy when Tim Ford applied… Read more

12 comments, 519 reads

Posted in The Voice of the DBA on 24 March 2010

Inserting into an XML document

I was reading through the latest XML Workshop article that I have from Jacob Sebastian. It’s a fantastic series for learning little bits of XML as you go and I’ve tried to read through most of them and learn something. I’m not a big XML guy, but I am trying… Read more

8 comments, 846 reads

Posted in The Voice of the DBA on 23 March 2010

Plagiarism Again

Update: The problem posts have been removed from the SQLTechConsulting site.

I ran across a note from Brent Ozar (blog | Twitter) on Plagiarism, Inspiration, and John Dunleavy yesterday, having missed what looks like an interesting Twitter discussion since I’m halfway around the world from where I usually… Read more

18 comments, 529 reads

Posted in The Voice of the DBA on 23 March 2010

Be Responsible in your blogging and posting

I have been awarded the MVP award from Microsoft a few years in a row and it’s an honor, but it’s also a responsibility. One of the benefits from the award is that I get information about what is coming up in products, often under an NDA (non-disclosure agreement). That… Read more

0 comments, 249 reads

Posted in The Voice of the DBA on 22 March 2010

Losing Two Days

I’m off tomorrow to the UK for a week of work at the Red Gate offices, and then a couple days of vacation. My oldest is graduating from high school this year, and as a present, we’re taking him and the rest of the family to the UK for a… Read more

2 comments, 217 reads

Posted in The Voice of the DBA on 19 March 2010

Be Wary

We make mistakes when we publish things. It happens, and I am as guilty as some people of mistakenly putting something down on paper that isn’t correct.

Or worse in SQL Server, put something down that applies to one version, and it gets superseded. I don’t usually go back and… Read more

1 comments, 250 reads

Posted in The Voice of the DBA on 19 March 2010

This is Dumb - eBooks

Amazon v Apple, both pressuring publishers on ebook concessions. It’s big business, and it could easily be good or bad for consumers.

Should we have some regulation here? Is the public better served in any way if books are limited to some retailers and not others? Deals have been… Read more

0 comments, 306 reads

Posted in The Voice of the DBA on 18 March 2010

Changing Storage for your SQL Server

A friend pinged me the other day with a question on SQL Server storage. He works as a Windows consultant, a fairly high end Windows/Hyper-V/Exchange guy, and knows a lot. However he likes to double check his plan with an area expert, which in this case was me. It’s a… Read more

9 comments, 861 reads

Posted in The Voice of the DBA on 18 March 2010

SQL Saturday – A Few Lessons for Future Events

I’ve been to a few SQL Saturdays, and while most have run smoothly, I have a few comments on a couple issues I’ve seen multiple times that might help others.

Signage

In every event that I’ve attended, SQL Saturday or Tech Ed, the majority of people don’t really know the… Read more

4 comments, 273 reads

Posted in The Voice of the DBA on 17 March 2010

Tracking data about your instances

I saw a post recently asking how to build a daily report for each instance that tracks the metrics deemed important. My response was this:

  • Create small db on every instance to hold data.
  • write scripts to gather metrics, separate table for each metric. Use a separate job to schedule…

Read more

5 comments, 225 reads

Posted in The Voice of the DBA on 16 March 2010

Volunteering for PASS

I said I was going to do it last year, and I followed through. After submitting an application to volunteer, I was picked to help on the Spotlight/Pre/Post Con committee, so I’ll be helping to pick which sessions and topics are going to be available for those sessions.

I’m looking… Read more

1 comments, 295 reads

Posted in The Voice of the DBA on 15 March 2010

No Green Compromises

I saw this blog about an Accenture survey of potential car buyers. It mentions that people likely won’t buy a green car unless it is superior in every way to a gasoline only car. The blog tends to lean towards the side of someone that doesn’t like hybrids. There’s… Read more

5 comments, 289 reads

Posted in The Voice of the DBA on 12 March 2010

Don’t Be a Shock Jock

  One of the dangers of being an “Internet Journalist” or even just a blogger, is that you might compromise who you are to attract readers.
Or in the case of your “modern resume,” impress someone for a new job.
Here is case of someone losing control of their ethics

Read more

2 comments, 491 reads

Posted in The Voice of the DBA on 12 March 2010

Maintenance Plan Issues

I think maintenance plans were a great improvement in SQL Server 2005, with a more visual designer and the ability of the DBA to chain together whatever tasks they wanted.  Service Pack 2 brought some enhancements, and a few bugs, so I’d recommend that you apply SP3 to your servers… Read more

0 comments, 361 reads

Posted in The Voice of the DBA on 11 March 2010

The Key at SQL Saturday #33

For the handover of SQLSaturday to PASS, Rushabh Metha, President of PASS, came to the Charlotte SQL Saturday, where Andy Warren and I handed over a symbolic key. It was at the end of the keynote, and fun for us, though I’m not sure that many of the attendees thought… Read more

1 comments, 282 reads

Posted in The Voice of the DBA on 10 March 2010

Older posts