2014: The Review

  • Comments posted to this topic are about the item 2014: The Review

  • Add me to the list of those still on 2008 R2. Our admin isn't convinced there is much advantage to upgrade yet versus time and cost.

  • The new features in SQL Server don't matter much to me. Neither I nor my clients are in a position where they are important enough to consider over the increased license costs of the software. More inquiries about "other" solutions over come up in the past years email and conversations than any other. Redmond is losing a ton of clients to alternatives that they don't dare acknowledge.

    The most exciting thing in the Microsoft world is what is happening to .NET and ASP and Visual Studio. This also applies to F#, a language that is on the verge of a breakout year in the community.

    As for data security, it's gonna get a lot worse before it improves. Our networking, hardware and system programming languages are inherently insecure. And the leadership that can fund the changes has no rational or technical ability outside of their own pocketbook.

  • In fact, I might argue that apart from Hekaton, this wasn't necessarily worthy of a full release. PowerBI, BPE, the cardinality estimator changes, some Azure improvements and AlwaysOn changes, all were included, but this felt like a bit of a mish-mosh of features. We didn't see many of the technologies from previous versions (Service Broker, Contained DAtabases, SSRS, SSIS, etc) enhanced or improved.

    I'm impressed by Clustered ColumnStore. It's completely not practical for OLTP databases, but for data warehouse applications with star schema or flat tables, it's a game changer. For flat, extremely denormalized table containing many columns and billions of rows, it's amazing how this new feature can compress down the size of the table and improve performance of queries that return a narrow range of columns.

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

  • Somehow, as a non-DBA this may not be common, I get the feeling that a lot of recent development (years - multiple full versions) is adding niche (or at least uncommonly used) feature sets. These might be very useful for those that require them, however, irrelevant to the rest of us. This is even ignoring the pricing factor.

    Gaz

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

Viewing 5 posts - 1 through 4 (of 4 total)

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