As ALZDBA pointed out, you might not want to change the connection. There shouldn't be "users" in a package, but logins that point to a particular server. If you want...

Blocking is not bad. It's a sign that you have concurrency issues and the server is preventing someone from reading while data is being changed.

I'd use Profiler and really dig...

I could see allowing duplicates in a table for some reason, but you'd still want a PK in case you ever needed to work with a row. Even in a...

Not a lot of T-SQL, or guess if code is correct. There are lots of questions on SSMS, where you have a simulated environment and need to do something like...

Typo, fixed now. The $10-20k they see as a investment (for technology, not people), makes it easy to decide to do. Of course they already believed in having a good...

the Dynamic SQL above is really the only way to do this. the IN statement can't take a bunch of parameters or a comma list by itself.

Be sure when you...

In that case, restore it as master_old or some other name, not as "master" on another instance. You just want the data in the tables, not the functionality.

It's not that specific, but it's a nice summary, Rudy.

I like it too!

Tada

http://www.sqlservercentral.com/forums/messages.aspx?forumid=386

Cross posted from another thread, not necessarily in response to Simon. Though I do think Simon raises great points:

I think I've done a poor job of stating my BI position,...

I think I've done a poor job of stating my BI position, so let me clarify a bit. I don't believe that BI will widely catch on because of the...

Making notes and I should have some writeups tomorrow and over the next week. Trying to hit lots of sessions

You could set up an audit log that was write only (insert only), but the problem is at some point the admin (sa) could change things, drop the trigger to do...

I was actually hoping this editorial would bring to light some of the ways you might classify a junior DBA. It's traditionally been years of experience, which isn't a good...

Thanks for the comments and it's definitely a large, complex area. I think Jamie brings up a great point that there's more to BI than SSAS. Digging through my Kimball...