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. …...
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...
