Tag Archives: configure

How to work with Policy Based Management (PBM)

In my previous article on policy based management Ive gone through what is policy based management and how it helps administration. Lets discuss about how to work with policy based management i.e. how to create a policy and implement it. To work with a policy we need to first create a condition and we need to use this condition in our policy. Lets discuss each of the title mentioned below Continue reading How to work with Policy Based Management (PBM)

Implementing Transparent Data Encryption (TDE)

In my previous article we have discussed what is TDE, how it works, its pros and cons. In this article Im going to cover how to implement transparent data encryption to your server. Its very simple to implement TDE, below are the steps that needs to be completed to enable TDE.

  • Create a master key
  • Create or obtain a certificate protected by the master key
  • Create a database encryption key and protect it by the certificate
  • Set the database to use encryption

Lets discuss on each of this title to create TDE

Continue reading Implementing Transparent Data Encryption (TDE)

Configuring SQL Server Reporting Services

In my previous article we have covered installing reporting service. The next step in reporting service is to configure them according to your environment.

There are many options are available in reporting service configuration. You need to configure all these values with respect to your environment. There are two ways to configure reporting service a.) Using Reporting service configuration GUI and b.) Reporting service configuration command line utility (RSConfig.exe located @ C:Program FilesMicrosoft SQL Server90ToolsBinn directory). The reporting service GUI configuration tool is very simple to use and many prefer this. Lets configure reporting service using this GUI too.

Continue reading Configuring SQL Server Reporting Services