Infrastructure at your Service

Category Archives: Development & Performance

Stéphane Haby

SQL Server 2017: first steps with Python Service

By | Development & Performance, Technology Survey | No Comments

Last year, I written blogs about SQL Server 2016 and his integration from the R language. Just for information, you can find these blogs about SQL Server 2016 R Services here: SQL Server 2016: R Services SQL Server 2016 – R Services Tips: How to find installed packages using T-SQL? Now, the next version of SQL Server, named officially SQL Server 2017 integrate also the language Python. The first step is to install the Python…

 
Read More
Alain Lacour

APEX Connect 2017 – Day 1

By | Development & Performance | No Comments

This year again the APEX connect conference spans over three days with mixed topics around APEX, like JavaScript, CSS, SQL and much more. After the welcome speech and the Keynote about “Reconciling APEX and the Thick Database Paradigm” by Bryn Llewellyn I decided to attend presentations on following topics: – Temporal Validity and Flashback Data Archive – Universal Theme and Custom Themes in APEX 5.1 – Using REST Services in APEX applications the nice way…

 
Read More
Joël Cattin

Oracle 12cR2 : Optimizer Statistics Advisor

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

The Optimizer Statistics Advisor is a new Advisor in Oracle 12.2. The goal of this Advisor is to check the way you gather the statistics on your database, and depending on what is found, it will makes some recommendations on how you can improve the statistics gathering strategy in order to provide more efficient statistics to the CBO. This Advisor is also able to generate remediation scripts to apply the statistics gathering “best practices”. The…

 
Read More
Joël Cattin

Oracle 12cR2 : Partitioning improvements – multi-column list partitioning & read-only partitions

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

In my last blog post I presented auto-list partitioning, a new partitioning functionality coming with 12cR2. In this one I will introduce two others : multi-column list partitioning and read-only partitions. Multi-column list partitioning Image : “Oracle Partitioning in Oracle Database 12c Release 2″ – Hermann Bär With the first release of 12c it wasn’t possible to create list partitioned tables based on multi-column partition key : ORA-14304: List partitioning method expects a single partitioning…

 
Read More
Arnaud Berbier

UKOUG 2016 – Third day

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

Today, it’s the third day in Birmingham for the UKOUG Tech16 event. We had a good time yesterday evening in English pubs. Today, I attended several sessions. Sessions that I was mostly interested in was the “Application Express 5.1 New Features part 1 and part 2. The 1st session was presented by David Peake from Oracle. He provided main new features that will come with Apex 5.1. He demonstrates new capability for developer usage improvement in terms…

 
Read More
Arnaud Berbier

UKOUG 2016 – Second day

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

This second day at UKOUG was quite good. I slept well at the Jurys Inn hotel and this morning, I enjoyed one more time a real English breakfast with beans, bacons, eggs and sausages. I like that to be fit over all the day Today, I attended the general Keynote and several sessions around integration, APEX & Database Development and Database. My colleague, Franck Pachot also presented today and I attended his session “12c Multitenant: Not…

 
Read More
Joël Cattin

Oracle 12cR2 : Partitioning improvements – auto-list partitioning

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

The second release of Oracle Database 12c (12cR2) comes with new improvements regarding partitioning. In this blog post I’ll show one of them : auto-list partitioning. Auto-list partitioning is an extension of list partitioning. It enable the automatic creation of partitions for new values inserted into the partitioned table. Image : “Oracle Partitioning in Oracle Database 12c Release 2″ – Hermann Bär Let’s have a look at the syntax. As you can see below, you…

 
Read More
Stéphane Haby

SQL Server 2016 – R Services Tips: How to find installed packages using T-SQL?

By | Development & Performance | No Comments

If you have restricted access to the server and you do not know if your packages are installed on the SQL Server with the R Services, you have the possibility to do it by T-SQL. The R command/function to use is “installed.packages()”. As you can read in the R Documentation for installed.packages(),  this function scans the description of each package. The output is a table with 16 columns with basically these information: Package LibPath Version…

 
Read More
Stéphane Haby

SQL Server 2016: New useful function STRING_SPLIT()

By | Development & Performance | No Comments

Now, in the latest version of SQL Server, you have one of the most expected function as well as for developers as for administrators, splitting a string natively in T-SQL: STRING_SPLIT(<character expression>,<separator>) This function has 2 parameters: The character expression with a data type of nvarchar,varchar,nchar or char The separator with a data type of nvarchar(1), varchar(1), nchar(1) or char(1) The function return a table of one column with all splitting string A first test…

 
Read More
David Barbarin

SQL Server 2016: TRUNCATE PARTITIONS with sliding Windows scenarios

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

Some time ago, I had to deal with a new partitioning scenario that included sliding windows stuff for mainly archiving purpose. Regarding the customer context, I used some management scripts that include this time dropping oldest partition. We didn’t care about data oldest than 2 years. Usually in this case, I use a method that consists in dropping data by switching first the oldest partition to a staging table and then truncate it. Finally we may…

 
Read More