One should be very careful while working with system objects in SQL Server. Below is one of the situation where some permissions were given on system objects which was causing SQL startup failure. I h...
As some of you may know, we've been working on a new "skin" for plsqlchallenge.oracle.com, one that is more modern and responsive, and that makes it easier to quickly take a quiz. The Oracle Dev Gym ...
Once, while doing a load testing with my client, I was shown below error while taking log backups on secondary replica. Msg 35295, Level 16, State 1, Line 1 Log backup for database “MyAppDB” on a sec...
On International Womens’ Day, I think about my journey how I got here today. Other women may have similar experiences. Unlike Jenni Murray, I believe that you can be trans, proud and a real woman. Jus...
It is perfectly valid for a DBA (or their manager) to assign KPIs to the servers and databases they administer. KPIs are unique for every shop, and for every role. The post appeared first on https://...
Now in this post after creating Dbaas and connect the database using SQL developer, Oracle Provide you with Enterprise manager to manage your DB and giving you General Information about the database s...
Often people confused with Big Data, Data Science and Data Analytics. Are they same or different.This link will give you an idea about what are they, what skills you need and what are the salary level...
There are many wait types in SQL Server and not all of them are documented. Long ago I wrote blog on PREEMPTIVE and Non-PREEMPTIVE waits. SQL SERVER – PREEMPTIVE and Non-PREEMPTIVE – Wait Type – Day 1...
Concerned about risks and want to lock down your Oracle client for end user Windows PCs? Have a need for the ‘cross connection query’ feature of Toad Data Point? The solution is within your grasp! Let...
Among Oracle database professionals, MySQL is being considered more and more. And now, there is data that shows that MySQL is about to overtake Oracle to take the spot as the number-one database. Bec...
In the previous part of this article series, we looked at the history of Amazon AWS, and how Amazon first released its Relational Database Service (Amazon RDS) supporting disparate and popular relatio...
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 VIII...
