Bump. This one is open for anyone again. Wayne decided not to tackle it.

Jeff Moden (2/16/2014)

---

As I stated peviously, the OP is frequently the worst person to judge answers. You have to remember that they asked the question because they don't know...

That's a good question. I was thinking data oriented, building skills to work with the language, but there's probably room for 2 if someone wants to explain R to DBAs,...

Evil Kraig F (2/13/2014)

---

...

I'll have to try to sit in on Steve's talk one day, but I want to see the nuts and bolts of the final produced product. ...

Eric M Russell (2/13/2014)

---

The truth is that, for most development teams, there is only one instance of the development database, and every build is an "integrated" deployment, whether is should...

waxingsatirical (2/13/2014)

---

Whilst I have found RedGate's SQLCompare tool useful for deploying schema changes in the past, the problem it has is that is a tool and will never be able...

You can probably modify this to help you and look for "recovery complete". :http://timlaqua.com/2009/09/determining-how-long-a-database-will-be-in-recovery-sql-server-2008/

The problem is that SQL Server doesn't log individual database times. It logs the start of recovery,...

Does this not work?

CREATE TABLE MyTable

(

_key_out VARCHAR(10)

, myval int

);

INSERT INTO mytable SELECT 'A', 1

INSERT INTO mytable SELECT 'A', 2

INSERT INTO mytable SELECT 'B', 1

INSERT INTO mytable SELECT 'C',...

TDE will not work, for the reasons Nadrek gives above.

You can encrypt data in the tables with symmetric key encryption, and store the keys in your application. USing temp keys,...

I'm not completely clear what you're doing. Do you mean you have a _key_out field in every table in the DB?

Are you trying to get

select count( distinct _key_out)...

Personally I'd suggest you use Powershell and call that from xp_cmdshell. If you move this to an agent job or elsewhere, it's cleaner, and more flexible.

Here's a starter article: https://blogs.technet.com/b/heyscriptingguy/archive/2013/04/19/use-powershell-to-copy-files-and-folders-to-a-new-location.aspx

As Gail mentioned, disasters vary. It's easy to think of HA as protecting you from disaster, but it doesn't. Don't conflate the idea of HA with DR. They are separate.

Sorry for the...

I have these men's shirts, sorry, XXS only

For women, we have XXXXXXL in this

but you have to share. 1 for every 3 of you.

Evil Kraig F (2/6/2014)

---

Jeff Moden (2/6/2014)

---

This might better if it was a public "Consensus" rather than what the OP thought. After all, the OP theoretically didn't know squat about...