My question is why do you care about the column order?  Yeah, I know the replication add column procedure adds something onto the end of the table, but if you're...

I cannot see where having machine code access would have helped me in any job I've worked in.  In all of the situations, the worst offenders as far as speed...

Yup, start out as a developer, and branch out from there.  Do your homework and such on databases on your own and start volunteering for stuff database-related.  It'll probably take...

Okay, the odd vs. even numbers thing sounds like it's prone to failure.  When transactions are rolled back, the identity number reserved by that failed new entry is still filled,...

I agree, transact sql isn't meant to be used this way.  What are you using as a user front-end for the database?  Microsoft Access?  Whatever you're using as the interface...

Yup, it's something called double-hop authentication.  SQL Server can talk to the linked server through it's own context, but when it tries to pass your NT authentication from your computer,...

yup, use linked images or set up a crystal reports server and go from there.

Yeah, as far as I know, the position of the column is irrelevant to the database engine.  It only looks good when you have everything grouped together in a data...

I do not believe so.  You only need to worry about licensing on the server side, whether that's going to be per processor, concurrent user, or named user.  Just make...

Good to know, and thanks for sharing.  Yeah, ERwin always seemed like crap to me.  If you're going to pay a lot of money anyway, ER Studio is probably the...

Embarcadero ER Studio is awesome if you can afford to spend the $3k on a data modeling tool.  I tried Erwin, and Powerbuilder as well, but didn't like those nearly...

Definitely a political problem.  I work in an environment where the top level managers used to have network admin rights.  After we explained to them the need to remove these...

Yeah, there's no way to do it directly.  I've discovered that Visio Professional, has a nice database reverse engineering wizard.  It seems to do a better job at database diagrams...

One thing to watch out for:  Our developers used access identity fields.  This is normally fine, but they used randomly generating identity fields instead of sequential ones.  SQL Server uses...

My only real gripe about differential backups is that they aren't included in the database maintenance plan wizard.  I guess I do need to install yukon and see if that...