Each database administrator wants to detect and delete unused logins. By default in SQL Server, the last time the login was logged is not stored …
Read More »MSSQL
How To Check Page Verify Option of Databases Using Policy Based Management
Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …
Read More »ORA-20001: Statistics Advisor: Invalid task name for the current user
During the 12c database creation process , you can see ORA-20001 error in the alert log file when the “SYS.ORA $ AT_OS_OPT_SY_ <NN>” auto job …
Read More »How To Check Last Log Backup Time Using Policy Based Management
Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …
Read More »How To Check Auto Close Option of Databases Using Policy Based Management
Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …
Read More »How To Check Whether Data File Sizes is Reached a Specific Size Using Policy Based Management
Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …
Read More »How To Check Whether Readable Secondary is Enabled on Availability Groups Using Policy Based Management
Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …
Read More »How To Check Availability Group Automatic Failover Settings Using Policy Based Management
Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …
Read More »How To Check Availability Group’s Backup Preference Using Policy Based Management
Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …
Read More »How To Check Whether Availability Groups is Ready To Failover Using Policy Based Management
Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …
Read More »