Infrastructure at your Service

dbi services BLOG

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

Stéphane Haby

Attunity Replicate: Replicate numeric data types from Oracle to SQL Server is easy

By | Application integration & Middleware | No Comments
 

 After the good article “A short glance at Attunity replicate” from Franck Pachot, I will continue to explain our test on Attunity Replicate with datatype and how this tool do the mapping between Oracle and SQL Server for numeric datatypes. Introduction The first step is to find the mapping between Oracle and SQL Server. I summarize this mapping in this table: As you known (or not), in SQL Server, you have a replication with Oracle…

Read More
Stephane Biehler

xPlore list all ids from xhive

By | Application integration & Middleware | No Comments
 

 I went into a case that I found a kid of ‘Ghost’ index which I may present in another blog. But to summarize I had to get the full list of indexes from the xPlore server. The problem is that there isn’t such a list easily accessible. Hence I wondered, all indexes are stored in a database, what if I could query this database directly? So I chose this way, and finally found out some…

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
Franck Pachot

When a query has read 350TB after 73K nested loops

By | Database Administration & Monitoring | No Comments
 

 According that you have Tuning Pack, SQL Monitor is the right way to see what a query is currently doing. A query was running for days and the first figure I see is that it has read 350TB. This is not the kind of thing you do in only one operation, so I immediately checked the ‘executions’ columns: 73K table scans. So that’s finally only 5GB. The problem is not the full scan, but the…

Read More
David Barbarin

SQL Server: switch partition and metadata inconsistency issue

By | Database Administration & Monitoring | No Comments
 

 In this blog post, I would like to share with you a weird issue I faced when I implemented a sliding Windows partition scenario on SQL Server 2014 SP1 at one of my customer. The idea was to keep SQL Server audit records from several SQL Server instances into a global archiving table during two years in order to meet the customer audit specifications. Data older than year – 2 should be deleted. Based on…

Read More
Morgan Patou

BeeCon – Day 2 – Activiti, SDK/SPK, Migration and Zombies

By | Application integration & Middleware | 2 Comments
 

 I didn’t say that yesterday but the BeeCon is a two days event. Yesterday was the first day and therefore the BeeCon is now officially over… I’m quite sad because these two days were really great and I would have wanted them to continue a little bit more.   I was finally able to meet some people from the Order Of The Bee with whom I had quite interesting discussions over the past few months…

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
Franck Pachot

Testing Oracle on exoscale.ch

By | Database Administration & Monitoring | One Comment
 

  My last post came from a discussion at SITB with exoscale. They are doing Cloud hosting with datacenters in Switzerland. In Switzerland a lot of companies cannot host their data outside of the country, which is a no-go for the big Cloud providers. After the discussion they gave me a coupon for a trial IaaS instance. And if you follow my blog you should know that when I have a trial access, there are…

Read More
Morgan Patou

BeeCon – Day 1 – The place to be for Alfresco

By | Application integration & Middleware | No Comments
 

 BeeCon? Beacon? Bacon? Is it some kind of party where you eat some bacon the whole day? Well… Sort of but it is much better! So let me present you the reason behind the BeeCon first.   Back in the Alfresco Summit 2013, the idea of an organization, a group or people from the Alfresco Community came up. This idea grew up and finally in 2014, the Order Of The Bee (OOTB) was created. You…

Read More
Franck Pachot

Can you become a PaaS provider for an Oracle Database service?

By | Database Administration & Monitoring | No Comments
 

 This post is not about technical limitations: Oracle Database is supported in most hypervisors (certified or not) so anybody can provide a DBaaS through a virtual machine as long as it run a supported OS, has enough CPU, memory, and storage, and open the required ports to access to the database (ssh and listener). But you cannot do what you want when you install a software, and you must agree with its licence terms. Who…

Read More
Nathan Courtine

The (almost) same sample schema for all major relational databases (4) – MSSQL

By | Database Administration & Monitoring | No Comments
 

 In previous posts, my colleague Daniel Westermann explained how to install the “Dell DVD Store Database Test Suite” into PostgreSQL, Oracle and MySQL. This time, this is my job to present you how to proceed with a SQL Server instance I will proceed this installation on SQL Server 2014 running under Windows Server 2012 R2. To be coherent with the other RDBMS examples, all the manipulation will be made on Windows core. Yes, it is…

Read More