(Debasis Saha) In the recent few years, Artificial Intelligence or AI has become one of the most discussed and popular subjects in the IT industry.
Community
Creating a Shape Editor in .NET, Part 3
(Hannes DuPreez) Hello and welcome to the third and final installment of this article series. So far, we have done a lot of work by building the shapes, the logic to resize them, the properties of the various shapes, and the lines measuring the distance between the shapes whilst moving them around.
DDL Queries on Foreign Key Columns in MySQL/PXC
(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.
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?