Development & Performance SQL Server 2016 CTP2 : first thoughts about tempdb database 12.06.2015 by Microsoft Team In my first blog about SQL Server 2016, I noticed during the SQL Server installation process that we are able to configure the number of files for tempdb. This is surely a great improvement(…)
Database management, Oracle Convert a snapshot standby to a new database 12.06.2015 by Oracle Team By Franck Pachot . A snapshot standby database is a nice solution when you want a temporary copy of the primary where you can do whatever you want (test a bug fix for example) and then convert it back(…)
Technology Survey SQL Server 2016 CTP2 is out! 12.06.2015 by Microsoft Team As announced by Satya Nadella at the Microsoft Ignite keynote in Chicago, SQL Server 2016 CTP2 is finally out and it follows a previous private CTP. This CTP will provide some(…)
Database management, Oracle 12c Dynamic Sampling and Standard Edition 12.06.2015 by Oracle Team By Franck Pachot . 12c is coming with more dynamic sampling, now called dynamic statistics and using the new Adaptive Dynamic Sampling algorithm. The goal is to have better estimations and better estimations gives better execution plans. However, this(…)
Database management, Oracle How to import SQL Plan Directives 12.06.2015 by Oracle Team By Franck Pachot . Today I’ve presented SQL Plan Directives at the SOUG Romandie event. I had a question about the import/export of directives by Data Pump. The idea is that a lot of testing has been done on(…)
Database management, Oracle DBA_SQL_PLAN_DIRECTIVE.LAST_USED 12.06.2015 by Oracle Team By Franck Pachot . If you have read Matching SQL Plan Directives and queries using it then you know how to use the ‘+metrics’ format of dbms_xplan. 21:49:54 SQL> explain plan for select distinct * from DEMO_TABLE where a=0(…)
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(…)
Application integration & Middleware Alfresco: video thumbnails and transformations 21.05.2015 by Morgan Patou Alfresco support, by default, the preview in your browser of some video formats like mp4 but doesn’t support some others like mkv, avi or wmv. Even if Google Chrome can read mkv files for example, if you try to use(…)
Development & Performance Row Store vs Column Store in SAP HANA 21.05.2015 by Alain Lacour The SAP HANA database allows you to create your tables in Row or Column Store mode. In this blog, I will demonstrate that each method has its advantages and disadvantages and should be used for specific cases. Thanks to two(…)
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(…)