(Pinal Dave) During the recent consulting engagement Comprehensive Database Performance Health Check with SQL Server 2017/2019, my client asked me if I can help them enable the new feature of Row Goal.
Other News
Getting Started With HTTP Client Get Request In Angular 8 Using Entity Framework
(Rupesh Kahane) In this article, I am going to consume RESfFul API in Angular 8 using the HttpClient module Get request using the entity framework. The HttpClient module is used to GET, POST, PUT, PATCH, and DELETE requests. An Angular application can communicate with backend services over HTTP.
Nesting with Java interfaces
(Jeff Friesen) If you’ve read my Java 101 tutorial introducing static classes and inner classes, you should be familiar with the basics of working with nested classes in Java code.
MySQL 8 Minor Version Upgrades Are ONE-WAY Only
(Marco Tusa) In the many years we have used MySQL, we got accustomed to the fact that upgrades from MySQL 5.7.11 to 5.7.12 was a minor event. This meant that if something was going wrong, we could roll back the binaries and be happy again.
Inserting middleware between UseRouting() and UseEndpoints() as a library author – Part 1
(Andrew Lock) This post is in response to a question from a reader about how library authors can ensure consumers of their library insert the library’s middleware at the right point in the app’s middleware pipeline.
Recover a database using RMAN but failing to open redo
(David_89) When using RMAN to restore and recover the database, it seems to work OK – no obvious errors during the restore / recovery, as far as I can see.
SQL Server Best Practices for Data Quality
(Jeremy Kadlec) Accurate data is imperative for an organization to conduct cost effective decision making, marketing promotions, mailings, database bloat impacting performance, storage and more. Like everything else, change is constant for your data. There is a need to cleanse and validate data wh
MySQL 8.0.19 Replication Enhancements
(Luis Soares) Here comes another MySQL release, and together with it, a set of new replication features. As usual, we would like to summarize them. And, also as usual, follow up blogs will provide further details.
Experiment: Wrapping CFThread Execution In A FusionReactor Tracked Transaction In Lucee CFML 5.2.9.40
(Ben Nadel) Now that I have FusionReactor running in our production Lucee CFML apps, I’ve been spending a lot of time trying to understand how I can best leverage its functionality.
Quick Tip: Stripping out your Java/Python from your SQL
(Jeff Smith) Have some SQL in your Java or Python app that needs some work?