Windows 10: KB5025229, Server 2019, SQL 2019 - update breaks stored procedures

OS: Windows Server 2019 DataCenterSQL: SQL Server 2019 Standard EditionIssue: After installing KB5025229, specific stored procedures that call other stored procedures are broken. Scenario: Stored Procedure calls two other stored procedures that organize data utilizing PIVOT tables using EXEC functionality. When called by a Report, or ran in SQL Ma

:)

 

upgrade feasibility from SQL Server 2008 to 2019

Hi Experts,

We have a requirement to upgrade legacy applications from SQL Server 2008 / Windows 2008R2 to SQL Server 2019 / Windows 2019

SQL Server 2008 Enterprise -> SQL Server 2019 Enterprise

SQL Server 2008 Standard -> SQL Server 2019 Standard

SQL Server 2008 Express -> SQL Server 2019 Standard

We will also be deploying .NET 2.0 code of 4.7.2 framework (Windows 2019) .

Please advise if there will be any feasibility / compatibility issues for the same.

 

Office 2019

Only supported on Win10. Sorry, 8.1 users, only 4 years old, gotta go.

The Verge

https://blogs.technet.microsoft.com...-to-office-and-windows-servicing-and-support/

Spoiler Office 2019
Last year at Ignite, we announced Office 2019 – the next perpetual version of Office that includes apps (including Word, Excel, PowerPoint, and Outlook, and Skype for Business) and servers (including Exchange, SharePoint, and Skype for Business). Today we’re pleased to share the following updates:

• Office 2019 will ship in H2 of 2018. Previews of the new apps and servers will start shipping in the second quarter of 2018.
• Office 2019 apps will be supported on:
  • Any supported Windows 10 SAC release
  • Windows 10 Enterprise LTSC 2018
  • The next LTSC release of Windows Server
• The Office 2019 client apps will be released with Click-to-Run installation technology only. We will not provide MSI as a deployment methodology for Office 2019 clients. We will continue to provide MSI for Office Server products.

 

SQL server 2019 upgrade checkpoints from SQL 2016

Hello Meraj,

I am Jaspreet Singh an independent advisor.

The main Pro of upgrading to SQL server 2019 will be the long term support which 2016 will be getting to the end of in 2021 (mainstream support ending)

Other Pro will be that 2019 update brought a bunch of new cutting edge features that have since been started to be used.

here is a comparison of these new features in 2019 with availability among 2016 and 2017 :

https://www.microsoft.com/en-in/sql-server/sql-...

But since most of these features are new 2019 update has all the issues that plague new releases and you should be ready to keep the updates rolling because you will be getting a lot of patches on pretty significant issues. Alongside that since the update has
been relatively new you will have to work out issues popping up on your own.

This blog summarizes it pretty well :
https://www.brentozar.com/archive/2019/01/which...

Disclaimer: this is a non Microsoft website. The page appears to be providing accurate and safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (potentially unwanted products). Throughly research any product
advertised on the site before you decide to download and install it