We are able to create Scalar User-Defined Function in SQL Server 2016 for Memory Optimized tables. For In Memory OLTP and Memory Optimized Tables, I …
Read More »
How To Export a Table Without Blob Column in Oracle
It is possible to export a table containing BLOB data without data in the blob column. Starting with 11g r2, REMAP_DATA can be used with …
Read More »
Generate In-Memory OLTP Migration Checklists(Objects in the Database is practicable to In-Memory OLTP?)
In this article, I will share What is Generate In-Memory OLTP Migration Checklists. If you want to learn What is In Memory OLTP and In-Memory …
Read More »
How To Check Undo Tablespace Usage in Oracle
Undo tablespace is extremely used during peak times. There is a possibility that some operations may be interrupted if you go uncontrolled. You should regularly …
Read More »
Are You Ready for the Oracle Database 19c Administration Certification?
Why DBA should pass the Oracle Database 19c OCP exam? DBA should get ready for new features & they should test themselves through latest certification. …
Read More »
SQL Server Database Administrator’s Roadmap
In this article, I will describe the tasks and responsibilities of “SQL Server Database Administrator“. I will link to articles about how each item can …
Read More »
How To Setup Passwordless ssh in Exadata Using dcli
Although passwordless ssh connection is established between compute node and cell nodes in the Exadata installation, this connection can be broken due to some problems. …
Read More »
UpdateUptimeRegKey: Operating system error 5(Access is denied.)
This is because the user account that the SQL Server service is running on is not authorized in the MSSQL Registry files. Solution -> Run …
Read More »
How To Find Wasted Space in Table in Oracle
Gaps occur in the blocks due to deletion operations in the tables. These spaces remain as wasted space. These spaces should be determined and shrink …
Read More »
Auto Update Statistics in Memory Optimized Tables
With SQL Server 2016, support for automatic update statistics in Memory Optimized Tables is available. If the database is created with compatibility level 130, nothing …
Read More »