The problem with going with stored procedures is that you'll have an exception somewhere and that will cause problems. If you can tightly control development, this can work, but it...

Hugo,

Thanks and good seeing you last week.

Didn't think about those parts being optional when I reviewed this. I kind of glanced at it and took those to be valid options.

The...

One more thing I might mention here.

Don't feel bad about missing a session. If you get busy or get into good conversations with people, especially MS people, skip a session....

I think CU6 was stable on clusters, though I haven't heard a lot since then. You might email Geoff Hiten, SQL MVP that does a lot with clusters.

I would go...

I'm with Gail and Lynn.

I had to do this and it was hard, but I got management buy in, created Windows groups and assigned permissions (DBO, not SA) and then...

The SAN drives are just other disks to the OS. You can have some MDf/NDF/LDF files local and some on the SAN, though I wouldn't recommend it. I'd start migrating...

Great summary and I'll be writing one to post as well.

Talk to everyone. Sit next to new people at lunch, get to know them, ask them what they do. I...

ZBB is how I always did things, looking back at last year only to ensure I was covering costs or estimating expenses properly. It is a pain, but it should...

Wow, that's a lot of code. Posted a hint to a derived table article.

That's a lot of code.

Derived Tables - http://www.sqlservercentral.com/articles/DerivedTables/61388/

You might need to make two updates if you can't get it done in one. Gail has given you good hints, and you...

I think SQLCompare (Red Gate) will do this. There is an option to compare to a backup file.

You might be better off importing the entire file into a table with one column, one large varchar, and then searching through for this line, if the format is there....

The best thing I can recommend is to read some books and articles, and look at how people design things. We have a few here and be sure to read...

First, is this SSRS? Reporting Services? Please post in those forums.

Second, you show 12.16 as a result and then say you want 12.16. Am I missing something?

Lee,

GP still won't switch automatically to the mirror, correct?

If you move the logins, use sp_help_revlogin from MS to script out the logins with the correct SID and passwords.

Not sure about...