![]() This SQL Server version can be installed in Windows Core Edition, a secure operative system. In this new version, the BIDS (Business Intelligence Development Studio) was replaced by SSDT (SQL Server Data Tools). You also have Power View reports for multidimensional models.įor a complete list of new features, refer to this link: There are enhancements in AlwaysOn, Columnstore Indexes. It is possible to migrate a database backup to Azure. You can for example migrate your Database on-premises to a Virtual Machine in Azure. The main features in SQL Server 2014 were the integration to Azure and Memory Optimized Tables. SSIS now supports Always On Availability Groups.įor a complete list of changes, refer to this link: SSRS now supports a web Report Portal and a Mobile Report Publisher. Also, you can apply now Row Level Security. It includes its own versions.Īlways encrypted is introduced as a new feature that allows to increase your security.ĭynamic Data Masking helps you to protect sensitive data. SQL Server Management Studio is separated from the database engine. It is also possible to use temporal tables to save data changes. Stretch database is another feature that allows to archive data in Azure SQL. With PolyBase, you can query NoSQL data like csv files stored in Azure Blob Storage or in HDInsight.Īnother interesting feature is JSON support which includes new features to handle JSON data. In SQL Server 2016, PolyBase support was introduced. R Services changed the name to Machine Learning Services and access to Python libraries.įor a complete list of changes in SQL Server 2017, refer to this link: In SSDT, you have now a DAX editor and tabular databases are the default installation. New dynamic Management views (DMV) like the sys.dm_db_log_stats, sys.dm_tran_version_store_space_usage and sys.dm_db_log_info. SQL Server 2017 includes Python support, as well as … In this version, CLR assemblies can now be added to a white list. In fact, the installers for Red Hat, Ubuntu and SUSE are different, but it is a huge step to support Linux. I think that the main feature is that now SQL Server can be installed in Linux and Docker, which is huge. Let’s take a look at the features of each version. In this article, we will talk about all these changes and improvements. Linux and Microsoft were just like oil in water and now, Microsoft loves Linux.Īlso, we now enjoy full integration with Azure, Tabular Databases, SSIS, SSAS and more. 15 years ago, it was impossible to think that. Now, the new versions of SQL Server (vNext and SQL Server 2017) can be installed in Linux. In the past, the first SQL Server versions supported OS/2 (an operative system created by Microsoft and IBM) and Windows. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |