One of my client was unable to modify the maintenance plan using SSMS. When we did various tests, we found that existing maintenance plans could execute and work. We tried creating a new maintenance p...
With the increasing scale of data stored by web scale applications, several NoSQL databases have become available. The NoSQL databases are different from the relational databases (such as Oracle datab...
Yet another exciting journey with Oracle bugs and challenges. Here is the story for you. One of our recent successful migrations was a single instance Oracle EBS 12cR1 database to Oracle Super Cluster...
One of my client was trying to start SQL Service and it was failing. I asked to hare ERRORLOG so that we will get some idea about the cause. Here is the information from ERRORLOG file. 2017-01-31 01:...
The title is adapted from a child-hood movie of mine and is my daily (database-related) WTF moment and it is my entry for this month’s T-SQL Tuesday found. Having a database in Recovery Pending mode ...
Here are the presentations I gave at OUG Norway last week. These are also available on SlideShare Predictive analytics: Mining gold and creating valuable productfrom Brendan Tierney...
“The only thing you can do easily is be wrong, and that's hardly worth the effort.”― Norton Juster, The Phantom Tollbooth Oracle provides two parameters that affect the PGA that look very similar but...
Less than a week to go until SQLSaturday Iceland now, it’s going to be a busy couple of months for me but am looking forward to it. I’ll get my slides and demos uploaded here at some point. I’ve been...
SQL Server 2016 installations may run into some issues with patching and configuration. This post provides pointers on avoiding these. Read the complete post at feedproxy.google.com/…/...
While I have been blogging about SQL Server for a long time, I still believe that there is still a lot of error which are not discovered by me. It is always fun to see new error and find a fix for the...
You know that patch numbering has been changed since November 2015, and the new format replaces the numeric 5th digit of the bundle version with a release date in the form “YYMMDD”. Let’s say you appl...
During the last week i was working on Oracle Cloud Closely and i would like to summarize what Oracle Cloud Services Provide,and Short Description for each services. Oracle Compute Cloud Service In ...
