Ken, I hope this finds you recovering with nothing but positive news for your future. You're a bright spot in our community and I'm pretty sure everyone you come in...

Break the mirror, perform the move, restart mirroring. The move doesn't break the log chain so there should be no need to re-seed the mirror. This of course...

My first thought would be to question those who are directing you to use this construct? What are they hoping to gain in configuring such an architecture? If...

This is a very good question! If the link in the book no longer works I recommend contacting Red Gate. They should be able to point you in...

I would disagree with you, this is definitely a question for DBAs as I hope you don't leave the install of this or any other important tool to be used...

This could be one of a thousand different issues. You really have not given us enough information to go on. Are the databases large and set to auto_close?...

if using integrated security you'll not supply a UID and PW as those are passed through via your workstation login credentials back to the domain. Use UID and PW...

In regards to developers we don't let ours touch production and we don't mix PROD and TEST/DEV databases on the same SQL Server. We tend to look more at...

Are you saying that users only interact with the data via stored procedures? There is no ad-hoc sql being run from any application, reporting tool, etc.? I see...

BOL and msdn have specific articles and examples for doing that.

Along the lines with what Jack suggested I use the following. It will give you more information than you need. Look up the values for transaction type and...

I don't believe you'll hae any issue running the upgrade because of the location of the (moved) master.ldf file. I have heard of issues with detached .mdf/.ldf files, but I...

Yet another reason why we are *tough* on potential DBAs during their interviews is that we are relying on you as both a teammate, fallback resource, what have you to...

A CROSS APPLY will be applied against each row in the table/view it is joined to. For example this query returns a row for each record in sys.sysprocesses. ...

In Management Studio expand Security\Logins\ Right click on the login in question and select Properties from the pop-up window

Under the securables tab click Search. Select Server.

In the window that pops...