Any subjects are fine. Beginner articles always get reads, nichey ones look great and make the site wider.

If there's something you see a lot, write about it. If you're interested...

Moved to administration. Please post in the appropriate forum.

You can trace this with Profiler and capture information. Once you track down the statements that are causing issues, you can look...

There are a lot of changes. Go to BOL and look at the What's New section

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

http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

There are lots of scripts on this site (See the scripts link on the left) that you can moidfy.

I hadn't thought about the repetitive motion thing. I guess long term it could be, but for presentations, they're an hour or two. I wish I could have swiped at...

It's not quite clear what you are doing here, or how you want to use this. We also like to see you do some work, show some effort in T-sQL...

T-SQL doesn't have a way to do a conneciton. You can use T-SQL to set up a Linked server, which then you can query through, but you can't open directly...

Closed to prevent replies

I stumbled on this one last week: http://www.devx.com/dbzone/Article/40531

Once you restore to a 2008 instance, no matter where the backup is from, the structure changes. Therefore you cannot back it up...

db_datawriter would give them insert (and update/delete) permissions. Check all the groups, look for DENY as ADI mentioned, and let us know which roles the user is a member of.

As Perry mentioned, you can have multiple instances and an upgrade will target one. Someone would have targeted one and the others would remain untouched. That's the idea of instances,...

There's still an Informix building here in Denver, pass it at times. It's supposed to be a great DW engine.

http://www.sqlservercentral.com/articles/1084/

Sue moved over to PM'ing full time, not really much SQL Server last year. I actually was thinking to send her an email and see how she was doing as...