Good article. Interesting points. I've been at both extremes of the scale at large & small companies. Heck, I even went through the management change at a large company where...

You mean something like this?

SELECT DATEPART(month,t.SalesDate) AS Month,SUM(t.SalesQuantity),SUM(t.SalesAmt)

FROM tmpsalestarget t

GROUP BY DATEPART(month,t.SalesDate)

ORDER BY Month

Or are you trying to get them by day (1-31)?

Retire? What the heck is that?

I don't know that I can "retire" from being a geek. Even if I stop earning a living working with computers, I'll still be doing...

I have to agree. I'm stuck between option 2 & 3 (with occasional forays into 4). Since defaults aren't readily visible to the developers working on stored procs and since...

Neil Armstrong. I watched him walk on the Moon when I was 6 and it made me crazy for science (and science fiction). I tried to follow in his foot...

I'm going with the DBA answer... it depends.

Microsoft showing us how well mirroring works, I want a live demo, crashes & all. If it's really going to slice, dice...

I occured to me that I have at least one anecdotal story that may point to  how the editorial  policy may be applied. I wrote an article for Simple Talk...

As to how independent should you be, how independent can you be. I'm not talking about Red Gate, I'm talking about Microsoft. Personally, where Microsoft leads, I follow. Not because...

Go here, read.

http://www.sqlservercentral.com/columnists/pressrelease/2696.asp

I agree that it was overall a pretty lame presentation. I also thought the questions were silly considering the audience. Seriously, at PASS, who cares about Linux? However, I want...

I'm working for an international company. All the databases we've created in the last five years have been using unicode to support the languages we'll need in the system. There...

Absolute best wishes for the future guys. You've done extremely well with this place. It's become a go-to point for my own growth & knowledge.

I have to say I'm sorry...

Late to the game and it's a story I've told before, but, it was a heck of a nightmare.

I was working for a start-up that had a bunch of Harvard...

TRUNCATE LOG ON CHOICEPOINT

Ok, sorry, couldn't resist.

Same thing we do. As someone else said, you can't expect someone to have every aspect of the details of your own development & design process down walking in from...