I got it back from the proj mgr that we read unencrypted pages, then compress them, then encrypt the result (if you choose to do so).

As Jeff mentioned, the indexes matter. If you don't have good ones, then this can be problematic. Please include the DDL for indexes and the tables, with your sample data....

I'm checking on the technical details of the Red Gate product to see. The issue is that it depends on how the VDI interface sends out pages, and where in...

You'll have to provide more details on what these tables look like, including the DDL And PK/FK definitions.

You connect tables, not databases, so I'm not sure how you are describing...

Ed Wagner (11/10/2014)

---

Good question. Whenever I create keys, I back up the SQL I use to create them. This way I know how to recreate it exactly the...

Apologies. A few things on the SPAM:

1. We had a hiccup in the spam process and it was disabled over the weekend. Hence many of you (and me) getting...

Andrew..Peterson (11/10/2014)

---

"There were more people looking to secure their systems, though a surprising number of people using TDE had never attempted a DR restore. Please, please, do this. Make sure...

There's no magic here. You need to transfer the data. If you have large amounts of data in an mdf, then whether you use backup/restore, replication, SAN mirroring, etc, you...

Grr, I hate bye weeks

The only way to get an SA password if you don't have it is to have admin rights on the local hosts. Restart the SQL Server in single user mode...

TomThomson (11/6/2014)

---

Good question.

It raises an issue about the quality of this wizard: why on earth doesn't it read metadata for the target table and set lengths accordingly? It...

Iwas Bornready (11/6/2014)

---

I haven't been to one of these types of conferences in years. But what I recall it's like a Comic Con for IT people. Lots of panels, lots...

Doctor Who 2 (11/6/2014)

---

Hi Steve (or anyone else at the PASS conference), what you wrote suggested to me that people could see at least some of the presentations online. How...

We made a few forum changes today. If you notice something, let us know.

Yay, and ouch. 😉