Feel free, but please tackle one at a time only.

These would be good. We'd be looking for 2-3 per article to keep this relatively short.

teresalinus (2/18/2014)

---

I favor software patent laws.The time is different now,we are in the world, where every other big industry is now making a disastrous use of patent laws which prevents...

An HTML file with the titles or with all the content?

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