Category: Miscellaneous

Miscellaneous

How to Migrate from Oracle ASM to AWS using AWS DMS

The Oracle Automatic Storage Management (ASM) database framework provides a volume manager and a file system for Oracle database files. It supports single-instance Oracle Database and Oracle Real Application Clusters (Oracle RAC) configurations. ASM has tools to manage file systems and volumes directly inside a database. These tools enable database administrators (DBAs) to control volumes …

Miscellaneous

How to create Intermediate Measures in Analysis Services (SSAS)

The whole premise of Analysis Services (SSAS) is to place business logic into a central repository (a database). This central repository should be easy to understand from the average reporting user. Simplicity for SSAS databases starts with the Dimension and Fact tables in a data mart or data warehouse. These tables need to have as …

Miscellaneous

How to Schedule Database Backups with ClusterControl

Database backup is a critical part of database management, and has to be carefully planned. Scheduling a backup is not enough, backup data also need to be verified for consistency and integrity. There are other considerations like encryption, and archiving off-site. A good backup manager would have features that take into account all these different …

Miscellaneous

Data Encryption Using Always Encrypted in SQL Server

Introduction Data security is always a matter of concern for organizations and application users. The key challenge for any developer or architect is to understand all the concerns and build a foolproof system to ensure data security.  This is not only more intense, but more complex these days, as many organizations are planning to move …

Miscellaneous

How to Install Liferay CMS on Debian 9

Liferay is a free and open source content management software written in Java and uses MySQL to store their data. Liferay is a web based application portal that can be used to build websites and portals as an assembly of themes, pages, and a common navigation. Liferay comes with simple and easy to use programming …

Miscellaneous

Increasing functional testing velocity with pt-query-digest

Whenever we do upgrades for our clients from one major version of MySQL to another we strongly recommend to test in two forms. First, it would be a performance test between the old version and the new version to make sure there aren’t going to be any unexpected issues with the query processing rates. Secondly, …

Miscellaneous

An Overview of Database Indexing in PostgreSQL

Database Indexing is the use of special data structures that aim at improving performance, by achieving direct access to data pages. A database index works like the index section of a printed book: by looking in the index section, it is much faster to identify the page(s) which contain the term we are interested in. …

Miscellaneous

Oracle Database 18c : Now available on the Oracle Cloud and Oracle Engineered Systems

Oracle Database 18c, as I mentioned earlier, is the next iteration of Oracle Database 12c Release 2 and as a result, it has a lot of the incremental enhancement aimed to improve upon this important release. With that in mind, let’s remind ourselves what was in Oracle Database 12c Release 2. The release itself focused …

Miscellaneous

Troubleshooting MySQL Crashes Webinar: Q&A

In this blog, I will provide answers to the Q & A for the Troubleshooting MySQL Crashes webinar. First, I want to thank everybody for attending our January 25, 2018, webinar. The recording and slides for the webinar are available here. Below is the list of your questions that I was unable to answer fully during …

Miscellaneous

Performing a Live Migration from a MongoDB Cluster to Amazon DynamoDB

Migrating data from one database to other can be quite challenging with respect to data consistency, downtime of applications, and key design differences between the target and source databases. AWS Data Migration Service (AWS DMS) helps you migrate databases like MongoDB, Oracle, MySQL, and Microsoft SQL Server to AWS quickly, securely, and seamlessly. The source …