In this article we are going to give an overview of this application called PhpMyAdmin, which is one of the most popular applications for the management of MySQL databases. Throughout my professional ...
Hi, There is quite the scenario that the Oracle Cost-Based Optimizer (CBO) uses when deciding when to use indexes to process your SQL. I go into this in great detail in my SQL Performance Tuning cours...
Read the complete post at blog.4loeser.net/…/ibm-bluemix-in-germany-includes-dashdb.html...
TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file too. I fancied looking inside the MDF and a backup of my database before enabl...
Padding zeroes to an integer is often required during data migrations and integrations. Here is the approach I use in such data conversions. Read the complete post at feedproxy.google.com/…/...
Just another day while doing performance tuning engagement, Senior DBA of the organization and I both noticed that one of the SP sp_readrequest is continuously listed as long running SP. Well, the go...
In This Post i will show how to create backup for Dbaas Open the Oracle Database Cloud Service console. Click the database deployment for which you want to create a backup. Click the Administration ...
Question: How to Find How Many Rows Each Query Returned Along with Execution Plan? Answer:During my performance tuning consultancy engagement, this is one of the most asked questions. Everyone wants ...
If you work with a product for a long time, you would start loving it. I have worked with many other RDBMS, but my love to SQL Server will never die. The amount of information available in logs is ver...
Hi, I have used this option to show SQL bind variable content for a while, I want to show you how I avoid running SQL Trace with this Toad Explain Plan feature. Toad has also made it very easy to run ...
With the loss of the Oracle Standard Edition One license, and the free Oracle Express Edition database stuck at the old 11g Release 2 from 2014, many smaller projects are considering whether MySQL mig...
Microsoft is headed to San Jose this week where they will be announcing new features for HDInsight and DocumentDB at Strata Hadoop + World. Additionally, the company is also announcing a new preview f...
