David,

I also have a calendar table in our production system and it performs very well and it makes our code consistent across the board. I agree there are many ways...

Thank you

Jeff,

I got side tracked for the last few weeks. It is almost done. I should have something to you by the end of the week.

Thanks

Patrick

Here is a simple little script with all the options of loginproperty against all logins.

SELECT name AS LoginName

,loginproperty(name,'BadPasswordCount') AS BadPasswordCount

/* Returns the...

Good question, I haven't used loginproperty for a long time and had totally forgotten about it.

Thanks Jeff, I'll send you an email when it...

I'll take this one.

Jeff, thank you for the kind words. This is my first article, and I found out that coming up with a good title is more difficult than it seems.

Being chained to my desk

Makes my work not the best

I can’t really enjoy my lunch

When I get paged saying my server is on the verge of a dump

A happy employee...

At my work the cubicals are so small that I can see over them while sitting down. There are 5 people working within 5 feet of my desk, so music...

Submitted

I would like to give this one a shot.

I find schemas extremely useful. We have a couple of user groups that need access to manually run some stored procedures. We created these in a separate schema. That way...

My hobby is to go camping and hiking, and yes I would do it for a living if I could. But I don't think my wife would be too thrilled...

We just started doing quarterly reviews at my company. Part of the review includes going over the goals that the manager set for each person. It was a nice idea,...