2010 February | dbsnaps

SQL Server – Values of Newly Added Columns

What happens if we add a column to a table? What value does this column get?

February 7, 2010 | Posted in SQL Server, Tips & Tricks | Read More »

SQL Server 2005 Log Shipping tutorial

Log shipping is the process of automating transaction log copy and apply in order to maintain identical database copy for high-availability or disaster recovery proposes.

February 6, 2010 | Posted in High Availability, SQL Server, SQL Server - Latest Articles, Videos | Read More »

SQL Server Login Audit tutorial

Learn how to audit sql server’s login, its simple and its quick.

February 6, 2010 | Posted in SQL Server, SQL Server - Latest Articles, Security, Videos | Read More »

SQL Server 2005 Backup & Restore tutorial

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.

February 6, 2010 | Posted in Administration, SQL Server, Videos | Read More »

SQL Server 2005 Mirroring tutorial

SQL Server 2005 provides a set of high availability methods that the users can use to achieve fault tolerance and to prevent server outages and data loss. The selection of the high availability method depends on various factors. Some DBAs need the servers to be available 24/7, while others can afford an outage of a couple of hours. Cost also plays a role in the selection. For example, Clustering is an expensive high availability method when compared to Database Mirroring, but it allows the user to failover immediately.

February 6, 2010 | Posted in High Availability, SQL Server, SQL Server - Latest Articles, Videos | Read More »

Oracle Database Hidden Parameters

Always wanted to see all Oracle parameters? Including the hidden ones?

February 2, 2010 | Posted in Oracle, Tips & Tricks | Read More »

Oracle – Monitoring Long Operations

There are several specific operations that are considered as long operations.
When performing one of these operations, we can follow the progress of the operation

February 2, 2010 | Posted in Oracle, Oracle - Latest Articles, Tips & Tricks | Read More »

Oracle RMAN backup script

Need an RMAN backup script?

February 2, 2010 | Posted in Oracle, Tips & Tricks | Read More »

Oracle Single Sign-On (ESSO) Toturial

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.

February 2, 2010 | Posted in Oracle, Security, Videos | Read More »

Oracle Database Vault – Advanced Factoring tutorial

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

February 2, 2010 | Posted in Oracle, Oracle - Latest Articles, Security, Videos | Read More »