Review of article: Tracking use of Deprecated SQL Server Features by Phil Factor. Factor (real name withheld to protect the guilty), aka Database Mole, has 30 years of experience with database-intensive applications.
In their words “… how to use SQL Prompt, or SQL Change Automation, to detect use of deprecated SQL Server syntax during development, and Dynamic Management Views and Extended Events to track its use on working databases.”
Factor discusses tracking deprecated SQL Server features in development using Redgate SQL Prompt, during builds with Redgate SQL Change Automation (SCA) and for live databases using performance counters or extended events.
Factor includes scripts to check for deprecated syntax on a working database as well as scripts to get deprecated syntax data and reports from extended events.
Factor’s article discusses the essence of several ways to check and report on deprecated features of SQL Server used in your applications.
So my fellow DBA colleagues, you are already pro-actively fixing your own scripts and sql code when a feature is being deprecated in SQL Server. Right??????
How you address application issues due to deprecated SQL Server features is a whole other issue between you and the development teams! Good luck with getting agreement on time and resources to fix the deprecated SQL Server features issues before they become problems.
The article “Tracking use of Deprecated SQL Server Features” by Phil Factor gets a thumbs up! Right?
Note: In Deprecated Database Engine Features in SQL Server 2017 Microsoft says “… we may choose to permanently remove the feature from SQL Server if it limits future innovations … For new development work, we do not recommend using deprecated features.”
Note 2: “SQL Server 2019 did not deprecate any database engine features” according to Deprecated database engine features in SQL Server 2019 (15.x)
ECourses4You – Python Programming Bundle – Become a Python Programming guru with the Python Programming Master bundle of online training courses!
Pearson Education (InformIT) – eBook Deal of the Day
Pluralsight – Start your Free Trial today! – Don’t let technology outpace you. Work smarter and master your craft with a technology learning platform that will help you build better and create more.
RetiredDBA.com is compensated if you click to an advertiser website and/or you make a purchase after clicking to an advertiser website. This does not INCREASE the price you pay. The income is used to continue to provide as much free content as possible.