This thread feels like a Twitter stream.

Bruce,

That is how I'd do it as well, but does that guarantee there can't be a collision? Could not two people potentially run the SELECT and IF NOT EXISTS at...

We are supposed to get 1 dev/week a month, and we are looking to hire 1-2 devs to work on the sites (Simple Talk and here) regularly.

Not sure where this...

OK, new avatar. This is what I ask myself when I look in the mirror.

It doesn't always return 1. If you were to collide on concurrency, both insert a Userid = 1, then you'd get 2, then you'd know there's a collision.

However, can you...

You can't drop the certificates and symmetric keys.

You need to slow down and carefully understand what is happening. When you create encryption, you

1. Create DMK

2. Create certificates/asymm key protected...

And Grant like his?

Actually it wasn't that cold. This Fridays' podcast was shot then, in a T-shirt, outside. I was a little cold, but not unbearably.

You can use a maintenance plan with only a maintenance cleanup task to delete backups.

I think we agree, and you've stated it better than I did.

Logged as a bug

If you look at the properties for a table, you'll get a list of the fields.

If you look at the properties for a database, there is a "size" and a...

Use R1/R10, not 5.

Go with a major vendor, stick to what they recommend with the server to eliminate driver issues.

Is it the same code?

I'd double check that you have the same key, maybe restore it again. Someone could have regenerated something. Or you might need to restore it each...

I'm not sure I agree with Gus about next year, but I could be wrong. There's still a substantial premium for drives.

I bought a 1TB drive for US$147 yesterday. A...