Application integration & Middleware

SQL Server 2014 : New incremental statistics

Do you use partitioning with SQL Server? If yes this post is for you because there are good news about partitioning with SQL Server 2014. I remember an old job with a healthcare customer who we decided to implement(…)

ESPC 2014: Upgrading To SharePoint 2013

I have decided to make a resume of the presentation “Upgrading SharePoint 2013” by Sam Hassani that I have followed at the European SharePoint Conference 2014. This is meant for the people who did not have the chance(…)

SQL Server 2014: SELECT INTO operators can run in parallel

A couple of weeks ago, I had to provide some best practices in term of architecture for a “heavy writes” environment that consists in importing data from different sources into SQL Server tables. At the customer place, I was(…)

How to install and manage a Kerberos Server

For some time now, I have been working on how to set up a Single Sign-On (SSO) solution in my company. As a big fan of Open Source solutions, I have obviously proposed the implementation of a solution based(…)

Kerberos SSO with Documentum D2 3.1 SP1

Last week, when I was working on how to setup the Kerberos SSO for D2 3.1 SP1, I faced some issues due to a documentation that doesn’t seem to be up to date… In fact, our version is D2 3.1(…)

Oracle APEX: redirect all pages to one

This blog will explain how to proceed in order to redirect all the application pages to one single page, prior to their processing and rendering, with Oracle APEX 4.0 and above. In some cases, like security checks, you may(…)

SQL Server 2014: Hekaton memory optimized tables, hash indexes, and bucket counts

For my first blog post at dbi services, I think it could be a good opportunity to begin by discussing around SQL Server 2014, Hekaton memory optimized tables, and hash indexes. When you create a memory optimized table you(…)

Delayed Transaction Durability: A new feature in SQL Server 2014 CTP2

Delayed Transaction Durability is a new SQL Server 2014 feature that was not included in SQl Server 2014 CTP1 but discreetly published in CTP2. It is a very interesting functionality that helps reducing the IO contention for transaction log(…)

Oracle LOBs: Infer the file type with dbms_lob package

LOBs (Large OBjects) first appeared in Oracle 7 and were created to store large amount of data such as document files, video, pictures, etc. Today, we can store up to 128 TB of data in a LOB, depending on the(…)

Sockets, Cores, Virtual CPU, Logical CPU, Hyper-Threading: What is a CPU nowadays?

By Franck Pachot . Because people know that I really like Oracle AWR reports, they send them to me from time to time. Here is one I have received for Christmas with the following question: ‘Since our AIX server(…)