Application integration & Middleware, Development & Performance PKI – SSL certificates management with Java keytool and OpenSSL 27.05.2016 by Middleware Team 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(…)
Development & Performance Stored procedure execution may fail with nonclustered columnstore indexes 12.05.2016 by Microsoft Team 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(…)
Development & Performance, Technology Survey SQL Server 2016: Microsoft R Server 04.05.2016 by Stéphane Haby 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.
Development & Performance APEX Connect 2016 – Day 2 – APEX 27.04.2016 by Alain Lacour 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(…)
Development & Performance, Technology Survey SQL Server 2016: R Services 19.04.2016 by Stéphane Haby 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(…)
Application integration & Middleware, Development & Performance Java: Cannot delete file? 14.04.2016 by Middleware Team 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(…)
Development & Performance SQL Server 2016 : nonclustered columnstore index and aggregate pushdown 14.03.2016 by Microsoft Team 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(…)
Database Administration & Monitoring, Development & Performance Sudden drop of the page life expectandy but don’t panic yet! 02.03.2016 by Microsoft Team A couple of weeks ago, I had an interesting discussion with one of my customer about the page life expectancy (aka PLE). He asked me if monitoring the metric value is a best practice because he often noticed a big(…)
Development & Performance Changing an existing partition configuration … Well, not so easy! 26.02.2016 by Microsoft Team This time let’s talk about an interesting customer scenario where table partitioning was implemented on a table with 100 GB of data on SQL Server 2014. Partitioning in this context aimed to save disk space (archive data were compressed) , help(…)
Development & Performance NOLOCK is definitely not what you may expect … 15.02.2016 by Microsoft Team For those who still believe that using nolock hint is a lock-free process, keep reading this blog post. I wrote a previous blog post 3 years ago, when I was at one of my customer and(…)