SQL Server Encryption and Decryption Tutorial with Script

Beta Code

SQL Server 2005 and SQL Server 2008 provide encryption as a new feature to protect data against hackers’ attacks. Hackers might be able to penetrate the database or tables, but owing to encryption they would not be able to understand the data or make use of it. Nowadays, it has become imperative to encrypt crucial security-related data while storing in the database as well as during transmission across a network between the client and the server.

Encryption hierarchy is marked by three-level security. These three levels provide different mechanisms for securing data across networks and local servers. Different levels of hierarchies allow multiple instances of services (e.g., SQL Server Services) to run on one physical server.

• Windows Level – Highest Level – Uses Windows DP API for encryption
• SQL Server Level – Moderate Level – Uses Services Master Key for encryption
• Database Level – Lower Level – Uses Database Master…

View original post 1,151 more words

Creating a database schema with Fluent NHibernate

Kash Farooq's software development blog

If you create your model in C# first, and then want to create a database schema that matches that model, you can do this easily with Fluent NHibernate.

First, you need some sort of Data Access Initialization class.

You could use this to create your Session Factory for any app. Note that I’ve created a EntitiesToMapConfiguration class to limit the types that Fluent is interested in. I don’t want NHibernate to start looking for a DataAccessInitializer table.

I’ve done one extra thing that you don’t need if you just want to create sessions from the Session Factory: I’ve called FluentConfiguration.ExposeConfiguration to save the NhibernateConfiguration into a private variable. I have also created a public NhibernateConfiguration property that exposes this so that it can specifically be used by the following code to create the database schema:

I’ve wrapped the runner in an NUnit test, and used the ExplicitAttribute to prevent the test from running accidentally –…

View original post 21 more words

Publish Crystal Reports applications to IIS