All articles

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

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