Question: How to Enable Auto Update Statistics and Auto Create Statistics? Answer: I have received this question after watching my free webinar on group by conference by one of the user. I really lov...
I was trying to set up database mirroring in my freshly created Azure Virtual Machines and encountered an error. The error was talking about the connectivity problem, but it was something else. Let us...
I. Introduction In the IT industry we go through a tedious and long process of acquiring infrastructure (hardware software and licenses). Typically, projects are held back due to infrastructur...
We started to detail the concept and workings of Consolidation Planning for the Cloud, using Oracle Enterprise Manager Cloud Control 13c, in the previous partsof this article series. This is Part VII....
Indexing data for fast and efficient retrieval is one of the data preparation tasks in data science. MongoDB is the most commonly used NoSQL database and the fourth most commonly used database (relati...
I have been pretty busy recently working with Joe Sack from Microsoft and getting my hands dirty with SQL Server vNext accessing some cool stuff (which obviously I can’t talk about – under NDA) and b...
Read the complete post at blog.4loeser.net/…/security-and-compliance-for-ibm-dashdb.html...
Have you ever been in a situation where SQL Server shuts down by itself? It sounds strange but I met across a gentleman in flight who reported this issue to me. Since I was curious to know the cause, ...
This might not be relevant anymore, shame on me for keeping it draft for few months. However, there are still people running an older versions of Exadata storage software and it might still help someo...
The following case just want to share it in case anyone need it, development wants to import the existing table in the siebel schema into the new name to check the data integrity: Oracle Provide you w...
I have started blogging on my site long ago and my whole idea was to make script repository so that others can reuse it. Now when I look back, there are many scripts and many solutions which I have w...
Not sure what Windows as a service is? With Windows 10, Microsoft moved to deliver Windows as a service which introduces a new way for how it’s built, deployed and serviced. Start by viewing this 5-m...
