Monday , January 23 2017

Recent Posts

Data Guard Protection Modes

Data Guard Protection Modes Maximum Availability This mode provides the highest level of data protection that is possible without compromising the availability of a primary database.The transactions do not commit until all redo data needed to recover those transactions has been written to the online redo log file and to …

Read More »

Oracle Logical Standby Databases

Logical Standby Databases A logical standby database is initially created as an identical copy of the primary database, but it later can be altered to have a different structure. The logical standby database is updated by executing SQL statements. This allows users to access the standby database for queries and …

Read More »

Standby Database Types

Standby Database Types A standby database is a transactionally consistent copy of an Oracle production database that is initially created from a backup copy of the primary database. Once the standby database is created and configured, Data Guard automatically maintains the standby database by transmitting primary database redo data to …

Read More »

Introduction to Oracle DataGuard

dataguard

Introduction to Oracle DataGuard Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Data Guard …

Read More »

Creating and Managing RMAN Virtual Private Catalogs

rman virtual private catalogs

RMAN Virtual Private Catalogs About Virtual Private Catalogs By default, all of the users of an RMAN recovery catalog have full privileges to insert, update, and delete any metadata in the catalog. For example, if the administrators of two unrelated databases share the same recovery catalog, each administrator could, whether …

Read More »

Overview of RMAN Backup Optimization

RMAN Backup Optimization If you enable backup optimization, then the BACKUP command skips backing up files when the identical file has already been backed up to the specified device type. If RMAN determines that a file is identical and it has already been backed up, then it is a candidate …

Read More »

Configuring the RMAN Backup Retention Policy

Rman Backup Retention Policy

RMAN Backup Retention Policy The backup retention policy specifies which backups must be retained to meet your data recovery requirements. This policy can be based on a recovery window or redundancy. Use the CONFIGURE RETENTION POLICY command to specify the retention policy. Configuring a Redundancy-Based Retention Policy The REDUNDANCY parameter of …

Read More »

SQL DBA

SQL Server Error Logs Detailed Information

SQL Server Error Logs

SQL Server Error Logs * Error Logs maintains events raised by SQL Server server or SQL Server Agent. * Error Logs is main source for troubleshooting and identifing SQL Server problems. * SQL Server supports 2 types of type error logs * SQL Server Logs * SQL Agent Logs Questions …

Read More »

SQLDBA Interview Questions in CGI bangalore

SQLDBA Interview Questions in CGI What is inline memory ? In which version they introduced ? Suppose blocking is happening for a database, how you find and fix the problem ? What is the main features of SQL 2016 features ? What is Deadlock and live lock? How will you go resolve …

Read More »

PIVOT & UN PIVOT Tables in SQL Server

pivot table

PIVOT & UN PIVOT Tables in SQL Server The PIVOT operator, which was introduced in SQL Server 2005. A pivot table is a frequently used method of summarizing and displaying especially report data by means of grouping and aggregating values.Pivot tables are easily created by MSOffice users using in Excel.The Pivot table …

Read More »

About Transaction Log with Example

about Transaction Log File

A database can have one or more log file. In general there will be only one log file as there is no performance improvement by having multiple log file. SQL server uses the transaction log in sequential manner.As the data file divided into pages,log files are divided into virtual log …

Read More »

Setting Database Options

Setting Database Options A number of database-level options that determine the characteristics of the database can be set for each database. Only the SA, database owner, db creator fixed server roles and db_owner fixed database roles can modify these options. These options are unique to each database and do not …

Read More »

SQL Server 2012 Installation Step by Step with Screenshots

SQL Server 2012 Installation Step by Step with Screenshots

SQL Server 2012 Installation. Steps to install SQL Server 2012, with complete screenshots. Click on the Setup, you will get this menu. Choose Installation, you will get Key menu, Enter the Key, then Next. We go Normal/ Standalone Instance then next. Select the features, what needs to be install. Then …

Read More »

Microsoft SQL Server 2012 Database new features

The release of Microsoft SQL Server 2012 has introduced many new features that increase scalability, manageability, availability, programmability, and security across the enterprise. Enhancements Of SQL Server 2012 Online Index Rebuilds SQL Server 2005 introduced the ability to rebuild an index online with a few limitations that have remained consistent …

Read More »

Configuring SQL Server Report Server and Environment

ssrs

Basic Steps for Junior Level DBA’s Configuring SQL Server Report Server and Environment First Step: – Open > Reporting Services Configuration Manager For Customize the Setting, Click connect Button Next > Service Account keep any account depends upon your project And Apply Next> Web Service URL In this we can …

Read More »

SQL Server Editions and Service Pack information

History SQL Server is the product of Microsoft To take advantage of this template’s design, use the Styles gallery on the Home tab. You can format your headings by using heading styles, or highlight important text using other styles, like Emphasis and Intense Quote. These styles come in formatted to …

Read More »