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-6606061c60e78718240087/] 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 »How To Change Exadata Cellnode Configurations
When the “ip”, “ntp” or “ilom” information is changed on the Exadata cellnodes, some operations must be performed. You can perform these operations by following …
Read More »Verifiy Exadata Configuration File
The configuration files on the compute node and the cell node can be corrupted by manual changes. “/opt/oracle.cellos/cell.conf” configuration file should not be modified unless …
Read More »