Database management What that in-memory term is about, and what not 21.05.2015 by Daniel Westermann Everybody is talking about in-memory databases these days. And everybody is talking about columnar store for sets of data because this can be a benefit for analytic queries. And a lot of people start mixing these terms not realizing that(…)
Database management, Oracle List all RMAN backups that are needed to recover 20.05.2015 by Oracle Team By Franck Pachot . This blog post is something I had in draft and Laurent Schneider blog post reminds me to publish it. With the right RMAN configuration you should not have to managed backup files yourself. The(…)
Database management Optimized Row Columnar (ORC) format in PostgreSQL 18.05.2015 by Daniel Westermann Nowadays everybody is talking about columnar storage format. What can PostgreSQL do in this area? There is no native support for that in PostgreSQL but thanks to the fact that PostgreSQL is highly extensible there is a(…)
Database management tmux – an alternative to screen 18.05.2015 by Daniel Westermann You may already use screen for multiplexing a terminal. This is especially useful when you want to start long running processes on a server and do not want to loose the connection because of a ssh connection timeout,(…)
Database management does impdb into a compressed table really compress data? 18.05.2015 by Daniel Westermann Today at a customer we discussed the following scenario: To refresh a test database a datapump export and import was implemented. To save space on the test system the idea came up to compress the data on the test system.
Database management Using VSS snapshots with SQL Server – part I 18.05.2015 by Microsoft Team This is probably a series of blog posts about some thoughts concerning VSS snapshots with database servers. Let’s begin with this first story: Some time ago, I implemented a backup strategy at one of my customers based on FULL(…)
Database management Get the main information from SQL Server databases with PowerShell 18.05.2015 by Nathan Courtine As I promised in my previous blog Get the main Administration Information from SQL Server with PowerShell, I will present you this time how to retrieve the SQL Server databases information with PowerShell. Disclaimer: I am not a(…)
Database management Get SQL Server Network Configuration with PowerShell 18.05.2015 by Nathan Courtine This blog is part of a set which try to automate the SQL Server administration with PowerShell. It explains how to retrieve the network configuration of a SQL Server instance with PowerShell. I will refer to my previous blog Get(…)
Database management What will be coming with the next major version of postgresql ? 18.05.2015 by Daniel Westermann A PostgreSQL major version is usually released once a year. For the next major version, which is 9.5, this probably will be in the second half of 2015. As PostgreSQL is an open source product everything that(…)
Database management, Oracle Variations on 1M insert (6): CPU Flame Graph 18.05.2015 by Oracle Team By Franck Pachot . If you followed the 1M rows insert variations, you have seen how something simple brought me into an investigation with the latest tools available to see where the time is spent. When the time is(…)