(Jeff Smith) I love tips, and I love lists. I’ve written a top 10 tips post, but it was way back in 2012. And those tips are still good, but the software and my perspective have definitely changed since then.
Other News
Oracle 19c Automatic Indexing: Common Index Creation Trap (Rat Trap)
(Richard Foote) When I go to a customer site to resolve performance issues, one of the most common issues I encounter is in relation to inefficient SQL. And one of the most common causes for inefficient SQL I encounter is because of deficiencies the default manner by which the index Clustering Facto
Db2 Location Statistics Traces for Remote Applications
(James Pickel) Do you have a significant amount of work coming into your Db2 for z/OS subsystems through the Distributed Data Facility? If so, this article may be of interest to you.
Jackson, JSON and the Proper Handling of Unknown Fields in APIs
(Gilvan Filho) How to proper deserialize json to java objects without facing UnrecognizedPropertyException when getting unkown fields or properties when consuming rest API.
Azure SQL Database Migrating across Tiers
(blobeater) A quick post today about moving across database tiers. As you can see below I have a General Purpose Serverless Gen 5 1 vCore database (currently paused).
Let’s Develop an Angular Application – Angular Forms Introduction
(Shervin Cyril) After reading this article, we will have an overall idea of Angular forms.
SQL SERVER – User Statistics Report for Database – SSMS
(Pinal Dave) Yesterday while, I was working with a client on the Comprehensive Database Performance Health Check we found a very interesting scenario with our client. We figured out that we have many active sessions from different users.
Find a corrupted innodb table or a corrupted index from index id
(Paul Moen) Your favourite monitoring software throws an alert or sends an email after it finds the following in the mysql error log:
Scope Traversal Behavior With Undefined Function Arguments In Lucee CFML 5.3.6.61
(Ben Nadel) Just now, as I was looking at iterating over Structs using CFLoop in Lucee CFML, I ran into a fun little behavior of the ColdFusion language: Scope traversal will skip-over undefined function arguments and access like-named values in higher-up scopes.
GitHub Integration with Azure DevOps
(Subodh Sohoni) This tutorial demonstrates how to use Azure DevOps and GitHub collaboratively. You will learn to connect and integrate Github with Azure Boards, integrate Github in Visual Studio, and use Azure Pipelines to build and deploy code under Github.