Database management MySQL high availability management with ClusterControl 13.09.2014 by Grégory Steulet Installing and managing a highly available MySQL infrastructure can be really tedious. Solutions to facilitate database and system administrator’s task exist, but few of these cover the complete database lifecycle and address all the database infrastructure management requirements. Severalnines’ product(…)
Database management Oracle OEM Cloud Control 12.1.0.4 – AWR Warehouse 12.09.2014 by Oracle Team This post explains how to configure and use the new AWR warehouse functionality present in Enterprise Manager Cloud Control 12.1.0.4. This new feature offers the possibility to store date from the AWR of your main databases in the EM AWR(…)
Database management, Oracle Oracle: How to move OMF datafiles in 11g and 12c 10.09.2014 by Oracle Team By Franck Pachot . With OMF datafiles, you don’t manage the datafile names. But how do you set the destination when you want to move them to another mount point? Let’s see how easy (and online) it works in(…)
Database management, Oracle Resize your Oracle datafiles down to the minimum without ORA-03297 08.09.2014 by Oracle Team By Franck Pachot . Your datafiles have grown in the past but now you want to reclaim as much space as possible, because you are short on filesystem space, or you want to move some files without moving empty(…)
Database management, Oracle What’s the consequence of NOLOGGING loads? 04.09.2014 by Oracle Team By Franck Pachot . When you load data in direct-path and have the NOLOGGING attribute set, you minimize redo generation, but you take the risk, in case of media recovery, to loose the data in the blocks that you’ve(…)
Database management How to remap tablespaces using Oracle Import/Export Tool 26.08.2014 by Oracle Team Since Oracle 10g, Oracle provides a great tool to import and export data from databases: Data Pump. This tool offers several helpful options, particularly one that allows to import data in a different tablespace than the source database. This parameter(…)
Database management, Oracle Oracle 12.1.0.2.1 Set to Join Conversion 21.08.2014 by Oracle Team By Franck Pachot . Recently, I described the Partial Join Evaluation transformation that appeared last year in Oracle 12c. I did it as an introduction for another transformation that appeared long time ago in 10.1.0.3 but was not(…)
Database management How to find the SQL Server Management Pack in the SCOM database 20.08.2014 by Stéphane Haby While working on a customer project, I needed to retrieve the SQL Server SCOM Management Pack version. Unfortunately, the SCOM team took a while to answer and as I am the DBA, I have access to the SCOM databases.
Database management Deploying a SQL Server database to Azure 13.08.2014 by Nathan Courtine Deploying an SQL Server database to a Windows Azure virtual machine is a feature introduced with SQL Server 2014. It can be useful for an organization that wants to reduce its infrastucture management, simplify the deployment, or have a(…)
Database management SQL Server 2014: DBCC CHECKDB and ReFS support 07.08.2014 by Microsoft Team Have you noticed an interesting behavior with SQL Server 2014 when you are running a dbcc checkdb command? If not, you should have a look at this blog post. I discovered it completely by accident during some tests. If(…)