Todd's Blog

Todd's Tips for System Adminstrators

Connect

Using Transparent Data Encryption in SQL Server 2008 For MBAM

posted on

If you want to install Microsoft Bitlocker Administration and Monitoring (MBAM), then you will need to encrypt the SQL database that houses the keys for bitlocker.

You will need at least the Enterprise version of SQL Server 2008 (I used R2, but 2008 SP2 should also work).

The command to enter in a SQL Query tool is
use master
go

create Master key
encryption by password = 'PasswordHere'

This will allow MBAM to continue and install provided you met the other requirements.

In another post, I will cover off recovering the MBAM database and building a disaster recovery plan for MBAM.

 



Planning a Windows 7 Deployment


posted on 
Last July I left the County of Lennox & Addington and moved to the Upper Canada District School Board. One of the the first things I helped with was the Windows 7 Deployment. 


This Windows 7 deployment is a 11,000 seat deployment and when I joined, the image was just about finalized. At this point the heavy lifting of planning, and figuring out what is in the environment was completed, but let me help you walk through your planning.


The first thing you need to do is get a sense of what your hardware is. In our environment,we have a tool that was developed to track that information. But you don’t need to reinvent the wheel, Microsoft makes a great tool FREE tool called MAP, Microsoft Assessment and Planning (MAP) Toolkit. You run this tool against your AD computer and then you get a great report of what is in your environment and what the capability of the computers are. 


After running this tool, you should also be using the Application Compatibility Toolkit, another free tool. This application runs creates an MSI that is run on workstations. I push it out with GPO but you can use any tool you have to push MSIs out. This tool then runs for a predetermined amount of time (you set that) and then it returns what applications are installed and how much it has been used. From that report, it will make a list of what you have running for applications and which ones are supported on Windows 7. It also contains fixes for common application which won’t work natively with Windows 7. We used this tool to fix AutoCad 7 when it wouldn’t work correctly with Windows 7. 


So, those two tools will help you get planning your Windows 7 deployment. Use these two tools, gather your information and plan your deployment. Good planning upfront will prevent a lot of a pain in the deployment phase. 


In another post, I will cover off the deployment side. 


Xbox Live Applications


posted on 
Something I have been meaning to write about for a bit is the new Xbox apps. So far, in Canada, there is Roger’s on demand, Real Sports, Crackle, TMZ and a UFC application you can install. I could be missing some as well, but that is what we have  installed plus Netflix. 


Netflix gets the most use here at the house, followed by the Roger’s on Demand app, the others, not so much use. I do have a Roger’s cell phone which allows me to get more the programs you would get without the application. There are programs from various channels like CBC, CityTV and Treehouse (always a hit with the 2yr old). 


For these applications to work, you need Xbox Gold, which is kind of a kick but considering you might pay $80.00/month for cable, I guess it is bit of a deal.