Infrastructure at your Service

 
Franck Pachot

ALTER TABLE INMEMORY

By | Database management, Oracle | No Comments

By Franck Pachot . In-Memory Column Store is amazing. It brings very good performance to full table scans. I’t easy: just ‘flip a switch’ and you accelerate all reporting queries on your table, without thinking about what to index and how. But in this post, I would like to warn you about the consequences when you just flip that switch. The new full table scan plan will replace the old ones… even before the table…

Read More
Yann Neuhaus

Successful launch dbi services ZĂĽrich

By | Database management | No Comments

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 to use this opportunity to thank all the customers and partners who trust dbi services. A particular thanks goes to the customers and partners who helped us to enjoy a very pleasant inauguration party yesterday….

Read More
Middleware Team

D2 xPlore search on apostrophes

By | Application integration & Middleware | No Comments

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 with apostrophes or special characters that you want to search on. But unfortunately by default the D2 search will return nothing when you enter apostrophes directly into the search bar. The xPlore will replace special…

Read More
Middleware Team

Weblogic Threadpool has stuck threads

By | Application integration & Middleware | 11 Comments

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 in Warning mode. And when clicking on warnings you see this screen: The reason is presented as “ThreadPool has stuck threads”. So it doesn’t help a lot. But we can have a deeper view and…

Read More
Stéphane Haby

SQL Server – Change Management: list all updates

By | Database management | 5 Comments

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 blog to remind you in a little introduction the different types of patches for SQL Server: Service Pack Service Pack, known as SP is big set of Hotfixes. The particularity is that the regression is fully tested and sometimes…

Read More
Franck Pachot

C15LV: Nothing to BLOG About – Think Again

By | Database management, Oracle | No Comments

By Franck Pachot . Before going to the airport to come back in Europe, the las session I assisted at IOUG Collaborate is a panel: Nothing to BLOG About – Think Again Some famous bloggers were there to help, motivate and inspire people that are afraid to blog. The idea is good. The session was good. The panelists have shared ideas, tips, experience. It was very good. I’m already a blogger, but that inspired me anyway….

Read More
Franck Pachot

SQL Monitor report little improvement in 12c

By | Database management, Oracle | 2 Comments

By Franck Pachot . This is a very short post about something I though I had already blogged about. I like SQL Monitoring active reports. The are graphical, and still very light. There is only one thing I don’t like about it in 11g and it has been improved in 12c Look at the following. The query has run for 1.1 minute. And from the ‘Database Time’ line we can see that it used mostly…

Read More
Nathan Courtine

Get the main information from Windows Server with PowerShell

By | Database Administration & Monitoring | No Comments

This blog will present you a way to retrieve Windows Server main information via PowerShell. The goal is to be able to automate the extraction of information for different purposes: audit, report generation, dashboards…   Disclaimer: I am not a developer but a SQL Server dba. If you find errors or some ways of improvement, I will be glad to read your comments!     Computer System information First, I initialize the WMI object containing…

Read More
Daniel Westermann

bulk loading semi structured data in postgresql

By | Development & Performance | 3 Comments

The last post took a look at how to efficiently load 1m rows into a table in PostgreSQL. In this post I’ll take a look on how to do the same with semi structured data. Again it is the same system as in the last post using the same PostgreSQL parameters. Using the hstore datatype For storing key/value pairs there is the hstore extension in PostgreSQL. Using the same sample data as in the last…

Read More
Daniel Westermann

Variations on 1M rows insert(2): commit write – PostgreSQL

By | Development & Performance | No Comments

Franck was quite fast with his second post Variations on 1M rows insert(2): commit write. Lets see what we can do on the PostgreSQL side. I’ll take the same test table as Franck again: create table DEMO (“id” number , “text” varchar2(15), “number” number) ; The pgplsql block which corresponds to Frank’s plsql block looks like this: \timing on truncate table DEMO; DO $$DECLARE l_people_array varchar(15)[12] := ‘{“Marc”, “Bill”, “George”, “Eliot”, “Matt”, “Trey”, “Tracy”,”Greg”, “Steve”,…

Read More
Daniel Westermann

Variations on 1M rows insert (1): bulk insert – PostgreSQL

By | Development & Performance | One Comment

When I read Franck’s post about Variations on 1M rows insert (1): bulk insert I thought doing quite the same in PostgreSQL might be interesting. Lets start by using the same test tables, one using a primary key and the other one without a primary key:create table DEMO (“id” int , “text” varchar(15), “number” int); create table DEMO_PK (“id” int , “text” varchar(15), “number” int, constraint demo_pk_pk primary key (id) ) ; postgres=# \d demo*…

Read More
Matthieu Munch

QlikView – Load data in QlikView / QlikSence – Best practice and trick

By | Entreprise content management | No Comments

In this blog, I will give you some best practices and tricks when you are loading table to generate your data. But before, I will review the different ways to load data in a QlikView or QlikSense report. 1.How to retrieve data in QlikView You have 2 different possibilities to load your data in your report: Database connector File connector a) Database connector: If your data are located in a database, you must use this…

Read More