Oracle Cloud Services
Oracle Cloud Services
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 ...
How to Get Status of Running Backup and Restore in SQL Server? – Interview Question of the Week #113
How to Get Status of Running Backup and Restore in SQL Server? – Interview Question of the Week #113
Question: How to Get Status of Running Backup and Restore in SQL Server? Answer: One of the reasons I started my blog long ago was to have a repository of scripts which can be very useful by DBA duri...
SQL SERVER – PRINTing Status Using RAISERROR With NOWAIT Option
SQL SERVER – PRINTing Status Using RAISERROR With NOWAIT Option
In this blog post we are going to learn about PRINTing Status Using RAISERROR With NOWAIT Option. The Problem There are many situations where you want to know which line of code is completed in th...
Toad for SQL Server – Configuration and Layout
Toad for SQL Server – Configuration and Layout
Watch as Toad Expert, Robert Pound, demonstrates the configuration and custom layout capabilities in Toad for SQL Server....
SQL DB now supports 4TB max database size
SQL DB now supports 4TB max database size
Azure SQL Database (SQL DB) has increased its max database size from 1TB to 4TB at no additional cost. Customers using P11 and P15 premium performance levels can use up to 4 TB of included storage at...
My take on presenting
My take on presenting
This idea basically started from Andy Bek’s TSQL Tuesday last year #84 growing new speakers (https://sqlbek.wordpress.com/2016/10/25/t-sql-tuesday-84-growing-new-speakers/ – thanks Andy) and I have de...
SQL SERVER – Script Upgrade – Server Principal ‘MS_PolicyEventProcessingLogin’ Has Granted One or More Permission(s)
SQL SERVER – Script Upgrade – Server Principal ‘MS_PolicyEventProcessingLogin’ Has Granted One or More Permission(s)
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...
Latest UI for Oracle Dev Gym
Latest UI for Oracle Dev Gym
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 ...
SQL SERVER – FIX : Msg 35295, Level 16 – Log Backup For Database ‘DBName’ on a Secondary Replica Failed
SQL SERVER – FIX : Msg 35295, Level 16 – Log Backup For Database ‘DBName’ on a Secondary Replica Failed
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...
Keeping the golf score card after 20 years in IT; reflections on International Womens’ Day
Keeping the golf score card after 20 years in IT; reflections on International Womens’ Day
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...
KPIs For DBAs to Show Their CIOs
KPIs For DBAs to Show Their CIOs
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://...
Monitor Oracle Dbaas using Oracle Cloud EM
Monitor Oracle Dbaas using Oracle Cloud EM
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...