When trying to open the console via ilom, the screen does not turn on due to the incompatibility in the java security settings. You can …
Read More »How To Remote Boot Exadata Servers From Rescue Disk
In the event that the Exadata servers cannot be turned on from the operating system, we can turn on the systems from the rescue disk …
Read More »How To Check SQL Server Error Logs and Operations System Logs
SQL Server Logs and Operating System Logs(Event Logs) are logs that SQL Server Database Administrators checks on a daily basis, or use to find the …
Read More »How To Find Table and Index Sizes in SQL Server
Sometimes we need to list table sizes in SQL Server. For example, we need to find large tables before we start making Compression or before …
Read More »Configure Automatic Shared Memory Management in Oracle
To learn the Automatic Shared Memory Management, read the article titled “Oracle Memory Components(SGA and PGA)“. For databases that do not use Automatic Shared Memory …
Read More »Handy Query : List of MySQL Tables Without Primary Key
Here is my favorite handy query to get the list of tables in MySQL without Primary Key : [crayon-67687d9dbc0ba562392765/] This my shortest article ever, hope …
Read More »SQL Server Compression
We can compress some tables to reduce the size of the table. I / O performance increases as data size decreases. It also increases CPU …
Read More »Column Master Key Rotation Process(Always Encrypted)
In some cases, you may need to change the Column Master Key that was previously created for a table that you encrypt with Always Encrypted. …
Read More »How To Change Exadata Compute Node(db node) ilom Network Configurations
You can change the ilom information of the Exadata compute nodes with the ipmitool tool on the corresponding compute node. The following examples shows how …
Read More »What is Always Encrypted in SQL Server
Always Encrypted is a security solution that introduced with SQL Server 2016. With this solution, application developers can encrypt the columns from the client side. …
Read More »