Upgrade Your SQL Server 2014 Before Support Ends

Upgrade Your SQL Server 2014 Before Support Ends

Introduction and Background

About House of Brick

In our over twenty-five-year history at House of Brick, we have worked with tens of thousands of Oracle, SQL Server, PostgreSQL, and MySQL customers on all types of database initiatives related to optimization, performance, business continuity, compliance, and best practices. Our consulting expertise was not just specific to the database engine but also advising Clients how to best utilize the different platforms available for deployment (on-prem, virtual, converged/hyper-converged, and cloud) to meet organization goals for availability, performance, and budget.

House of Brick was an early pioneer in the VMware before Broadcom community for migrating Oracle and SQL Server from legacy physical platforms to ESXi, and later for coaching Clients on the process to migrate and best leverage AWS, Azure, and other clouds.  Over the many years in business, our team has upgraded and patched multiple operating systems for business-critical databases including Windows Server, Linux, Solaris, AIX, and HP-UX.

SQL Server and Windows Server Migration Services

If you spend time on houseofbrick.com you will see a lot of content for the work we do with Oracle software compliance including Java, also Oracle and SQL Server database to AWS migrations, and content on how our database and platform expertise is valuable for any organization looking to make informed decisions on architecture through their digital transformation process. All exciting services work that our team welcomes opportunities to deliver.

While so much we do as a company is to help customers get their databases to the latest and greatest platforms and plan for future environments, our company still offers the much needed and required services for keeping SQL Server and Windows Server patched and upgraded to Microsoft Corporation supported versions.

Importance of Keeping SQL Server and Windows Server Up-to-Date

Reminder that Microsoft SQL Server and Windows Server customers should keep their environments current for the reasons below:

  • Security: the latest updates and patches assist with cyber security protections.
  • Compliance: outdated software can lead to non-compliance with legal issues & financial loss.
  • New Features: updated versions have new functionality and benefits.
  • Technical Support: maintain access to Microsoft Support to stay reliable and secure.

Urgency to Upgrade from SQL Server 2014 with Microsoft End-of-Life on July 9, 2024

The extended support date for SQL Server 2014 is coming up on July 9, 2024. For any customers still using the 2014 version of SQL Server, you will want to upgrade to a later supported release now. Reminder below on what it means when Microsoft moves a SQL Server or Windows Server to end of life (EOL) status.

  1. Mainstream Support Date: This is when Microsoft ceases new feature updates and complimentary support.
  2. Extended Support End Date: This is when Microsoft stops all support, including security updates and patches.

The SQL Server and Windows Server versions with mainstream and extended support dates in the table below with the highlighted date for SQL Server 2014:

SQL Server VersionMainstream Support End DateExtended Support End Date Windows Server VersionMainstream Support End DateExtended Support End Date
2008July 8, 2014July 9, 2019 2008Jan 13, 2015Jan 14, 2020
2008 R2July 8, 2014July 9, 2012 2008 R2Jan 13, 2015Jan 14, 2020
2012July 11, 2017July 12, 2022 2012Oct 9, 2018Oct 10, 2023
2014July 9, 2019July 9, 2024 2012 R2Oct 9, 2018Oct 10, 2023
2016July 13, 2021July 14, 2026 2016Jan 11, 2022Jan 12, 2027
2017Oct 11, 2022Oct 12, 2027 2019Jan 9, 2024Jan 9, 2029
2019Jan 7, 2025Jan 8, 2039 2022Oct 13, 2026Oct 14, 2031

SQL Server & Windows Server Migration Phases

The House of Brick consulting services teams can assist in all phases for a successful SQL Server and Windows Server migration project, as described below: 


This includes an evaluation of the SQL Server databases and applications to identify upgrade paths and tools that should be involved in the migration.

Selection of Optimal Versions and Platforms

House of Brick assists Clients to select the most appropriate versions and platforms (we could recommend a migration to AWS or Azure, hybrid solution, or on-prem infrastructure) while taking into consideration cost, performance, scalability, and other workload requirements.

Developing a Migration Strategy

Creating detailed plans including migration steps, timelines, milestones, roles and responsibilities from both Client team and House of Brick. This also includes risk mitigation strategies and pre-requisites such as backup and restores, user acceptance testing, and rollback plans in case of unexpected issues.

Pre-Migration Testing

Our consultants work with Client project team members to deliver testing in non-production environments. This process will identify potential issues that should be accounted for when the upgraded environments are configured optimally for consistent performance.

Migration Execution

Kicking off and executing the migration plan during customer selected timeframes with least disruption to business operations. Our team can participate and monitor the process and engage when required for root cause analysis and troubleshooting of issues.

Post-Migration Performance Validation

Deliver a comprehensive review for application and database functionality looking at data integrity, performance, and reviewing security configurations.

How to Get Started with House of Brick

How House of Brick Can Help

Please contact your House of Brick Client Services Director to schedule a web meeting discussion on how our Professional Consulting Services team can help through a SQL Server and/or Windows Server migration engagement. We will have one of our Principal Architects on the call to ask questions about your SQL Server and Windows Server environments, with a goal to produce a scope of work. Our proposed services engagement will address the gaps where expertise from our team may be needed as you modernize your SQL Server instances and Windows Servers.

Managed Services for SQL Server

If you are considering House of Brick to migrate SQL Server to a supported version and may be interested in a long-term arrangement for our team to stay engaged to keep your SQL Server instances current, House of Brick offers monthly Managed Services for SQL Server. Managed Services includes our team of SQL Server experts continually assessing SQL Server health, patching, maintaining, and troubleshooting database issues over an extended duration. This allows our customer SQL Server DBA and Windows System Administration contacts to focus on other revenue generating business activities versus allocating time to routine IT operations.

Continuously Assess Your SQL Server Risk

House of Brick also has our OpsCompass for SQL Server SaaS product that can assist with tracking your SQL Server versions and where the databases reside whether on-prem or in the cloud.  It is an excellent solution to identify risk with SQL Server security and compliance issues.  Many SQL Server customers are looking for efficient ways to automate management, and OpsCompass should be part of your solution. See for yourself.


It is important to keep SQL Server and Windows Server on Microsoft Corporation supported versions. The House of Brick team routinely delivers both SQL Server and Windows Server migrations, patches, major upgrades, and we know all the processes extremely well. Please leverage our team experience to make sure your organization isn’t caught out of compliance or unsupported.

Table of Contents

Related Posts