SQL Server Maintenance Plan
Introduction: A SQL Server Maintenance Plan is an essential strategy for managing and optimizing the performance of your SQL Server databases. These plans are designed to automate routine database management…
Read MoreSQL DB Linked Servers
Introduction: SQL Server Linked Servers is a feature in Microsoft SQL Server that allows you to connect and execute commands against OLE DB data sources on different servers. This functionality…
Read MoreSQL Server Show Plan Permission
Introduction: In this blog, we will explore what Show Plan permission is and how it can help DBAs and developers gain insights into the Estimated and Actual Execution Plans. Show…
Read MoreSQL Server Query Store
Introduction The Query Store is a feature in SQL Server that provides insight into query performance by tracking and storing detailed information about query execution over time. The Query Store…
Read MoreScript to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time
Script to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time Use-Case: In general during the migration process/Go-Live the downtime of the server will be…
Read MoreMove concurrent program from One Instance to Another Instance having same name as old instance. Working as same as under old instance same responsibility and request group
Move concurrent program from One Instance to Another Instance having same name as old instance. Working as same as under old instance same responsibility and request group Step 1) we…
Read MoreOracle EBS – Query to get Purchase Order Details approved based on Hierarchy
Oracle EBS – Query to get Purchase Order Details approved based on Hierarchy Select * from ( SELECT TO_CHAR (SYSDATE, ‘DD-MON-YYYY HH:MI:SS’) rp_run_date, po.* FROM (SELECT ou, supplier_number, supplier_name, po_number,…
Read MoreOracle EBS – Query to get Open Purchase Order Details
Oracle EBS – Query to get Open Purchase Order Details SELECT org_code, org, operating_unit, buyer, supplier, po_number, line_num line_number, item_code item, item_description description, quantity, unit_price price, need_by_date, shipment_line_num, shipment_qty, shipment_needby_date,…
Read MoreUnveiling Oracle 23c: The Game-Changing Features Revolutionizing Database Management
Exploring the New Features in Oracle 23c: What You Need to Know Oracle’s latest release, Oracle 23c, brings a suite of new features and enhancements designed to improve database management,…
Read MoreOutline of the Oracle Autonomous Health Framework (AHF)
Introduction In today’s fast-paced digital landscape, maintaining the health and performance of your Oracle databases is critical. The Oracle Autonomous Health Framework (AHF) is your go-to suite of tools for…
Read More