data encryption standards

Is there any organization with standards for SQL Server database encryption
software? Does anyone have any warnings/advice about evaluating 3rd party en
cryption products?Rule #1: Alway evaluate on a test box.
Other than that, I don't believe there is an organization with standards
specifically for SQL Server. You would most likely want to check out
www.nist.gov for general encryption standards. You will probably also want
to
get confirmation from the vendors you interview what standards their product
s
adhere to.
Here are several of the third party product usually mentioned:
Whamware.Crypt from www.whamware.com
ActiveCrypt from www.activecrypt.com
dbEncrypt from www.appsecinc.com
Enjoy!
Tom
"Dan P."
> Is there any organization with standards for SQL Server database encryption[/color
]
software? Does anyone have any warnings/advice about evaluating 3rd party
encryption products?

Data encryption in SQL Server 2000

I know there is no native encryption in SQL2K, but what 3rd party encryption tools would other forum members recommend from experience? I am required to encrypt data for PCI compliance.
Thanks
LempsterSQL Server Magazine (http://www.sqlmag.com/articles/index.cfm?articleid=44550&) gives you a few good hints, even if you don't subscribe. Apart from that, I do not know what kind of requirements you have, but keep in mind that NTFS supports encryption of files, which is transparent to the applications, so you can encrypt the data files so that only the SQL Server Service Account can read the file. Hope this was of some help.

Data Diagram Software

Hi SQL Gurus,
I have a database that has 250 tables. I need to a 3rd party software that
will generate data diagram for me. I used data diagram from sql but it is
useless with a huge amount of tables.
I would be nice if that 3rd party software can do other things more than
just generate data diagram.
Your suggestions are always highly regarded.
Vito Corleone
My personal choice is Visio for Enterprise Architects. It will do forward
and reverse database engineering as well as excellent diagramming. It also
is included in several MSDN products so you may already have a license for
it.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Vito Corleone" <VitoCorleone@.discussions.microsoft.com> wrote in message
news:7A80466D-2948-4775-94A8-70EC75C76AB5@.microsoft.com...
> Hi SQL Gurus,
> I have a database that has 250 tables. I need to a 3rd party software
> that
> will generate data diagram for me. I used data diagram from sql but it is
> useless with a huge amount of tables.
> I would be nice if that 3rd party software can do other things more than
> just generate data diagram.
> Your suggestions are always highly regarded.
> Vito Corleone