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...
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...
Watch as Toad Expert, Robert Pound, demonstrates the configuration and custom layout capabilities in Toad for SQL Server....
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...
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...
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...
