All articles

getting started with postgres plus advanced server (2) – setting up a backup and recovery server

The first post in this series explained how to get ppas installed on a linux system. Now that the database cluster is up and running we should take care immediately about backup and recovery. For this I’ll(…)

SQL Server Tips: How to know if In-Memory Feature is supported by your server?

A customer asks me, how to know if In-Memory Feature is supported by my SQL Server server? An easy way is to check the edition, version etc. but now, you have directly a property for that. On msdn(…)

getting started with postgres plus advanced server (1) – setting up ppas

I did several posts around postgresql and postgres plus advanced server in the past. What is missing is a beginners guide on how to get postgres plus advanced server up and running including a solution for backup and(…)

Azure DocumentD8: Microsoft goes to NoSQL

Azure DocumentDB is a documentary database service and as like its name suggests, it is aMicrosoft Azure Cloud service. Since the last summer, developers have access to this new service, and now it is available(…)

Successful launch dbi services Zürich

Yesterday evening dbi services (headquarters in Delémont) launched officially its third branch in Zürich (Beside Basel and Lausanne). Five years after its take off, the “Oracle Database Partner of Year 2014”, is employing more than 40 consultants. I would like(…)

D2 xPlore search on apostrophes

When using the D2 searches you are likely to go into trouble regarding special characters such as apostrophes. The goal in this blog is to show you how to parameterize new special character searches. In many documents you’ll have text(…)

SQL Server vNext becomes SQL Server 2016

  Satya Nadella, CEO of Microsoft has announced at the Microsoft Ignite keynote in Chicago that SQL Server 2016 public preview will come this summer and you can be sure that at dbi services we’re looking(…)

Weblogic Threadpool has stuck threads

In Weblogic it is common to have this warning: ThreadPool has stuck threads. Here we will see a way to determine which can be the cause. When monitoring Weblogic you can notice that time to time your servers are going(…)

SQL Server – Change Management: list all updates

I am looking to have all SQL Server updates on a server including Service Packs, Cumulative Updates and other fixes like we can see in the uninstall panel from Windows. I take the opportunity of this(…)

Variations on 1M rows insert (3): TimesTen

By Franck Pachot . In the previous blog post I measured how inserting 1 million rows takes 5 minutes instead of 45 seconds when we commit at each row inserted. In Oracle we can improve that down to(…)