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...
As a part of my passion, I try to help people in fixing simple issues and explain the behavior by looking at logs. Here is an email from my friend about Availability Group Missing or Deleted Automatic...
Postgres includes lots of monitoring tools that allow you to see what is happening, but there are a few settings that really go into detail, e.g. log_statement_stats: SET client_min_messages = log; S...
I previously talked about PolyBase and its enhancements (see PASS Summit Announcements: PolyBase enhancements). There is some confusion on PolyBase use cases as they are different depending on whethe...
My database is in the recovery pending state and I want to get in and extract the data out into a new database, I have NO BACKUPS available so some data (even if it is dodgy) is better than nothing. …...
