And post them here, call for votes. Those votes matter to the dev team.

I'd second Gail's suggestion of using an identity. It is easy to read and handles the concurrency.

You can use a GUID as well if you like, but those, IMHO, are...

I reinstalled Win 7 on my desktop and things appear to be working, so I'll likely be putting WHS on the old desktop in a week or so and I'll...

You can view the execution plan yourself in SSMS to see which indexes are used for the queries.

Read Gail's entries, and then test your queries. Look at the execution plans and see if the indexes are used.

You need to answer Brian's questions, but basically if you want to prevent someone from inserting,

- create a database role

- DENY insert on the table for the role

- add...

There are a few good presentations on MySpace. I bet their DBAs have an interesting job, but not much sleep.

Well, since I forgot about Database Weekly, I am :w00t:

I'd argue, Jeff, we can do both.

Tune us an OS server on a core installation, and also improve the language. I bet some of your items might be voted up...

Congrats, Roy, and great job!

Great analysis, GSquared, but it also means that we are assuming that the botnet doesn't get a hash of the password.

To me that's the bigger danger. A backup tape...

You can do this in EM or via T-SQL

BOL: http://msdn.microsoft.com/en-us/library/ms190794.aspx

Articles: http://www.sqlservercentral.com/articles/Administration/attachanddetachagain/656/

The one thing you need to be aware of is that it doesn't move logins. It moves users, but they'll...

And leave their bow,...

The switch I mentioned is the only way I have seen that work, and that's only if you can co-locate the data in one system. Other than that, there's no...

You can't calculate growth unless you know the load. The easiest way to guess this is look at the backup sizes over time. See if they are changing and extrapolate....