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.

 



User Group Event:SQL Server 2008 R2 Reporting Services and Self-Service Analytics


posted on 
Session 1:  Introduction to SQL Server 2008 R2 Reporting Services and SharePoint 2010 Integration


David E. Myers


Speaker: David E. Myers


Ever since business applications were introduced, there was a need for great data reporting tools.  With the release of SQL Server Reporting Services 2008 R2, Microsoft has made a stronger case than ever for investing in their reporting solution.  In this session David will provide an overview of SQL Server 2008 R2 Reporting Services with a focus on the key value proposition, core architecture, development tools, and integration with SharePoint 2010. [Read more…]


October 15th Evening SQL Server DBA Event: Disaster Recovery


posted on 
OttawaSQL.net 


 


October 15th Evening SQL Server DBA Event: Disaster Recovery – Edwin Sarmiento, MVP for SQL Server


 


Speaker: Edwin M. Sarmiento, MVP for SQL Server


Date: Thursday, October 15th, 2009


Time: 6:00 PM to 8:30 PM


Venue: Microsoft Ottawa Office


RSVP: http://www.clicktoattend.com/?id=142063


Session 1 (6:00 PM to 7:10 PM):  Understanding and communicating business-orientated disaster recovery  concepts and objectives


So you have a database maintenance plan that does a backup of your databases and you’re pretty sure that it works fine. But is that really enough? Are you sure that you will be able to meet your service level agreements if and when disaster strikes? This session will explain the need for understanding and communicating business-orientated disaster recovery concepts and objectives to the business stakeholders. This will include defining your RPO and RTO and how it affects your disaster recovery plan.


Session 2 (7:20 to 8:30 PM):  Disaster Recovery for the Paranoid DBA


In the first session, much have been said about disaster recovery in general. In this session, we will look at bringing the concepts down to SQL Server. This session will focus on dealing with a recovery situation for a SQL Server 2005/2008 database, an instance or an entire server. Topics covered will be backup schemes, partial backups and piecemeal restores, page-level recovery and a thorough understanding of how to troubleshoot a “Suspect” database.


Edwin M. Sarmiento


Speaker Bio:


Edwin M. Sarmiento (MVP for SQL Server) works as a Senior SQL Server DBA/Systems Engineer for The Pythian Group in Ottawa, Canada. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases. He lives up to his primary mission statement – “To help people grow and develop their full potential as God has planned for them.”.


Refreshments:


Pizza and pop will be provided.


Note: No one will be admitted by building security after 5:55 PM, and the event will start promptly at 6:00 PM.




OttawaSQL.net is a community group of Ottawa area developers and IT professionals.  We share an interest in Microsoft’s data technologies especially:  SQL Server, SharePoint, PerformancePoint, Workflow Foundations, LINQ, ADO.NET and Entity Framework.