• CirquedeSQLeil (12/21/2009)


    I agree with Steve. I would prefer to have extra security on the laptops - not to the level of fully encrypting the entire hard drive. Security as options should be standard across all editions of SQL Server. If the DBA employs those options, that is their decision. As the DBA, I would rather the option be available so I can use it, than be the one questioned, since it is a database, and not have a legitimate answer for the lost data on the laptop.

    And yet - if you use Express (with the built-in SSMS for express, and the default user = SA), how is the encryption helping anyone? You just fire up SSMS, and voila, instant access to the data and all of its contents. The database automatically decrypts the data for anyone who's authorized, so the owner oof the laptop STILL cannot be denied access to the data.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?