RetiredDBA.com

All things for Microsoft SQL Server

Dbas are you self-deprecating?

Oct 1, 2020


Gif provided by Giphy.com

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)


Ad

Udemy – Microsoft SQL Server 2019 – An introduction

Udemy – Get top courses for as low as $12.99!

ECourses4You – Python Programming Bundle – Become a Python Programming guru with the Python Programming Master bundle of online training courses!

FutureLearn – Develop your coding skills with an online course from FutureLearn. Join for free.

Pearson Education (InformIT) – eBook Deal of the Day

Edureka – Data Science Training by Edureka Drive Business Insights from Massive Data Sets Utilizing the Power of R Programming, Hadoop, and Machine Learning.

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.

Pluralsight – Get your Skill IQ with a Free Assessment from PluralSight

Whizlabs – Online Training for Agile Certified Practitioner (PMI ACP)® Certification Exam | Enroll Now

Edureka –

Start your future with a Data Science Certificate.


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.



Advertisement

Ally - Get a bonus when you open an eligible Ally Bank account.

Amazon Prime Visa - Get a Amazon Gift Card instantly upon approval of Amazon Prime Visa

Chase Checking - Open your Chase checking account and get a bonus!

Chase Freedom Flex - Earn unlimited cash back with the Chase Freedom Flex credit card.

Chase Freedom Unlimited - Earn cash back with the Chase Freedom Unlimited credit card.

Chase Saphire - Open your Chase Saphire Preferred or Reserve and get bonus points and more!

Discover - Get a bonus when you open an eligible Discover account.

Marriott Bonvoy Credit card - Open your Marriott Bonvoy Credit card and get a new Cardmember bonus!

Rakuten - Sign up for Rakuten and earn cash back on your purchases at 3500+ stores. 20M+ members in the U.S. have earned over $3.2B in Cash Back at their favorite stores.

Schwab - Open a Schwab account and get up to $1,000 depending on your net deposit.

Xfinity - Open an Xfnity mobile or internet account and get a bonus