Database Administration & Monitoring, Database management Monitoring tools for PostgreSQL – POWA 09.12.2015 by Daniel Westermann The last posts introduced the logging system, pg_stat_statements, pg_activity and pgcluu. This post will look at POWA: PostgreSQL Workload Analyzer. For getting the most out of POWA the following extension(…)
Database management, Technology Survey SQL Server 2016 CTP3.0: Stretch Database enhancements 26.11.2015 by Stéphane Savorgnano Some months ago, my colleague Nathan explained you the bases of the new Stretch Database functionality via two blogs here and here. With the new SQL Server 2016 CTP 3.0, Stretch Database now includes new features and(…)
Database management Querying the Oracle Management Repository 25.11.2015 by Oracle Team The Enterprise Manager Cloud Control 12c is an amazing tool allowing the DBA to display a lot of informations from the console . But there are also a lot of repository views that may be consulted by the DBA to(…)
Business Intelligence, Database management, Oracle DBA, turkeys and NoSQL hype 24.10.2015 by Oracle Team By Franck Pachot . We (DBAs) look at this NoSQL hype with a large smile. We know how powerful are SQL databases and we can't imagine processing data seriously without it. And the technologies that come with NoSQL brings back(…)
Database Administration & Monitoring, Database management How to be sure that tempdb size is good to run a DBCC CHECKDB? 14.10.2015 by Stéphane Haby In many blogs or forums, you can read that the answer is to use the option: WITH ESTIMATEONLY. With this option, you can easily have the space estimation needed to check the database in tempdb. But be careful, only since(…)
Database Administration & Monitoring, Database management, Technology Survey SSISDB is too big and it is not every time the retention period’s fault! 09.10.2015 by Stéphane Haby In all blogs that I read, the solution is just to change the retention period to a reasonable value. Yes, it is true but in some case you need to go deeper in the analysis… Like you, I(…)
Business Intelligence, Database management, Oracle Oracle and Analytic Queries before In-Memory option 04.10.2015 by Oracle Team By Franck Pachot . Next Tuesday in Geneva I'm presenting Oracle In-Memory Column Store to Business Intelligence people at the Swiss BI Day After defining what is an analytic query, I show the different approaches to optimize that in(…)
Database Administration & Monitoring, Database management Oracle 12c duplicate in cluster fails with ORA-65500 03.09.2015 by David Hueber I had to perform a duplicate database between 2 ODAs and was always facing an ORA-65500 at the begin of the RMAN operation. Looking a bit deeper in the log outputs pointed me out that it was due to some(…)
Database management, Oracle Oracle CDC for Datawarehouse, Dbvisit replicate as an alternative 26.08.2015 by Oracle Team By Franck Pachot . You don't want to reload the datawarehouse database every night. And you may want to have it refreshed more often, in real-time during the day. There is another reason to capture all changes from the(…)
Database management, Oracle Oracle Database Cloud Service – DBaaS 25.08.2015 by Oracle Team By Franck Pachot . My first trial was not very good because I had access to Schema as a Service only. Which is not new. But Oracle Cloud Services is becoming(…)