DBsnaps - Database Tutorials

A new feature in Oracle Database 10g Release 2 lets you encrypt sensitive data with a click of a botton: You can declare a column as encrypted without writing a single line of code. When users insert the data, the database transparently encrypts it and stores it in the column. Similarly, when users select the column, the database automatically decrypts it. Since all this is done transparently without any change to the application code, the feature has an appropriate name: Transparent Data Encryption (TDE).

Learn how to integrate grant and revoke databas roles based on pre-defined security roles, using oracle secure appliation roles and Oracle database vault.

Learn how to fully utilize database vault factors to control access to your database objects.

SQL Server provides the ability to audit SA and SYSADMIN users' login and logout events. Use SQL Server login audit to find out logins failures, login time and highly privileged users actions.

Database replay is a feature that enables us to capture a database load from Oracle 9i, 10g and 11g, and replay the same load on an 11g database. Let's see what it is and how it works

In database replay, after capturing the load, we need to process the capture files and create replay files. These files will be used to replay the load on the target database.

When using database replay, the third and final step is to replay the load captured and processed. Let's see the replay

SQL Server 2005 provides several high availability options, In my opinion SQL Server 2005 Mirroring is the most importent one. In This Article we will show you how to setup SQL Server Mirroring step by step providing all of the importent tips and tricks to successfully implement SQL Server Mirroring.

enjoy the benefits of single sign-on to all of your applications, whether you are connected to the corporate network, traveling away from the office, roaming between computers or working at a shared workstation.

Learn how to protect oracle database using ORACLE's revolutionary feature - Database Vault. In this first chapter we will show you how to install ORACLE Database Vault, and PROTECT schema objects using DV REALMS.

Microsoft SQL Server enables you to back up and restore your databases. The SQL Server backup and restore component provides an important safeguard for protecting critical data stored in SQL Server databases. A well-planned backup and restore strategy helps protect databases against data loss caused by a variety of failures. Test your strategy by restoring a set of backups and then recovering your database to prepare you to respond effectively to a disaster.

This video will show you how to create an Oracle 11g database

A physical standby database could always be opened in "read only" mode. The problem was that it didn't apply any archived logs at that time. It could only apply logs when mounted. Then came Oracle 11g...

Physical standby database is a common solution for disaster recovery. Let's see an easy and quick way to initially create the standby database from the primary one.