Application integration & Middleware A SharePoint – Business Analyst? What for? 12.06.2015 by Microsoft Team Business analysis is becoming a widely accepted and valued position in organizations today, particularly those that are looking for new ways to enhance information systems. Good business analysis allows us to deal effectively with complexity, which in turn enables(…)
Hardware & Storage SQL Server 2016 : availability groups and the new potential support for standard edition 12.06.2015 by Microsoft Team In my first blog about availability groups with SQL Server 2016, I talked quickly about the new interesting option: DB_FAILOVER. In this blog post, I will continue by introducing the new potential support of availability groups in a standard(…)
Business Intelligence QlikView Tips & Tricks: The Link Table 12.06.2015 by Alain Lacour In this blog, I will show you how to bypass a “Synthetic Key” table in QlickView. Why bypassing a “Synthetic Key” table? If you have multiples links between two tables, QlikView generates automatically a “Synthetic Key” table. (here “$Syn 1”(…)
Database management, Oracle An alternative to DBA_EXTENTS optimized for LMT 12.06.2015 by Oracle Team By Franck Pachot . This is a script I have for several years, when tablespaces became locally managed. When we want to know to which segment a block (identified by file id, block id) belongs to, the DBA_EXTENTS view(…)
Hardware & Storage SQL Server 2016: availability groups and the new option DB_FAILOVER 12.06.2015 by Microsoft Team Let’s continue the SQL Server 2016’s discovery with one of my favourite topic: the AlwaysOn availability groups (AAGs). There are some improvements on this area. First of all, let’s introduce one of them (DB_FAILOVER option) by remembering of the availability(…)
Database management, Oracle Oracle memory advisors: how relevant ? 12.06.2015 by Oracle Team By Franck Pachot . Do you look at memory advisors? I usually don’t but I still show them during the performance tuning workshop because there is no easy way to get an idea about memory sizing. This morning, while(…)
Database management, Oracle How to disable a SQL Plan Directive permanently 12.06.2015 by Oracle Team By Franck Pachot . In 12c you will see a lot of SQL Plan Directives. Some are useful to get better execution plans, but some will trigger too much Adaptive Dynamic Sampling and that can become a big overhead,(…)
Development & Performance SAP HANA SQL scripting optimization: the CE Functions 12.06.2015 by Alain Lacour In SAP HANA, you have two possibilities to create the Calculated Views: Using the graphical method Using the scripting method with CE functions In this blog, I will demonstrate that CE Functions can improve performances from a Calculated(…)
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(…)