Microsoft announced the availability of Microsoft SQL Server 2019. Microsoft SQL Server 2019 enables enterprises to gain intelligence over all data types, both structured and unstructured, by combining the power of new big data clusters with enhanced data virtualization. These powerful additions to SQL Server enable enterprises to not only store and query big data at scale but also combine it with structured data in whatever database it may reside such as SQL Server, Oracle, MongoDB, PostgreSQL, and others. SQL Server also includes built-in Artificial Intelligence (AI) capabilities to enable comprehensive analytics and AI solutions for all your data needs.
The Microsoft SQL Server 2019 release includes the following products:
- SQL Server 2019 Standard
- SQL Server 2019 Standard Core
- SQL Server 2019 Enterprise
- SQL Server 2019 Enterprise Core
- SQL Server 2019 Client Access License (CAL)
- SQL Server Big Data Node
For further information and the official announcement, please visit: https://cloudblogs.microsoft.com/sqlserver/2019/11/04/gain-intelligence-over-data-with-sql-server-2019-now-generally-available/
According to the August 2019 Microsoft Product Terms, Microsoft Azure Hybrid Benefit now includes options for the Microsoft Azure Dedicated Host. The main aspects of Microsoft Azure Hybrid Benefit for Windows Server and SQL Server remain unchanged. Here’s a summary of the rules for both Windows Server and SQL Server.
What does this benefit offer for Windows Server on Azure Dedicated Host?
Azure Hybrid Benefit for Windows Server on Azure Dedicated Host can be used in three ways:
- Standard edition: Customers with Windows Server Standard edition are entitled to 2 instances, similar to how Azure Hybrid Benefit applies to Windows Server on Azure Virtual Machines (VM) on shared servers. Each 2-processor license or each set of 16-core licenses are entitled to two instances of up to 8 cores, or one instance of up to 16 cores. The Azure Hybrid Benefit for Standard Edition licenses must be used either on-premises or in Azure although customers get 180 days of concurrent use rights while they are migrating their servers. Continue reading Microsoft Azure Hybrid Benefit for Microsoft Azure Dedicated Host
Microsoft Azure Reservations are a way of pre-paying for an Azure resource over a one or three-year term to get the most cost-effective pricing. The Reservations family continues to grow: it started with Reserved Instances, a way of pre-paying for Azure virtual machine base compute, and was extended with Reserved Capacity, a way of pre-paying for Azure SQL Database compute capacity. In 2018, Software Reservations for SUSE Linux software and Reserved Capacity for Azure Cosmos DB throughput were added to the family.
Now the family also includes Microsoft SQL Data Warehouse Reserved Capacity. Microsoft SQL Data Warehouse Reserved Capacity allows customers to buy compute Data Warehouse Units (cDWU) with either 1-year or 3-year options for discounts of up to 65%. Reserved Capacity can be shared by multiple warehouses in the same region and there are exchange and cancel options available if business needs change. Additionally, there are new RedHat Enterprise Linux Software Plans where the rules are stricter in terms of exchanging and cancelling, but discounts of up to 18% are still available.
For further information on Microsoft SQL Data Warehouse Reserved Capacity, please visit https://azure.microsoft.com/en-us/blog/azure-sql-data-warehouse-reserved-capacity-and-software-plans-now-generally-available/.
The following link gives you an overview of Reservations and if you expand the “Buy a reservation” link at the left you can get details on the current five members of the Reservations family: https://docs.microsoft.com/en-us/azure/billing/billing-save-compute-costs-reservations.
Microsoft announced the End of Support for Windows Server and SQL Server 2008 and 2008 R2.
- Extended Support for SQL Server 2008/2008 R2 ends July 9, 2019.
- Extended Support for Windows Server 2008/2008 R2 ends January 14, 2020.
End of support means the end of security updates, which may leave your business exposed to security risks and compliance concerns. Microsoft recommends two possible paths: You can migrate to Azure with free security updates or you can upgrade on-premises to current versions of Windows Server and SQL Server. If you need additional time to manage the transition, you can get three years of Extended Security Updates to keep your workloads protected beyond the deadlines.
For more information please visit: https://www.microsoft.com/en-us/cloud-platform/windows-sql-server-2008. Under the following link you also find helpful answers to frequently asked questions regarding the End of Support for Windows Server and SQL Server 2008 and 2008 R2: https://www.microsoft.com/en-us/cloud-platform/extended-security-updates.
The Microsoft Azure Hybrid Benefit for SQL Server allows you to choose where you use a Microsoft SQL Server license: either on-premises or in Microsoft Azure. Not only that, you’re allowed to choose between a Microsoft Azure virtual machine (Infrastructure as a Service (IaaS)) or the Microsoft Azure SQL Database service (Platform as a Service) (PaaS)). This article describes the details of the two options: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-paas-vs-sql-server-iaas. Customers are eligible for the Microsoft Azure Hybrid Benefit by having active Software Assurance on their licenses or buying a Server Subscription.
Microsoft announced the General Availability of Microsoft Azure SQL Database Reserved Capacity for single and elastic pool databases. Microsoft Azure SQL Database Reserved Capacity is based on the same principal as Microsoft Azure Reserved Instances for virtual machines and allows you to save money by prepaying for SQL Database vCores for a one or three-year term. Additionally, you can bring your own SQL Server licenses (either via active Software Assurance (SA) or the new Server Subscriptions) for an even more cost-effective solution.
SQL Database Reserved Capacity shares other similarities with Reserved Instances too: a Reservation can be assigned to either a single Azure Subscription or shared, and there’s vCore Size Flexibility as well where the Reservation can be applied dynamically to any databases and elastic pools within a performance tier and region.
For more information about Microsoft Azure SQL Database Reserved Capacity, please visit: https://azure.microsoft.com/en-us/blog/announcing-general-availability-of-azure-sql-database-reserved-capacity/.
Microsoft announce Extended Security Updates for Windows Server and SQL Server 2008/2008 R2. Extended Security Updates will be available for purchase as we approach the end of support timeline for SQL Server and Windows Server 2008 and 2008 R2.
- Extended Support for Microsoft SQL Server 2008 and 2008 R2 will end on July 9th, 2019.
- Extended Support for Microsoft Windows Server 2008 and 2008 R2 will end on January 14th, 2020.
Continue reading Microsoft Windows Server and SQL Server 2008/2008 R2 Extended Security Updates
Microsoft announced the launch of the Microsoft Azure Hybrid Benefit for SQL Server. The Microsoft Azure Hybrid Benefit for SQL Server will allow customers to use their existing SQL Server licenses with active Software Assurance toward Azure SQL Database Managed Instance(s) and pay only for the underlying compute and storage.
To find out more about the Microsoft Azure Hybrid Benefit for SQL Server, please visit: https://azure.microsoft.com/en-us/blog/migrate-your-databases-to-a-fully-managed-service-with-azure-sql-database-managed-instance/
The extended support for Microsoft SQL Server 2008 and 2008 R2 ends July 9th, 2019. It is highly recommended to update affected systems before this date.
Microsoft SQL Server 2017 is generally available now. With this release, SQL Server users will be able to choose to deploy in either a Microsoft Windows or Linux operating system environment. Microsoft is also introducing a Microsoft SQL Server for Linux Promotion.
For further information about Microsoft SQL Server 2017 please visit: https://www.microsoft.com/en-us/sql-server/sql-server-2017.