How to display Report Generating user name at the SSRS Report Footer
Displaying Report Generating the Date time and user name without Domain or System name: 1- Go to Design mode and Create footer in SSRS report 2- From The toolbox add… Read more »
Oracle Golden Gate Overview & Components
Introduction to Oracle GoldenGate Oracle Goldengate enables the exchange and manipulation of data at the transaction level among multiple, heterogeneous platforms. Oracle GoldenGate Architecture allows to replicate selected data, transactional… Read more »
how to resolve ORA-31623: a job is not attached to this session via the specified handle
ORA-31623: a job is not attached to this session via the specified handle ===================== -Issue- When performing Import via impdp, following error is coming:ORA-31623: a job is not attached to… Read more »
How to transfer logins and passwords between instance of sql server
Transfer sql server login from one source server to target server sp_help_serverlogin is a stored procedure which helps to transfer logins and passwords from one instance of a server to… Read more »
Update maintenance window duration in oracle database
Update maintenance window duration in oracle database- Scenario- Current issue is we have default database level gather stats scheduled and maintenance window is 4 hrs, but maintenance task is not… Read more »
Script to check Running database operations in oracle database
Script to check Running database operations in oracle database. This script will provide you the details that what all operations working in background and what all those session related to,… Read more »
Script to Check RMAN Backup status
This script will provide you to check the current running RMAN backup status and backup history whether its completed/running or failed with any issue. set line 190 col STATUS format… Read more »
How to check the free space and Usage of ASM Disk Group
How to check the free space and Usage of ASM Disk Group In this post we have provided 2 scripts , 1st to check the Usage of each ASM disk… Read more »
Find out the Owners of SQL Server Agent Jobs Using TSQL
Find out who are the owners of the SQL Server agent jobs with the help of below script. SELECT J.name AS [Job Name] ,L.name AS [Job Owner] FROM msdb.dbo.sysjobs_view J… Read more »
Select Size of All sql server Databases
How to select size of all sql server Databases Below script will select the size of all your SQL Server databases in MB and GB as well. SELECT d.NAME ,ROUND(SUM(CAST(mf.size… Read more »
How to check index fragmentation on all indexes in a SQL Server database
Check Index Fragmentation on ALL Indexes in a Database I use to make note for my self so that I can recall it quickly! when I am using a development… Read more »