If you use the DATEdata type in your SQL code, it is likely that you have come across the “not a valid month” Oracle database error. As we shall discuss, the error can be fixed with a slight tweak of ...
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...
Because tablespaces are not unchanging objects, monitoring tablespaces is an important aspect of the DBA's monitoring responsibilities. Tablespaces are automatically defragmented by the SMON process....
