Forum Replies Created

Viewing 15 posts - 5,161 through 5,175 (of 9,244 total)

  • RE: TDE and SQL Server Databases

    Hi Todd thanks for the comments, I totally agree, if you're serious about implementing TDE then an external key management service is a must.

    The 3rd party products I referred to...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: TDE and SQL Server Databases

    yes i can see that would be a little embarrassing, please don't forget to rate the article if you found it useful

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: TDE and SQL Server Databases

    guy.stephens (8/16/2012)


    I'm surprised there isn't more mention generally about the fact that TDE is only available in SQL Enterprise edition.

    This seems to be where it is least needed as the...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: user mapped as dbo

    Correct you can't drop the user, you change the mapping.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: TDE and SQL Server Databases

    chuck.hamilton (8/16/2012)


    2) Data in transit. The article does say that TDE only protects data at rest. I just feel that this needs to be emphasized. If you want to protect...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Netapp snap for files, log shipping for database?

    for the images you may be better off with Windows Distributed File System. This is much improved under Windows 2008

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: TDE and SQL Server Databases

    alex.thompson (8/16/2012)


    Could you elaborate on your bullet point about TDE not encrypting databases used in replication topologies? I'm thinking specifically of log-shipping.

    Replication does not replicate the database encryption calls, they...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: TDE and SQL Server Databases

    Geoff A (8/16/2012)


    nice article. key points covered very well.

    we use TDE. we have about half the databases encrypted. the others are not.

    i noticed less than 5% increase in CPU usage...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Learning C

    I started using C along with Pascal at college in my youth. I think it's a great language very powerful (you can use assembly directly within C). I think it's...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Adding a second instance to a cluster

    No, the network names have nothing to do with it, it's the instance name that is the restriction. Each machine can only have 1 default instance clustered or not.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Adding a second instance to a cluster

    No, you may have only 1 default instance. The rest would be named

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Database Mirroring with clustering

    you will need to throroughly test this, set the timeout via T-SQL

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Log shipping throw errors

    Manie Verster (8/15/2012)


    Yes! I know but how and to what? I don't have a cooking clue. Can you help maybe, Perry?

    as Anthony said above really.

    You could also use the stored...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Database Mirroring with clustering

    liteswitch (8/15/2012)


    Now, I want the cluster to operate in a synchronous mode, with a witness

    Let's clear the confusion first, you mean mirror session not cluster

    liteswitch (8/15/2012)


    if the cluster is failing...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Log shipping throw errors

    Manie Verster (8/15/2012)


    I have log shipping set up on my database running on SQL Server 2012. It is scheduled to run Monday to Friday, 07:00 am to 17:00 pm. It...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 5,161 through 5,175 (of 9,244 total)