介绍 (Introduction)
This article will explain the main features in SQL Server 2017, 2016, 2015, 2014, 2012, 2008, 2005, 2000, 7, 6.5, 6.0, 4.2, 1.1 and 1.0.
本文将介绍SQL Server 2017、2016、2015、2014、2012、2008、2005、2000、7、6.5、6.0、4.2、1.1和1.0的主要功能。
In the past, the first SQL Server versions supported OS/2 (an operative system created by Microsoft and IBM) and Windows.
过去,第一个SQL Server版本支持OS / 2(由Microsoft和IBM创建的操作系统)和Windows。
Now, the new versions of SQL Server (vNext and SQL Server 2017) can be installed in Linux. 15 years ago, it was impossible to think that. Linux and Microsoft were just like oil in water and now, Microsoft loves Linux.
现在,可以在Linux中安装新版本SQL Server(vNext和SQL Server 2017)。 15年前,不可能想到这一点。 Linux和Microsoft就像水里的油,现在, Microsoft喜欢Linux 。
Also, we now enjoy full integration with Azure, Tabular Databases, SSIS, SSAS and more. In this article, we will talk about all these changes and improvements.
此外,我们现在享受与Azure,表格数据库,SSIS,SSAS等的完全集成。 在本文中,我们将讨论所有这些更改和改进。
Let’s take a look at the features of each version.
让我们看一下每个版本的功能。
SQL Server 2017
Year: 2017
SQL Server 2017
年份: 2017
I think that the main feature is that now SQL Server can be installed in Linux and Docker, which is huge. There is no universal installer. In fact, the installers for Red Hat, Ubuntu and SUSE are different, but it is a huge step to support Linux.
我认为主要功能是现在SQL Server可以安装在Linux和Docker中,这非常庞大。 没有通用安装程序。 实际上,Red Hat,Ubuntu和SUSE的安装程序有所不同,但这是支持Linux的重要一步。
In this version, CLR assemblies can now be added to a white list.
在此版本中,现在可以将CLR程序集添加到白名单。
SQL Server 2017 includes Python support, as well as …
SQL Server 2017包括Python支持以及…
- Identity Cache, 身份缓存
- Graph Database, 图数据库
- Resumable Indexes, 可恢复索引
- New string functions, 新的字符串函数 ,
- Adaptative Query Processing, 自适应查询处理
- Automatic tuning, 自动调整
- sys.dm_db_log_stats, sys.dm_db_log_stats , sys.dm_tran_version_store_space_usage and sys.dm_tran_version_store_space_usage和sys.dm_db_log_info. sys.dm_db_log_info 。
SSIS is now supported in Linux. In SSDT, you have now a DAX editor and tabular databases are the default installation.
Linux现在支持SSIS。 在SSDT中,您现在有了DAX编辑器,表格数据库是默认安装。
In SSRS, you can run native DAX queries. R Services changed the name to Machine Learning Services and access to Python libraries.
在SSRS中,您可以运行本机DAX查询。 R Services将名称更改为Machine Learning Services,并可以访问Python库。
For a complete list of changes in SQL Server 2017, refer to this link:
有关SQL Server 2017中更改的完整列表,请参考以下链接:
SQL Server 2016
Code Name: Helsinki
Year: 2016
SQL Server 2016