Use dateadd and datepart.

Looks like a compilation error, not one connecting to SQL. What platforms are you using?

Are you trying to get users to run it from another DB?

Gail has a great solution to limit vulnerabilities.

Moved to a better forum.

A PK is used to uniquely identify a row. If you need 2 (or more) fields to do this, you have a composite or compound key....

They should always have been important, but I think their relative value diminished relative to skills and certifications for awhile.

I'd argue it's ignorance on the part of managers.

They're looking at time = productivity, and then they're the same ones that complain that people don't get enough done when they're...

I hear you, but how do you balance that with work calling you at home?

I think we have to get past the "hours worked" in IT at least, and perhaps...

Authors get copies, I'll send out copies to those, uh, slackers that don't make PASS when I get back. 😀

They're all here, have to ship them back to Denver. Cutoff...

Anonymous post:

I am a Sr DBA and data architect. The number of hours I actually work depend on my position/contract and the day. Sometimes it'a even less than an hour,...

Anonymous response:

Steve,

I've been subscribed to your newsletter for about 6 months now and enjoy it quite a bit. I am the Systems Architect for a medium sized online and...

Anonymous post:

On a slow day I work 8 hours. I usually feel like I get very little accomplished in those 8 hours and those hours will have to include...

:), I'd love to resell these, having a few issues with Amazon. We've pulled them off the site as well for now.

Red Gate is using most of these as marketing...

Thanks for the comments and it's interesting to see what people think.

As I read through these, I think I might actually be more efficient than I expected. If I start...

I actually am writing about this next week, or I guess it's already written for release while I'm at PASS.

It doesn't make sense in the short term, for this system...