(Uday Varagani) Recently, I received a support request where the customer wanted to convert an INTEGER column to BIGINT on two tables. These tables are related by a foreign key, and it is a 3 node PXC cluster.
Other News
deleting orphaned CommVault backups
(Martin Berger) In the current environment Commvault is used as a central backup solution. The setup is not very common, as CommVaults scheduler is not used for any activities.
Online Redo Log Switch Frequency Map
(Zahid Anwar) A query I find myself often running is the online redo log switch frequency map query, which queries the v$log_history/gv$log_history (for cluster databases) view and show the historical log switch frequency.
Performance Hub in Oracle Autonomous Database
(Jeff Smith) Our serverless offerings for Oracle Autonomous Database, Data Warehouse and Transaction Processing launched a new feature this week, the Performance Hub.
SQL SERVER – Automatic Seeding of Availability Database ‘SQLAGDB’ in Availability Group ‘AG’ Failed With a Transient Error. The Operation Will be Retried
(Pinal Dave) Earlier I have written few blogs about automatic seeding feature. In this blog we would learn how to fix error: Automatic seeding of availability database ‘SQLAGDB’ in availability group ‘AG’ failed with a transient error.
JavaScript Closures for C and Pascal Programmers
(sickfile) demystify the inner workings of JavaScript closures
SQL Server 2019 Query Store And SSMS
(blobeater) While not specific to SQL Server 2019 (I was using this version to do some testing) I was struggling to find how to change the time period of analysis for the Query Store reports within SSMS.
Is That Database in Use?
(Jason Brimhall) Does anybody know who or what is using this database? Better yet, is the database being used by anything at all? Have you ever asked those types of questions of your staff in an environment you have inherited?
Early stage predicate evaluation with DECFLOAT and implicit casts
(Xiaohong Fu) Indexable and/or stage 1 predicates can be evaluated at the early stage during row retrieval.
Configuring a Server-side Blazor app with Azure App Configuration
(Brady Gaster) With .NET Core 3.0 Preview 6, we added authentication & authorization support to server-side Blazor apps. It only takes a matter of seconds to wire up an app to Azure Active Directory with support for single or multiple organizations.