Post reply

SQL Server 2016 SP1 Features

  • December 9, 2016 at 8:16 am

    #1917080

    What everyone else said.

  • December 9, 2016 at 8:39 am

    #1917089

    TDE is Enterprise only: https://msdn.microsoft.com/en-us/library/cc645993.aspx

    Can I get my point for answering correctly?

    MattF

  • December 9, 2016 at 9:02 am

    #1917094

    Yeah, I think the initial note I got a couple weekw said that TDE would be included, but I realized this week it wasn't. Forgot to correct things.

    Fixed and points awarded back.

  • December 9, 2016 at 9:44 am

    #1917109

    Adding all these features to Standard Edition is great.

    But having these new features like encryption, data masking, and compression in Express Edition also presents some interesting opportunities. We have SQL Server Express Edition installed at 2000+ point of sale locations and currently rely on a 3rd party encryption library (CLR functions) that can be problematic to code and support.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • December 9, 2016 at 10:58 am

    #1917140

    Steve,

    Thanks for the question and the great site.

    We're not on 2016 yet but it was/is exciting when they announced these features being added to Standard Edition.

    As for the current state of the question...

    Which of these features cannot be used in SQL Server 2016 SP1+ Standard Edition?

    When you select Transparent Data Encryption you get it wrong, even though this is the only feature in the answers that cannot be used in Standard.

    J

  • December 9, 2016 at 1:05 pm

    #1917159

    Ah, apologies. My fault. Didn't fix the answer correctly.

    should be ok now

  • December 9, 2016 at 1:31 pm

    #1917163

    I misread the answer "Only RLS, DDM, and Always Encrypted" as "Only RLS, DDM, and Always Encrypted are available on SQL Server 2016 SP1 + Standard Edition". Got it wrong but learned something anyway. Thanks for the question Steve.

  • December 11, 2016 at 10:33 pm

    #1917304

    Got it wrong but I'm pleased to only pay big prices on big servers. Too late for me though I'm already committed to a EE production install on friday. Next time I'll be looking at what I really need to pay for.

  • December 12, 2016 at 5:31 am

    #1917347

    Yesterday's Question (by Steve Jones):

    Which of these features cannot be used in SQL Server 2016 SP1+ Standard Edition?

    Answer: All can be used

    Explanation:

    With the changes in SQL Server 2016 SP1, the programming surface area between editions has been leveled. All of these features can be used in Standard Edition. In SQL Server 2016 RTM, only RLS and DDM were allowed.

    Ref: SQL Server 2016 SP1 Released - https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released/

  • December 13, 2016 at 4:14 am

    #1917544

    I recalled reading TDE was in. Either the article was wrong, MS changed their minds or I recalled incorrectly. Never mind. I know now!!!

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • December 19, 2016 at 1:39 am

    #1918619

    So the answer: All can be used is wrong?

  • December 19, 2016 at 2:39 am

    #1918623

    Mauricio_ (12/19/2016)

    So the answer: All can be used is wrong?

    Yes. TDE is not as per this discussion thread. There are links to MS pages that confirm this.

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

Viewing 12 posts - 16 through 26 (of 26 total)

You must be logged in to reply to this topic. Login to reply