SQL Server 2019 Standard Edition
Microsoft
- Industry leading performance and intelligence over all your data, structured and unstructured
- Most secure database over the last 10 years per NIST*
- Query any database like Oracle, MongoDB, and Cassandra in a highly secure and highly performant way—all without moving or copying the data
- Built to take on any data project, from OLT and BI, to AI and advanced analytics
- Built-in AI with R, Python and SQL Server Machine learning services
- Includes Azure Data Studio
- Features like Transparent Data Encryption (TDE) and Accelerated database recovery are now part of Standard edition
CAD $4,516.00
New for SQL Server 2019
Analyze structured and unstructured data
Use the language and platform of your choice
Breakthrough performance and scalability of your database
Access to rich, interactive Power BI reports on any device
View the new capabilities of SQL Server 2019
Query all data types
Manage your big data environment more easily with Big Data Clusters. They provide key elements of a data lake—Hadoop Distributed File System (HDFS), Apache Spark, and analytics tools—deeply integrated with SQL Server and fully supported by Microsoft.
SQL Server is best on Azure
Migrate your existing apps or build new ones on Azure and get the best price-performance for your mission-critical SQL Server workloads.
SQL Server 2019 in containers
SQL Server 2019 in containers are a fast way to get started with SQL Server 2019, and can be used throughout your data estate from development to production.
Azure Data Studio notebooks
Did you know Azure Data Studio has a rich notebook experience? Whether you need a Python, Pyspark, or a fully integrated SQL kernel, you can start creating and editing your notebooks from anywhere in one tool.
Additional features
Break down data silos
Gain insights from all your data by querying across your entire data estate without moving or replicating the data.
Maximum availability
Gain mission-critical uptime, fast failover, and improved TCO using cloud disaster recovery replicas and always on availability groups. New Software Assurance benefit! Get a free SQL Server license for Disaster Recovery (DR) in Azure.
Intelligent database capabilities
Upgrade and modernize your SQL Server database on-premises, in the cloud, and at the edge. Database compatibility certification eliminates the risk of application incompatibility.
Accelerated database recovery
Greatly improves database availability by enabling fast and consistent database recovery regardless of the number or size of active transactions.
Built-in security and compliance
Use built-in features for data classification, data protection, and monitoring and alerts. SQL Server 2019 monitors, identifies, and provides alerts on suspicious activity.
Self-service BI on any device
Explore visual data and quickly discover patterns to make better, faster decisions with Power BI Report Server, which is included with your SQL Server Software Assurance license.
Encrypt all of your data
Encrypt sensitive data and execute rich computations on encrypted data, plus enable customized data access based on role with complex row filtering.
Highly scalable cloud services
Build highly intelligent, scalable cloud database services on Azure with the broadest SQL Server engine compatibility. Migrate existing apps or build new apps on Azure-the best cloud destination for your mission-critical SQL Server workloads
Top questions
-
- Data Virtualization: Query across data stored in Oracle, Teradata, other SQL Servers, Azure SQL Database, Azure SQL Data Warehouse, Azure Cosmos DB, Cloudera, Azure Data Lake, or the Hadoop Distributed File System (HDFS) without moving or replicating the data.
- Intelligent Database: Family of intelligent database features such as intelligent query processing improve query performance with no application change. Customers will see performance benefits without any application change just by upgrading to SQL Server 2019.
- In-Memory Database: Improve performance for mission-critical workloads with in-memory database capabilities like persistent memory support and memory optimized TempDB metadata.
- Secure Enclaves: Always Encrypted with secure enclaves protects sensitive customer data while allowing richer operations on secured database columns. A secure enclave extends client applications’ trust boundary to the server side. While it is contained by the SQL Server environment, the secure enclave is not accessible to SQL Server, the operating system, or to the database or system administrators. These properties allow the secure enclave to safely perform operations on sensitive data in plain text.
- Extensibility: We now offer free Java language integration with SQL Server. Customers can now leverage Java for free with SQL Server 2019.
- Accelerated database recovery enables fast and consistent database recovery irrespective of the number of active transactions in the system or their sizes.
-
- By upgrading to SQL Server 2019, customers can query external databases using the data virtualization feature. With built-in connectors, customers can query directly (oracle, Mongo DB, Teradata, Azure Data Lake, HDFS) without the need to physically move or replicate the data.
- Customers can achieve huge performance boost just by upgrading to SQL Server 2019 without any application change with features like Intelligent query processing and Accelerated database recovery.
-
There is no price increase for SQL Server 2019. Plus, we added three new SA benefits for customers to make SA an attractive proposition for our customers.
-
Every Software Assurance customer of SQL Server will be able to leverage three new enhanced benefits for any SQL Server release that is still supported by Microsoft:
- A free on-premises sync replica for High Availability.
- A free on-premises async replica for Disaster Recovery.
- A free Azure async replica for Cloud Disaster Recovery as part of Azure Hybrid Benefit.
- With a free Azure async replica, you can start attaching Azure to your existing SQL Server accounts. It is a great benefit for the customer as they can start leveraging Azure for their business continuity planning. This benefit is part of AHB and only available in Azure.
- In February, 2025, we will be retiring SQL Server 2019 Big Data Clusters. All existing users of SQL Server 2019 with Software Assurance will be fully supported on the platform and the software will continue to be maintained through SQL Server cumulative updates until that time. Read the “Changes to SQL Server analytics” blog post for more details.
Why buy from Microsoft Store
Fast, free shipping
Microsoft Complete
Free 60-day returns
60-day price protection
- Discounts: Supplies limited. Actual savings depends on product availability.
- Returns: Available with eligible physical products purchased from Microsoft Store online and Microsoft Experience Centers in select markets. Return process must be started within 60 days after customer receives the product. Limit 5 product returns per eligible customer purchase. Excludes ROG Xbox Ally X, ROG Xbox Ally, Surface Hub, HoloLens, and Windows DevKit. Applicable return policy applies. For purchases made at Microsoft Store, see applicable Microsoft Terms of Sale for more information. For purchases made at a Microsoft Experience Center, see receipt for more information. Microsoft reserves the right to modify or discontinue offers at any time.
- Price protection: Microsoft Store Price Adjustment: Valid on purchases of qualifying new or refurbished consumer and commercial physical products made at Microsoft Store and Microsoft Experience Centers in select markets for 60 days from the date product is received. Eligible Retailer Price Adjustment: Valid on purchases of qualifying new consumer physical products from Microsoft Store and Microsoft Experience Centers in select markets for 60 days from the date product is received. Excludes commercial and refurbished products. An Eligible Retailer Price Adjustment cannot be requested at time of purchase. Microsoft reserves the right to verify an eligible retailer’s advertised price and availability of the product. The product sold by the eligible retailer must be identical to the product sold by Microsoft and must be in stock for purchase at the eligible retailer at the reduced price. Exclusions apply. Both price adjustments: Price Adjustment must be requested within 60 days after the customer receives the product and cannot be completed at time of purchase. Customer is eligible only if the product is in stock for purchase at Microsoft Store or a Microsoft Experience Center. Customer must contact Microsoft to request the adjustment. For purchases from Microsoft Store, contact Microsoft Store Sales and Support with your Microsoft Account information and any other information requested by a representative. For purchases from a Microsoft Experience Center, you must return to the location with your receipt. Limit 1 price adjustment total per product. Excludes Surface Hub, HoloLens, and Windows DevKit. See Microsoft Store Price Protection for full terms and full list of eligible retailers.
-
Trade-In: Available only through the Microsoft Store online in Canada. Offer valid for reimbursements after trade in of qualifying devices (PC, laptop, mobile phone, tablet, video game console). Recycled devices are not eligible for cash back. To be eligible for trade in, you must own the qualifying device, device must power on, battery must hold charge and not be required to be plugged in to operate, and be in fully- functional, working condition without broken/missing components, cracked display/housing, liquid damage, modification(s) or have device warranty seal broken. Device cannot be password protected, and must include original chargers/accessories, and must contain hard drive. Customer must mail in the qualifying trade-in device to be eligible for the reimbursements. All trade-ins are final. Cannot be transferred or otherwise redeemed for cash or gift cards, or credit towards other devices or products. May not be combined with other offers. Applicable return policy applies to each purchase. Promotional items given, or discounted products bought with, a qualifying product are not valid or must be returned if the qualifying product is returned. Microsoft reserves the right to modify or discontinue offers at any time. Other exclusions and limits may apply.
Microsoft reserves the right to modify or discontinue offers at any time.
System requirements |
|
Supported languages |