Monthly Archives: May 2017

  • What's New - SQL Server 2016 Developers Edition

    SQL Server Developer Edition Features & Pricing

    SQL Server Developers Edition is a full featured edition of Microsoft SQL server. Developers prefer this version because it comes will all of the unlocked features, at no cost. Wondering if Developer's edition is right for you? There are many different ways to price & license SQL server. Keep in mind Developer's edition is primarily for building and testing. Learn more about the features and highlights below.

    Developers Edition Vs Standard

    SQL Server Developers Edition comes with all the bells and whistles of Enterprise Edition but in a non-production environment. This means those looking to run applications will need to opt for the standard version. SQL Dev Ed is used for the production, building and demonstration of applications. This version includes the full feature set of the Enterprise Edition. Moreover, Microsoft offers developer edition with no cost whatsoever with Visual Studio. Developers edition allows user to build web/mobile application for various data types.

    SQL Server Features & Licensing

     

    Features & Highlights

     

    ENCRYPTION

    SQL Server comes with an always encrypted feature. With this feature enable, your database is always encrypted with the SQL Server. Access of the database is restricted to the devices calling SQL Server only. This allows the data owner to control who has access to the database and stop the nosy Administrator from poking around. This is a welcome security edition.

    JSON SUPPORT

    SQL Server Developers Edition also supports JSON (Java Script Object Notation) just like the enterprise edition. JSON support enables you to exchange JSON data between applications and SQL database engine. Moreover, Developers can turn the relational data into JSON formatted data.

    QUERY STORE

    With the query store feature, SQL Server saves historical execution plans for the queries. It also saves the query statistics that go along with these historical execution plans. This great edition will help you to track performance of queries over time.

    ROW LEVEL SECURITY

    SQL Server comes with row level security which allows database engine to restrict access to rows based the SQL Server Login. Implementing this feature will exempt application developers from maintaining code to restrict data access to some logins.

    TEMPORAL TABLES

    A temporal table hold the old version of the records within a base table. SQL Server Developers edition now automatically manages moving old row versions to the temporal tables whenever the records are updated.

    R- SUPPORT

    Microsoft incorporates R-programing language in SQL server to support advance analytics against big data sets. This allows the Database administrators to run their existing R code inside the SQL Server database engine, thereby eliminating the need for exporting the database to perform these advance analytics.

    PolyBase

    PolyBase is a nifty feature that allows user to query distributed data sets. By using polybase user can write adhoc queries which join relational data from SQL Server with data stored in Hadoop or SQL Azure blob storage.

    DYNAMIC DATA MASKING

    This feature allows to obscure confidential columns in a database from users which are not allowed to view the. Dynamic Data Masking allows you to identify how to obscure the data. For instance, By using this feature you can define a mask that can limit a user’s view to only some digits of Credit Card Number.

    For more information on SQL Server, or to speak to a free licensing expert click here.