Infrastructure at your Service

Category Archives: Development & Performance

Stéphane Haby

Attunity Replicate: Backup & Restore a task

By | Development & Performance | No Comments

By a customer, we faced the question: how to backup and restore a replication task in Attunity Replicate? We don’t see any button or menu into the administration web console and in the Guide line, we haven’t really a section about Backup and Restore ??? How to back up a task? The backup is, in reality, an export… The first step is to start a command prompt in the menu Attunity Replicate > Utilities >…

 
Read More
Middleware Team

PKI – SSL certificates management with Java keytool and OpenSSL

By | Application integration & Middleware, Development & Performance | No Comments

In this blog, we will cover all steps to enable SSL encryption for a particular server. The procedure described here applies mostly for Java based servers and applications, with usage of a keystore. In the case the organization into which the certificate has to be deployed has its own PKI, usage of OpenSSL is not necessary. In this case Java keytool usage will be enough. In the case you have to sign by yourself, server…

 
Read More
David Barbarin

Stored procedure execution may fail with nonclustered columnstore indexes

By | Development & Performance | No Comments

In this blog post, let’s talk about a weird situation where I faced a nonclustered columnstore issue with SQL Server 2012. Let’s say we are in the same context than this previous blog post here. So as a reminder, we decided to benefit from the columnstore index feature after installing a new SQL Server 2012 based infrastructure at my customer shop. As showed in the previous blog, implementing columnstore indexes may introduce some challenges and…

 
Read More
Stéphane Haby

SQL Server 2016: Microsoft R Server

By | Development & Performance, Technology Survey | No Comments

In my last article, I wrote about the R Services into SQL Server. Now, Microsoft provides an open source R platform to complete this new SQL Server integrated feature in 2016. On the Microsoft Website, you can download directly R Server 2016 for different operating systems: Windows of course SUSE Linux Red Hat Linux Version for Hadoop on Red Hat Version for Teradata DB Here is the link Installation In the SQL Server Installation Center…

 
Read More
Alain Lacour

APEX Connect 2016 – Day 3 – APEX

By | Development & Performance | No Comments

No keynote for the last day, so I decided to attend presentations on following topics: – APEX fine art printing – APEX repository – Images in APEX – Interactive Grid in APEX 5.1 – Enhance quality through CI – Universal Theme 5.1 APEX fine art printing: Markdown is simplified markup language where tags are kept as simple as possible in order to keep the impact on the size minimal. As opposed to HTML which is…

 
Read More
Alain Lacour

APEX Connect 2016 – Day 2 – APEX

By | Development & Performance | No Comments

After the great Keynote about “APEX Vision, Past, Present, Future” by Mike Hichwa, the father of APEX, I decided to attend presentations on following topics: – Dynamic Actions 5.1 – APEX and Oracle JET – Enterprise UX patterns – APEX Scripting – Automation on APEX instance APEX Vision, Past, Present, Future: Mike Hichwa provided a very interesting overview of how WEB DB was born, turned into Project Marvel which gave HTML DB and finally became…

 
Read More
Alain Lacour

APEX Connect 2016 – Day 1 – SQL and PL/SQL

By | Development & Performance | No Comments

This year the APEX connect conference spans over three days with the first day dedicated to SQL and PL/SQL which are the basement of APEX and its close link to the Database. After the Keynote about “Six months of ask Tom” by Chris Saxon who is filling in for Tom Kyte on the famous “Ask Tom” website I decided to attend presentations on following topics: – A Primer on Service Workers – Managing the changes…

 
Read More
Stéphane Haby

SQL Server 2016: R Services

By | Development & Performance, Technology Survey | 3 Comments

I was during a long time captivated by the R programming language. I’m happy to see that SQL Server 2016 provides now a SQL Server R Services. This service enables SQL Server to execute R scripts. The first step is to install the R Services during the installation of SQL Server. As you can see on the picture, you have 2 selections in the feature Selection Menu: R Services (In-Database) is the service that enable…

 
Read More
Stephane Biehler

Java: Cannot delete file?

By | Application integration & Middleware, Development & Performance | One Comment

You may once went into the struggle to delete a file in java? So do I… I went so mad when I figured out that my files were still present even after a file.delete() or file.deleteOnExit(). It always returned False. So what’s the reason for it not to be deleted? In fact it’s logical… When dealing with files you are probably writing into it. So you open a stream to the file like FileWriter or…

 
Read More
David Barbarin

SQL Server 2016 : nonclustered columnstore index and aggregate pushdown

By | Development & Performance | 2 Comments

Did you miss aggregate pushdown capability shipped with columnstore index? Well, I remember the first time I heard about it is was when I read the very interesting blog post of Niko Neugebauer here with a very good covering of the topic (principle, advantages and limitations). So why to write a new blog post here? Well because since the last Niko’s blog article, this feature has been improved and I wanted to test it with…

 
Read More