I couldn't agree more! But I guess I'm wondering how a person finds a job that they can really enjoy. Looking for a job is a lot like...

I have to agree with Blandry - I left a company that was everyone trying to protect their kingdoms no matter who they stepped on. Everybody is afraid of...

I personally have used the ranking functions quite a bit lately not to just remove duplicates but to be able to qualify what is removed. In one case, I...

I've got to agree with another person that said ROWE will never be accepted. Most of the managers I've had are control freaks that need to be able step...

After reading posts of other people and reading some of the information on line, I often feel like I'm getting left in the dust. After reading a post, sometimes...

Great article. I've used ROW_NUMBER() in CTE to evaluate (compare) data in the previous rows or next rows. It was a real life saver. 🙂

I agree with ubeauty. SSC is a great resource for me. I can't really think of anything that needs to be added.

I've used data integrator. It is pretty decent but I can tell you that the learning and support resources for SSIS are far greater. I've always been able...

Well, I certainly agree that performance reviews once or twice a year should be done away with. Anymore, performance has nothing to do with quality and/or quantity of work...

I agree with steveb. I have the book he is mentioning - SQL Server Integration Services from Wrox and it is great. I used it to learn a...

Great articles, Paul. Very clear and complete explanations and examples.

Some people tell me that I'm lucky to have a job. That's okay but doesn't really get me to go the extra mile. I guess as far as...

I'm going to agree with Jeff M. There are many trial/evaluation editions of software out there and you can buy SQL Server Developer Edition fairly cheap. A...

I agree. I believe that we need more opportunities to find answers to questions/problems that we really can't find anywhere else. I encounter new challenges and problems everyday...

Very handy and nicely done article. I've come across situtations where I've needed to manipulate dates and will definitely keep this article handy. 🙂