All articles

Testing postgresql development snapshots

If you want to test some of the features that will be coming with the next postgresql release even before an official beta version is released you can use the daily(…)

Because SharePoint 2013 has also limitations!

WHAT IS?  Boundaries: are Static limits that cannot be exceeded by design. An example of a boundary is the 2 GB document size limit.  Thresholds: are configurable limits that can be exceeded to accommodate specific  requirements. A good(…)

A SharePoint – Business Analyst? What for?

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(…)

SQL Server 2016 : availability groups and the new potential support for standard edition

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(…)

QlikView Tips & Tricks: The Link Table

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”(…)

An alternative to DBA_EXTENTS optimized for LMT

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(…)

SQL Server 2016: availability groups and the new option DB_FAILOVER

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(…)

Oracle memory advisors: how relevant ?

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(…)

How to disable a SQL Plan Directive permanently

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,(…)

SAP HANA SQL scripting optimization: the CE Functions

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(…)