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

A Moment of Silence

Today is the anniversary of one of the worst attacks in the US, the September 11th attack on the World Trade Center. I wanted to pause my blog to remember the people who lost their lives that day, many of whom were innocent workers in downtown New York City. Read more

2 comments, 110 reads

Posted in The Voice of the DBA on 11 September 2009

Don't Make Me Work, VIA Rail

I got an email the other day from Canada's VIA Rail, advertising "Discover Canada by Train" and the chance to save up to 70%. When my son was younger he loved trains, and one of the videos he had was of a train trip on VIA rail across Canada.… Read more

6 comments, 345 reads

Posted in The Voice of the DBA on 10 September 2009

Be Careful of Facebook

Even the President thinks so! In his talk yesterday, he warned kids about Facebook, and being careful what they should post. It’s also what I talk about in my branding and blogging talks, be careful what you post.

However it’s not a permanent thing you can’t get over.… Read more

4 comments, 385 reads

Posted in The Voice of the DBA on 9 September 2009

Writing a Technical Article – Where to Publish

This is part three of a series on writing a technical article. The advice might apply to non-technical articles, but I’m focusing specifically with my examples on technical pieces. Other parts are listed at the end of this article.

One of the ways to really enhance your brand and show… Read more

5 comments, 1,469 reads

Posted in The Voice of the DBA on 9 September 2009

Moving your database to a new server

We've had a few articles on how you move databases, but it seems that there are always new people using SQL Server and they end up posting a question because they aren't sure how to do something.

The other day I ran across someone trying to copy their database to… Read more

2 comments, 133 reads

Posted in The Voice of the DBA on 8 September 2009

Expense Reporting

I got a $25 app card with my iTouch, and forgot about it. However when we had guests over last night they had a great iPhone game, and Delaney loved it. He asked me to get it, so today when I was looking for a charger, I found the card,… Read more

0 comments, 91 reads

Posted in The Voice of the DBA on 7 September 2009

Running with more permissions

Recently someone was asking how they could execute some ALTER DATABASE commands without requiring sysadmin permissions. This person's company didn't allow sysadmin to be granted to non-DBAs, and they had to recover a series of applications and wanted to do that with some type of application setup instead of scripting… Read more

0 comments, 118 reads

Posted in The Voice of the DBA on 7 September 2009

e-Readers - $50?

I don’t think this survey was done well. Most people want an e-reader for $50, according to the survey. That’s the price at which they’d buy one. However I disagree with that. People purchased iPods at $200, and I’m sure some people would do the same for e-readers, but… Read more

0 comments, 198 reads

Posted in The Voice of the DBA on 5 September 2009

Amazon Finally Making Good on 1984

They should have done this on day 1 of the issue: offer users a legitimate copy and move their annotations. I’d like to say this didn’t bother me, but it did, and it definitely made me re-think the complete lockdown Amazon has.

It’s also one reason that I like… Read more

4 comments, 168 reads

Posted in The Voice of the DBA on 4 September 2009

A Great Business Model

Tia and I were moving dirt around the ranch this weekend. It was a chore that needed to be done, and we had some time to do it. Nothing was scheduled, no kid or family commitments, on a Sunday afternoon.

While we were working, a strange car drove up, and… Read more

3 comments, 103 reads

Posted in The Voice of the DBA on 4 September 2009

Warming up Analysis Services with Preallocate

With Windows Server 2003 many people found that Analysis Services (SSAS) was slow to get going sometimes. So a preallocate setting was introduced that allows you to specify the initial memory setting that SSAS will get when it starts. This setting is a percentage of the total memory, and you… Read more

0 comments, 822 reads

Posted in The Voice of the DBA on 3 September 2009

Building a Better Blog

I had a great session for the 24 Hours of PASS on Building a Better Blog. Not sure how well the other sessions went, but I got lots of nice comments via email and Twitter at the end. I don't know when PASS will get the recordings live on… Read more

4 comments, 212 reads

Posted in The Voice of the DBA on 2 September 2009

How practical is a netbook?

I’ve I was having lunch with another SQL Geek and we were talking about netbooks and how practical they are. Is it worth getting one if you have a laptop, especially if you have to pay for it yourself. It’s only $300-400, but that’s not an insignificant amount of money.… Read more

18 comments, 687 reads

Posted in The Voice of the DBA on 2 September 2009

Building a Pipeline

While I try to write most days, I don’t always podcast, and I only schedule things a day or two in advance. I try to stay flexible, and I tend to pick the editorial based on how I feel, what is happening in the world, and what is being discussed… Read more

2 comments, 121 reads

Posted in The Voice of the DBA on 1 September 2009

Indexing HierarchyID

The new HierarchyID datatype in SQL Server 2008 has captured my interest lately. I’ve been working on a presentation that I can give to some local user groups, and hope to have it done soon. As with other data types, an index can be built on this column to help… Read more

3 comments, 1,553 reads

Posted in The Voice of the DBA on 1 September 2009

Newer posts