There’s no fighting progress. Decades ago database administrators managed and controlled everything – the OS, network, storage and database. Times have changed and DBAs have had to evolve (i.e. accept...
A couple of days ago Oracle finally provided us with an on-premises download for Oracle 12.2 Database. Go and download load it from here or Download the Database App Development VM with 12.2 (This is...
I decided to accept Grant’s (TheScaryDBA) challenge found here- http://www.scarydba.com/2017/03/02/random-blog-post-challenge/ where we have to write a technical blog post that incorporates a certain ...
In this blog post we will discover how to fix an Add Failover Cluster Node Fails With Error. If you have installed SQL Server cluster, then it would be easy for you to remember that it’s a two-step pr...
If you have ever tried to debug a program that used the TSql Script Dom to parse some T-SQL you will know that the process is extremely slow and this is due to the volume of NoViableAltExceptions (and...
Since the announcement of 12cR2 on-premises availability, the Oracle community become energetic and busy tweeting/blogging the new features, demonstrating installation & upgrades. Hence, I have decide...
Following on from yesterdays blog I was wondering about the comparison of objects that were the same and how the IgnoreWhitespace, IgnoreComments, IgnoreKeywordCasing and IgnoreSemiColonsBetweenStatem...
Isn't that something you always wanted to do? 🙂 No, it's not. And I did that yesterday in my dev environment (well, of course, such a thing could never make it to production!). It is an enormous pai...
A nice little error log feature that I noticed in SQL Server 2016 regarding tempdb. Tempdb, a system database in SQL Server, some call it the “public toilet” but honestly it is where temporary user ob...
Once I was thrown into an interesting situation where a client told me that he can see the data from the table but not the table. I asked him to elaborate more and he sent me below screenshots where h...
David Peake, Product Manager de Application Express compartió la nueva directiva para Apex 5.2. Estas serán serán las mejoras que se realizarán!!! Oracle Application Express 5.2 Oracle Application...
"The most important reason for going from one place to another is to see what's in between."-- Norton Juster, The Phantom Tollbooth Recently in an Oracle forum a question resurfaced regarding enablin...
