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 2010

Shopping

In about a week and a half, the SQLServerCentral opening night party takes place at the PASS Summit. And while I won’t be there, I’m in charge of the prizes that will be going out to everyone attending.

In the past I’ve usually done a couple big Best Buy trips… Read more

1 comments, 540 reads

Posted in The Voice of the DBA on 29 October 2010

My Bucket List

I actually built on in 1999 and called it a Life List. Over the years I’ve tried to work on the list each year, knocking off something, but I also learned something. I learned that as I grew, and my life was more enjoyable, some of the things on… Read more

0 comments, 531 reads

Posted in The Voice of the DBA on 29 October 2010

Overwhelmed, Stress, and Planning

It’s been a bit hectic this year. In fact, it feels crazy most weeks as I try to manage work, home life, and free time. More and more I have been having a night or two a week where I just want to lay in bed and watch some TV…

Read more

1 comments, 228 reads

Posted in The Voice of the DBA on 28 October 2010

The SQL Rally - Who Would I Vote For?

I was looking over the pre-conference sessions submitted for the SQL Rally event taking place next May in Orlando. I think it’s great that the community gets the chance to vote on the submissions and help decide what will be offered.

Note that you don’t have to attend the event… Read more

2 comments, 223 reads

Posted in The Voice of the DBA on 27 October 2010

Common SQL Server Mistakes – Functions in the WHERE Clause

This continues my series on Common SQL Server mistakes, looking at more T-SQL mistakes.

What’s Wrong?

If you saw a query like this, would you see a problem?

select
  o.OrderID
  , o.CustomerID
  , o.Qty
from Orders o
where datepart( yyyy, o.

Read more

3 comments, 1,260 reads

Posted in The Voice of the DBA on 27 October 2010

The SQL Rally Pre Conference Seminars

There’s a change in how pre-conference seminars are being picked for the SQL Rally event next year in Orlando, FL. You, as the people that may attend, are getting the chance to vote on which sessions you’d like to see.
Vote Here
You get to pick from seminars in various…

Read more

0 comments, 405 reads

Posted in The Voice of the DBA on 26 October 2010

SQL Server 2008 - CDC Retention

I had done a little work with CDC last year, experimenting with the way that it handles changes in your database. Someone had asked me the question about the retention period since the default of 3 days was not sufficient for their environment.

BOL lists the default retention period as… Read more

1 comments, 1,249 reads

Posted in The Voice of the DBA on 26 October 2010

T-SQL Tuesday Topics

I was asked to host a T-SQL Tuesday, and I accepted.

Once again, my fingers move a bit faster than my brain. “Sure, be happy to host one. Send me a date” flew out of my fingers before I thought through the implications. I’m happy to help the community, and…

Read more

1 comments, 245 reads

Posted in The Voice of the DBA on 25 October 2010

New Looks

It’s been quite a few years since I updated the Hawaiian shirt wardrobe. I bought a series of 5 shirts for TechEd years ago, having “SQLServerCentral.com” embroidered on each of them. I had 3 copies of each shirt, with Andy, Brian, and myself having a selection of shirts to wear. Read more

0 comments, 260 reads

Posted in The Voice of the DBA on 22 October 2010

SQL Saturday Advice - Extra Food

No matter whether you provide the food or have people pay for it, it seems that at every SQL Saturday I’ve attended, there is extra food left over. Sometimes it’s a very significant quantity. At one of the events I think there were over 50 boxes lunches left over.

You… Read more

1 comments, 234 reads

Posted in The Voice of the DBA on 21 October 2010

Boulder SQL Server User’s Group - Common SQL Server Mistakes

The first iteration of my presentation on Common SQL Server Mistakes, based on the various things I’ve seen in the forums over the years as well as written about on this blog, was last night.

It went fairly well, though not a lot of questions from the group and I… Read more

0 comments, 358 reads

Posted in The Voice of the DBA on 20 October 2010

Common SQL Server – Not Indexing FKs

This series looks at Common SQL Server mistakes that I see many people making in SQL Server.

Foreign Keys

It’s way too often that I see people building databases without including declared referential integrity (DRI) in their databases. Even when I see people setting a primary key on tables, it… Read more

1 comments, 543 reads

Posted in The Voice of the DBA on 20 October 2010

Database Mirroring Connection Strings - Automatic Failover

I saw a post recently from Hugo Shebbeare that reminded me of something that I’ve seen asked often on the forums. One thing that I preach to people is that they should use their blog to show what they know, and in this case I want to do that. Also,… Read more

1 comments, 3,461 reads

Posted in The Voice of the DBA on 19 October 2010

Copyright

This is actually amazing. A talk on what YouTube does with copyright and how they view it, from TED. It’s interesting, and there are two things in there to watch. Note, that I caught this link from Jeff Atwood (@CodingHorror) on his blog.

The first thing… Read more

3 comments, 261 reads

Posted in The Voice of the DBA on 18 October 2010

Kindle v iPad

I don’t have either, but I ran across this comparison on the devices. It says get both, if you’re a consumer of media and culture. To some extent I do think that it’s got a perspective that makes sense, and if you can afford a $500 iPad (or more),… Read more

0 comments, 247 reads

Posted in The Voice of the DBA on 15 October 2010

SQL Saturday Advice – Speaker Communication

Recently I was at an event and a speaker wasn’t able to make a session. There was a minor scramble, and the session ended up being cancelled, which is fine, but it got me thinking about what I would do if I had an emergency.

I don’t always have the… Read more

0 comments, 331 reads

Posted in The Voice of the DBA on 14 October 2010

Common SQL Server Mistakes – Equals NULL

One thing that I don’t see a lot, but it still happens with people new to SQL Server is the comparisons they’ll make with NULL values. Often those people new to T-SQL will write this:

select CustomerID, CustomerName
from Customers
where SalesRepID = NULL

The thought here is they… Read more

8 comments, 10,234 reads

Posted in The Voice of the DBA on 13 October 2010

Google Wind

I’m not sure Google is a better company than Microsoft or some of the other extremely large companies that get caught up in dominating a market. However they are engaged in some interesting projects, and I have to think that the founders, or someone high up in management is really… Read more

0 comments, 251 reads

Posted in The Voice of the DBA on 12 October 2010

T-SQL Tuesday #12 - Misconceptions

It’s time for T-SQL Tuesday again, and I’m happy to participate again. This is a monthly blog party started by Adam Machanic (Blog|Twitter )that asks people to write on a particular topic all on the same day.

This month’s theme is misconceptions in SQL Server, hosted… Read more

8 comments, 470 reads

Posted in The Voice of the DBA on 12 October 2010

Return Values from XP_CMDSHELL

Let’s be clear: I don’t recommend the use of xp_cmdshell as a general tool. It ought to be used when you have no alternatives, and you should carefully control access and what this can do. Opening a shell from SQL Server can be dangerous for your server.

That being said,… Read more

0 comments, 1,883 reads

Posted in The Voice of the DBA on 11 October 2010

Older posts