As technology evolves, so do the lifecycles of the platforms we rely on. Microsoft’s Fixed Lifecycle Policy provides clear timelines for support, and understanding these dates is critical for maintaining security, compliance, and performance. This article explores the end-of-life (EOL) schedules for SQL Server 2017, SQL Server 2019, and Windows Server 2016, and what organisations should do to prepare.
SQL Server 2017:
- Release Date: September 29, 2017
- Mainstream Support Ended: October 11, 2022
- Extended Support Ends: October 12, 2027
SQL Server 2019:
- Release Date: November 4, 2019
- Mainstream Support Ends: February 28, 2025
- Extended Support Ends: January 8, 2030
SQL Server 2017 & 2019 are now currently in their extended support phase, which means Microsoft only provides critical security updates and essential bug fixes. No new features or design changes are introduced during this period.
Implications:
- Reduced innovation and feature enhancements
- Limited support for non-security issues
- Growing risk of compliance and security vulnerabilities
Key Considerations:
- Organisations should begin planning upgrades or migrations
- Extended support limits proactive fixes and feature updates
- Compliance risks increase with aging infrastructure
Windows Server 2016: Extended Support in Progress
- Release Date: October 15, 2016
- Mainstream Support Ended: January 11, 2022
- Extended Support Ends: January 12, 2027
Windows Server 2016 is widely deployed but nearing the end of its lifecycle and is now in extended support, receiving only critical patches.
Risks of Staying on Windows Server 2016:
- No new features or performance improvements
- Higher exposure to malware and ransomware
- Compatibility issues with modern applications
- Potential non-compliance with industry regulations
What Should You Do?
- Upgrade Strategically Consider upgrading to the newer versions such as SQL Server 2022 or Windows Server 2022, which offer enhanced security, performance, and cloud integration.
- Explore Cloud Options Platforms like Azure SQL Database and Azure Virtual Machines provide scalable, secure alternatives with managed services.
- Purchase Extended Security Updates (ESU): If you are not ready to upgrade or migrate, consider purchasing an ESU subscription to receive critical security updates for up to three years past the end of support date. This option is only available for Software Assurance or subscription licenses.
- Plan Early Don’t wait until support ends. Begin testing and validating your upgrade paths now to avoid last-minute disruptions.
As these platforms approach or enter extended support, organisations should proactively assess their infrastructure and plan for upgrades or migrations to ensure continued security, performance, and compliance. Do you have the correct licenses to upgrade? Contact us to check and we can confirm the options.