Infrastructure at your Service

Category Archives: Development & Performance

David Barbarin

Les 24 heures du PASS (24HOP) – édition francophone

By | Business Intelligence, Database management, Development & Performance, Technology Survey | No Comments

Je n’ai pas encore blogué sur le sujet mais il est temps de le faire. Cette année, aura lieu la première édition francophone des 24h du PASS  les 20 et 21 septembre 2016. L’idée est plutôt simple: proposer une série de 24 webinaires gratuits de 10h jusqu’à 22h (heure française)  pendant 2 jours. C’est l’occasion de recevoir et d’échanger les dernières informations autour de l’administration et du développement des bases de données, des nouvelles tendances côté Business Intelligence…

 
Read More
Middleware Team

Java reflection: Get classes and packages names from a root package within a custom URLClassloader

By | Development & Performance | No Comments

I have got a case for which I needed to use a custom Classloader, in order to find the list of classes and packages available across several software plugins materialized by a set of jar files. These jar files are intended to be located inside a particular place. After googling, some solutions invited us to deploy external libraries. But I was not interested to manage another lib in my soft just for that purpose. So,…

 
Read More
David Barbarin

SQL Server 2016 AlwaysOn: Direct seeding and performance considerations

By | Database Administration & Monitoring, Development & Performance | No Comments

This blog post follows the previous one about new direct seeding feature shipped with SQL Server 2016. As a reminder, I had some doubts about using direct seeding with large databases because log stream is not compressed by default but I forgot the performance improvements described into the Microsoft BOL. I also remembered to talk about it a couple of months ago in this blog post. So let’s try to combine all the things with the…

 
Read More
Stéphane Haby

SQL Server 2016 – Query Store: retrieve query that doesn’t appear!

By | Database Administration & Monitoring, Development & Performance, Technology Survey | No Comments

For our event SQL Server 2016 in September, I am studying the new functionality Query Store. My colleague David Barbarin have written few months ago about Query Store and how it’s working. Simple SELECT Query To begin, I execute a simple SELECT on a table with 3 different methods: SELECT * FROM QS_test; exec sp_executesql N’SELECT * FROM QS_test’ EXEC sp_GetQS_test; The “sp_GetQS_test” is a stored procedure with the select statement. I created a little…

 
Read More
Stéphane Haby

Attunity Replicate: additional column on the target

By | Development & Performance | No Comments

In December 2015, my colleague Vincent did a test with additional column with Oracle GoldenGate 12.2. Hervé & Vincent asked me to do the same test with Attunity Replicate between Oracle and SQL Server. For the story, Hervé does the test with a previous version here. I create a task and select the Scott schema. I run the replication On the target SQL Server database, I create an additional Column: alter table [SCOTT].[EMP] add SOURCE_COL…

 
Read More
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