How to become a Database Administrator?
DBARepublic.com • 10:57 AM
" What is a database administrator(DBA) or how to become one? " are the questions people ask me when they find out I am a DB...Read More
Search results for sql server
What Can Go Wrong With Sequence?
DBARepublic.com • 11:02 AM
Oracle Sequence is a unique number generator that is used in a table to automatically populate Primary Keys value like ID or sequence n...Read More
Database Backups
DBARepublic.com • 2:51 PM
Do you make a backup of backup or just the backup? Raise your hand if you don't make a backup of your laptop regularly! I make a backup...Read More
Is Your Transaction Log Full?
DBARepublic.com • 9:34 AM
This Afternoon, I was contacted by a developer with an error message “ The transaction log for database ‘database name’ is full. To find out...Read More
Indexed View or Materialized View
DBARepublic.com • 3:19 PM
Indexed View or Materialized View Indexed View also known as Materialized view because they have a virtual table to store data whereas ...Read More
How to Recover A Dropped Table?
DBARepublic.com • 3:51 PM
In my previous blog, I showed you how to find a user who dropped a table and I recommend reading my previous blog before this. With this bl...Read More
Variable Assignment and Initialization
DBARepublic.com • 8:54 PM
PL/SQL is a procedural extension to SQL designed to work with ORACLE database. This is similar to that of SQL Server T-SQL. Learning PL/SQL ...Read More
Subscribe to:
Posts
(
Atom
)
