Database management getting started with postgres plus advanced server (2) – setting up a backup and recovery server 18.05.2015 by Daniel Westermann The first post in this series explained how to get ppas installed on a linux system. Now that the database cluster is up and running we should take care immediately about backup and recovery. For this I’ll(…)
Database management SQL Server Tips: How to know if In-Memory Feature is supported by your server? 18.05.2015 by Stéphane Haby A customer asks me, how to know if In-Memory Feature is supported by my SQL Server server? An easy way is to check the edition, version etc. but now, you have directly a property for that. On msdn(…)
Database management getting started with postgres plus advanced server (1) – setting up ppas 18.05.2015 by Daniel Westermann I did several posts around postgresql and postgres plus advanced server in the past. What is missing is a beginners guide on how to get postgres plus advanced server up and running including a solution for backup and(…)
Database management Successful launch dbi services Zürich 18.05.2015 by Yann Neuhaus Yesterday evening dbi services (headquarters in Delémont) launched officially its third branch in Zürich (Beside Basel and Lausanne). Five years after its take off, the “Oracle Database Partner of Year 2014”, is employing more than 40 consultants. I would like(…)
Database management SQL Server – Change Management: list all updates 18.05.2015 by Stéphane Haby I am looking to have all SQL Server updates on a server including Service Packs, Cumulative Updates and other fixes like we can see in the uninstall panel from Windows. I take the opportunity of this(…)
Database management, Oracle Variations on 1M rows insert (3): TimesTen 18.05.2015 by Oracle Team By Franck Pachot . In the previous blog post I measured how inserting 1 million rows takes 5 minutes instead of 45 seconds when we commit at each row inserted. In Oracle we can improve that down to(…)
Database management, Oracle Variations on 1M rows insert(2): commit write 18.05.2015 by Oracle Team By Franck Pachot . In the previous blog post I measured the time it takes to insert 1 million rows. About 45 seconds when done row-by-row which goes down to 7 seconds when inserted in bulk. In both(…)
Database management, Oracle Variations on 1M rows insert (1): bulk insert 18.05.2015 by Oracle Team By Franck Pachot . This blog is the first one of a series about inserting 1 million rows. Do you have an idea about the time it takes? The idea came from another project, about NoSQL databases, but I’ll(…)
Database management, Oracle A migration pitfall with ALL COLUMN SIZE AUTO 18.05.2015 by Oracle Team By Franck Pachot . When you migrate, you should be prepared to face some execution plan changing. That’s not new. But here I’ll show you a case where you have several bad execution plans because lot of histograms are(…)
Database management, Oracle List listeners and services from the instance 18.05.2015 by Oracle Team By Franck Pachot . Want to know all your listeners – including scan listeners, and the services it listens for? It is possible from the instance, with the – undocumented – view V$LISTENER_NETWORK which is there since 11.2 Let’s(…)