(Senthil Rajendran) Oracle EBS 12.2 – ADOP ad_zd_prep.create_patch_service exact fetch returns more than requested number of rows
Community
SQL SERVER – T-SQL Script to Identify TOP 10 Parallel Running Queries
(Pinal Dave) Today we see T-SQL Script to Identify TOP 10 Parallel Running Queries which I wrote as a part of my Comprehensive Database Performance Health Check yesterday’s engagement. You may read my Read What My Clients Say about my performance services here.
Trying To Find My Preferred Format For Method Annotations In Lucee 5.3.2.77
(Ben Nadel) One of the many differences between Adobe ColdFusion (ACF) and Lucee CFML is that Lucee won’t alter the runtime behavior of the ColdFusion code based on JavaDoc-style annotations.
Migrate from a single MySQL Instance to MySQL InnoDB Cluster using CLONE plugin
(Frederic Descamps) When somebody wants to migrate from a single MySQL instance to a full HA solution using MySQL InnoDB Cluster, the best solution to reduce the downtime is to use asynchronous replication and switch database only once at a certain point in time when everything is ready.
Drop Table Partition with Index Maintenance
(Jagruti Jasleniya) We can simply add and drop partitions from table as we are dropping and creating a new table.
SQL Server Logon Trigger Examples
(Bhavesh Patel) Triggers are database objects that store code and get executed automatically when some type of event occurs, such as a data change or change to an object. In SQL Server, there are four types of triggers: DDL Triggers (Data Definition Language), DML Triggers (Data Manipulation Languag
Portal And Error Boundaries In React
(Priyanka Jain) This article talks about the concept of Portal and Error Boundary in React
Azure Storage Explorer
(blobeater) I only ever use the storage explorer when managing my blobs, files, queues within storage accounts.
Ways to access data in ADLS Gen2
(James Serra) With data lakes becoming popular, and Azure Data Lake Store (ADLS) Gen2 being used for many of them, a common question I am asked about is “How can I access data in ADLS Gen2 instead of a copy of the data in another product (i.e. Azure SQL Data Warehouse)?”.
Guru: I’m A Number, You’re A Number, Everybody’s A Number
(Ted Holt) Do you, like Bob Seger, sometimes feel that you are nothing more than a number? Me too. That’s because to many people, that’s exactly what we are.