ALL POSTS

How to Configure Transactional Replication-Mirroring Failover

Configure SQL Server Transactional Replication with Mirroring – this was one of the recent interesting and unusual projects that came our way. At first it looked really odd and intriguing at the same time. The question was, can it really be done? Well, as it happens, Microsoft SQL Server has a pretty straight forward method…

How To Improve SQL Statements Performance: Using SQL Plan Baselines

The performance of any Oracle database heavily relies on query execution(s). The reasons for any SQL statement’s execution plan changes could include a variety of actions, like gathering optimizer statistics (table, index, schema etc.)  changing optimizer parameters, schema definitions, adding indexes etc.  As experienced Oracle DBAs, we should be aware of the fact that the…

Do AWR Reports Show the Whole Picture?

AWR report is a great source of aggregated information on top activities happening in our databases. I use data collected in AWR quite often, and obviously the easiest way of getting the data out from the AWR is by running the AWR report. In most cases that’s not an issue, but there are certain scenarios when…

Script to Collect Database Information Quickly

As a DBA there are occasions where we are required to collect details from a database which can be used for further analysis. For example, getting the status of the database (i.e. File Size, Free Space, Status of the database, and who is the current owner of the database). This kind of information is required,…

Log Buffer: Marching from 2013 to 2014

Pythian’s cherished Log Buffer carnival is celebrating the year 2013, while looking passionately towards yet another promising year for 2014. So much digital water has flown under the bridges in 2013, and Log Buffer covered it all from the eyes of bloggers across database technologies like Oracle, SQL Server, MySQL, and big data. Almost 50…

Page 17 of 252« First...10...1516171819...304050...Last »