database encryption

Hello!
i am aware of the ability to encrypt something or issue a certificate for a
column, etc.
does the sql server itself write to disk in clear text?
if so, is there a feature to prevent that?
can a db not be mountable to another sql server without a password?
thank you very much for your help!
-Bahman"Bahman" <Bahman@.discussions.microsoft.com> wrote in message
news:4C85593A-F3A3-467B-AD51-32A87A99143C@.microsoft.com...
> Hello!
> i am aware of the ability to encrypt something or issue a certificate for
> a
> column, etc.
> does the sql server itself write to disk in clear text?
SQL Server stores data in binary format. Their might be some plain text
that can be seen if someone were to dissect your MDF files.

> if so, is there a feature to prevent that?
There are third party software encryption tools that encrypt the actual MDF
files, or even entire hard drives.|||"Bahman" <Bahman@.discussions.microsoft.com> wrote in message
news:4C85593A-F3A3-467B-AD51-32A87A99143C@.microsoft.com...
> Hello!
> i am aware of the ability to encrypt something or issue a certificate for
> a
> column, etc.
> does the sql server itself write to disk in clear text?
SQL Server stores data in binary format. Their might be some plain text
that can be seen if someone were to dissect your MDF files.

> if so, is there a feature to prevent that?
There are third party software encryption tools that encrypt the actual MDF
files, or even entire hard drives.|||In SQL Server 2005 the private key associated with a certificate is always
stored encrypted. See the famous Encryption Hierarchy chart at
http://msdn2.microsoft.com/en-US/library/ms189586.aspx
This posting is provided "AS IS" with no warranties, and confers no rights.
HTH,
~ Remus Rusanu
SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
"Bahman" <Bahman@.discussions.microsoft.com> wrote in message
news:4C85593A-F3A3-467B-AD51-32A87A99143C@.microsoft.com...
> Hello!
> i am aware of the ability to encrypt something or issue a certificate for
> a
> column, etc.
> does the sql server itself write to disk in clear text?
> if so, is there a feature to prevent that?
> can a db not be mountable to another sql server without a password?
> thank you very much for your help!
> -Bahman
>|||In SQL Server 2005 the private key associated with a certificate is always
stored encrypted. See the famous Encryption Hierarchy chart at
http://msdn2.microsoft.com/en-US/library/ms189586.aspx
This posting is provided "AS IS" with no warranties, and confers no rights.
HTH,
~ Remus Rusanu
SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
"Bahman" <Bahman@.discussions.microsoft.com> wrote in message
news:4C85593A-F3A3-467B-AD51-32A87A99143C@.microsoft.com...
> Hello!
> i am aware of the ability to encrypt something or issue a certificate for
> a
> column, etc.
> does the sql server itself write to disk in clear text?
> if so, is there a feature to prevent that?
> can a db not be mountable to another sql server without a password?
> thank you very much for your help!
> -Bahman
>|||Can someone recommend a good highly scalable and easy to use 3rd party tool
to encrypt the contents of a disk. Keep in mind that I run a SQL Cluster. So
the disk is not local. It resides on the SAN.
TIA!
"Mike C#" <xxx@.yyy.com> wrote in message news:Na1lg.294$B95.11@.fe10.lga...
> "Bahman" <Bahman@.discussions.microsoft.com> wrote in message
> news:4C85593A-F3A3-467B-AD51-32A87A99143C@.microsoft.com...
> SQL Server stores data in binary format. Their might be some plain text
> that can be seen if someone were to dissect your MDF files.
>
> There are third party software encryption tools that encrypt the actual
> MDF files, or even entire hard drives.
>|||Can someone recommend a good highly scalable and easy to use 3rd party tool
to encrypt the contents of a disk. Keep in mind that I run a SQL Cluster. So
the disk is not local. It resides on the SAN.
TIA!
"Mike C#" <xxx@.yyy.com> wrote in message news:Na1lg.294$B95.11@.fe10.lga...
> "Bahman" <Bahman@.discussions.microsoft.com> wrote in message
> news:4C85593A-F3A3-467B-AD51-32A87A99143C@.microsoft.com...
> SQL Server stores data in binary format. Their might be some plain text
> that can be seen if someone were to dissect your MDF files.
>
> There are third party software encryption tools that encrypt the actual
> MDF files, or even entire hard drives.
>|||You can use encrypt data and file using SQL Server 2005.
In SQL Serer 2005 support many Encryption methods.
And can use EFS, NTFS .
"Bahman"?? ??? ??:

> Hello!
> i am aware of the ability to encrypt something or issue a certificate for
a
> column, etc.
> does the sql server itself write to disk in clear text?
> if so, is there a feature to prevent that?
> can a db not be mountable to another sql server without a password?
> thank you very much for your help!
> -Bahman
>|||You can use encrypt data and file using SQL Server 2005.
In SQL Serer 2005 support many Encryption methods.
And can use EFS, NTFS .
"Bahman"?? ??? ??:

> Hello!
> i am aware of the ability to encrypt something or issue a certificate for
a
> column, etc.
> does the sql server itself write to disk in clear text?
> if so, is there a feature to prevent that?
> can a db not be mountable to another sql server without a password?
> thank you very much for your help!
> -Bahman
>

Database Discussion to change perpective

Hello

I have been doing relational database forever(or a long time) and have been intruduces to a team that uses a highly normalized database(propietary) to manage workflow.

We are capturing data in an AUDIT Trail EAV format.(500 million rows)

It is my task to build this into a data warehouse for reporting and I need to have with my team a relational database discussion. The relational database knowledge on this team is DB2 based, IDMS, and other past evolutions.

The common processes used are recieve a flat file and process this file sequentially using C# or VB doing lookups of other databse tables and writing out another flat file to be converted in XML for load to the propritary system.

My goal is to attempt to introduce new design concepts to my team and these are some talking points that I have come up with for a lunch and learn session.

can anyone else add to this list I don't want to get into a deep discussion about 3rd NF, Star Schemas vs Snowflake, etc.. I want to keep is informational and light to eliceit discussion and relat it back to older technologies.

some of the topics we can discuss are:
Why the data warehouse
Real-time tables what needs to stay in prod
What is going to happen to reporting database
Interaction between database on the same cluster/server
Interaction between databases on different servers (linked servers not allowed)
Set processing as opposed to cursor processing.
Table types
EAV
Type1
Type2
Fact
Dimensions
CodeYou could consider a demonstration of speed by getting together a flatfile of data, and then import it with the old way, then with BCP or BULKINSERT. I find people respond to demos better than theoretical discussion.