All articles

Can you have pending system statistics?

By Franck Pachot . Your system statistics seems to be wrong and you want to gather or set more relevant ones. But you don’t want to see all your application execution plans changing between nested loops and hash joins.

Flame Graph for quick identification of Oracle bug

By Franck Pachot . Most of my performance stores start with a screenshot of Orachrome Lighty my preferred tool to have a graphical view of the database performance, in Standard and Enterprise Edition without any options:(…)

Ways to improve your SharePoint Intranet

World today is changing in companies using different path to get better communication with their staff, to boost productivity, improve the effectiveness of the strategy and business direction. SharePoint has become a reference’s tool regarding this(…)

SQL Server 2016: Live query statistics

During my tests of the SQL Server 20126 CTP2, I noticed an additional icon on SQL Server Management studio which is close to the Actual Execution Plan button as shown below: I decided to take a look at the(…)

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