Dear all,
it is my pleasure to announce a new initiative of communicating SharePoint knowledge via videos using the “SharePointFive” approach: Show how technical configurations are done within only a few minutes (guideline: 5 mins per video, up to a max of 15 in special cases.
If you want to learn about SharePoint 2010 configurations, but only want to invest a few minutes at a time, if you are looking for the essentials that make up what you actually want to do, then SharePointFive is for you.
SharePointFive (SharePoint5)
SharePointFive is a youtube channel, that you can access under the below mentioned URL. It contains all videos (currently 1 only 
) that have been and will be published, showing how to apply SharePoint (or related) configurations in just a few minutes. Usually, like in this case, there will be published a related blog post on angler.wordpress.com, in order to facilitate it for you to copy scripts and apply them.
http://www.youtube.com/sharepointfive
The Video
The video will give you an idea of the steps to be executed, a few caveats. But most of all, it is only a few minutes long and won’t take a long time to watch. This first episode of SharePointFive is a bit longer (about 12-13 minutes), since it contains also the explanation and motivation why SP5 has been launched.
The Scripts
1. Create the Master Key:
1: USE master; 2:
3: go 4:
5: CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'n0PWStealingAll0w3d!'; 6:
7: go
2. Create the Certificate:
1: CREATE CERTIFICATE SP5Certificate WITH SUBJECT = 'SP5 DEK Certificate'; 2: go
3:
3. Back up Certificate & Private Key (EXTREMELY IMPORTANT TO KEEP IT BACKUPPED AND SAFE!):
1: USE master; 2: go
3: BACKUP CERTIFICATE SP5Certificate TO FILE = 'C:\Certificate\TDECertificate.cer' 4: WITH PRIVATE KEY (
5: FILE = 'C:\Certificate\PK.pvk', 6: ENCRYPTION BY PASSWORD = '?pkP4SsW0rD!');
7: GO
4. Create Database Encryption Key:
1: CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256 ENCRYPTION BY SERVER CERTIFICATE SP5Certificate; 2:
3: GO
5. Enable Transparent Data Encryption for a Specific Content Database:
1: CREATE CERTIFICATE SP5Certificate WITH SUBJECT = SP5Certificate; 2: go
Please bear in mind:
- Scripts need to be adapted to your needs, of course
- Please run everything in a isolated test environment, before applying on production level
- Consult your DBA before applying any changes to the SQL Server Instance, like running the beforementioned scripts.
- The author of this blog cannot take responsibility for any damages caused by executing scripts, programs and configurations shown
- It is your responsibility to inform yourself about possible side effects that are not reported. Usually, Technet and MSDN are good references for complete documentation of the concepts shown.
- The scripts of SharePointFive are provided “as is”
Stay tuned till the next episode of SharePoint 5 and enjoy!
Best,
Martin
