通过使用本网站, 您同意 隐私政策.
接受
进入IT进入IT进入IT
  • 家
  • 信息技术专家
  • 技术
  • 微软
    • 天蓝色
    • 配置管理器/SCCM
    • 数字PM
    • 协调者
    • Hyper-V
    • 微软 Edge 预览体验
    • 微星指数
    • 办公室 365
    • 办公室内幕
    • 电力商业智能
    • Skype
    • SQL服务器
    • 团队
  • 视窗
    • Windows 管理中心
    • Windows客户端
    • Windows服务器
  • SCCM查询集合列表
阅读: SQL服务器 2019 Standard Edition new capabilities
字体调整器氨基酸
进入IT进入IT
字体调整器氨基酸
  • 家
  • 信息技术专家
  • 技术
  • 微软
  • 视窗
  • SCCM查询集合列表
搜索
  • 家
  • 信息技术专家
  • 技术
  • 微软
    • 天蓝色
    • 配置管理器/SCCM
    • 数字PM
    • 协调者
    • Hyper-V
    • 微软 Edge 预览体验
    • 微星指数
    • 办公室 365
    • 办公室内幕
    • 电力商业智能
    • Skype
    • SQL服务器
    • 团队
  • 视窗
    • Windows 管理中心
    • Windows客户端
    • Windows服务器
  • SCCM查询集合列表
SQL服务器

SQL服务器 2019 Standard Edition new capabilities

出版: 二月 18, 2024
4 最小阅读量
分享

SQL服务器 2019 Standard Edition new capabilities.

  • PolyBase Compute Node – In previous releases of SQL Server, PolyBase Compute Node had to be Enterprise Edition but with the advent of Big Data Cluster, we now support using Standard Edition for the PolyBase Compute Node.
  • Master instance for Big Data Cluster– The master instance of a Big Data Cluster can be Standard Edition instance.
  • Accelerated Database Recovery – This gives you SQL Server the ability to recover predictably from a crash failure. For scenarios where Standard Edition is used, the RTO (Recovery Time Objective) is mostly never ZERO. 然而, there is a need to have a predictability in the recovery during a crash or even when a long running transaction is rolled back. This gives SQL Server Standard Edition that predictable behavior so that developers don’t have to code their applications differently when running on different paid editions.
  • Transparent Database Encryption – Transparent Database Encryption is a commonly used feature for encrypting SQL Server databases. In the post GDPR world, data-encryption-at-rest has become table stakes and non-negotiable. Allowing SQL Server Standard Edition to leverage TDE and along with EKM support ensures that our customers can stay compliant with new regulation when using SQL Server Standard Edition.
  • Always Encrypted with secure enclaves– This expands upon Always Encrypted with in-place encryption and rich computations by enabling computations on plaintext data inside a server-side secure enclave. Again we provided this for Standard Edition as we believe that this feature would be important in helping adhere to various compliance policies.
  • Data Discovery and Classification – The ability to classify columns with appropriate labels also helps with compliance especially around certain data privacy requirements. Hence, Standard Edition gets this capability. Discovering and classifying your most sensitive data (business, financial, healthcare, etc.) can play a pivotal role in your organizational information protection stature.
  • Failover Server Benefit – While the new Software Assurance benefits are not specific to any release or edition, SQL服务器 2019 can leverage a free Disaster Recovery replica with a SQL Server on an Azure Virtual Machine and also leverage a free Disaster Recovery replica benefit on-premises.
  • Hybrid Buffer Pool – Persistent memory devices for database storage is coming up more and more in conversations that we have with customers. This new class of data storage re-defines what In-Memory means for a database platform. This feature will allow SQL Server 2019 Standard to outperform older release of SQL Server Standard edition while working with small to medium datawarehousing workloads.
  • Persistent Memory Support– Standard edition will also have support for storing data and long files on persistent memory devices.
  • Intelligent Query Processing – Intelligent Query Processing features like Approximate Count Distinct, Table Variable Deferred Compilation and Scalar UDF Inlining will be available on Standard Edition.
  • SQL Assessment API – This SMO extension provides the ability to perform best practices checks against SQL Server instances. While this can target all releases of SQL Server, we don’t restrict the use of this on any edition of SQL Server.
  • UTF-8 Support – SQL服务器 2019 now has support for storing data natively in UTF-8 format including Standard Edition.
  • Java Language Runtime Integration– SQL服务器 2019 introduced Java runtime integration to help run Java code within SQL Server which is available all editions of SQL Server.
标记:微软SQL服务器微软视窗服务器视窗
上一篇 Outlook Always Starts in Offline Mode
下一篇 Configuration Manager Deploy Office 365 Pro Plus Using Office Deployment Tool
发表评论 发表评论

发表回复 取消回复

您的电子邮件地址不会被公开. 必填字段已标记 *

该网站使用 Akismet 来减少垃圾邮件. 了解您的评论数据的处理方式.

翻译

English中文(简体)DanskNederlandsFrançaisDeutschItaliano한국어PolskiPortuguêsRomânăEspañolУкраїнська
经过 Transposh - translation plugin for wordpress

热门帖子

Windows Server 的系统要求 2016
Windows服务器
配置管理器查询集合列表
配置管理器查询集合列表
configmgr
在经典团队网站的新式页面上启用结构化/托管导航
技术
SCCM 无法从 MP 获取预期版本的 DP 位置
configmgr

最近的帖子

在 Ubuntu 上安装和配置 Fail2ban 以实现 SSH 保护 24.04
Linux
如何在Linux中检查时区
Linux
在AlmaLinux上启用和配置FirewallD
Linux
AlmaLinux中的用户创建和SSH密钥设置
Linux

© 2023 进入IT

转到移动版本
欢迎回来!

登录您的帐户

用户名或电子邮件地址
密码

丢失密码?