Nick Samoylenko

Team Lead

2
Blog posts
OCI interface to SQL Server
General approach to migrating Oracle applications with OCI interface to Microsoft SQL Server
12 Jun 2019

When migrating a customer’s Oracle databases to Microsoft SQL Server I often face the problem of updating relevant applications. A broad range of our customers use the Oracle Call Interface (OCI) to develop their database applications. Oracle Call Interface is the comprehensive, native C language interface to Oracle Database. Our customers regularly use the OCI interface to create custom and packaged applications. The problem This interface is specific to Oracle and you can’t use it to connect to any other database platform. So, a solution was needed to discover the right path to effectively remediate the customer’s С or C++ applicatio...

create or alter sql server
Using Create or Alter Statement in Microsoft SQL Server
23 May 2019

Managing customer’s SQL Server applications, we discovered a significant performance decrease related to query execution time. We figured out that the reason for that was the execution of a script, which checks the existence of database objects before updating them. The Problem The original script looked as follows: 123456789101112IF OBJECT_ID('dbo.data_xxxx') IS NULL BEGIN CREATE VIEW dbo.data_xxxx AS SELECT VCV.item1, VCV.item2 AS item2, VCV.item3 AS item3 FROM TABLE_A VCV END ELSE BEGIN ALTER VIEW dbo.data_xxxx AS SELECT VCV.item1, VCV.item2 AS item2, VCV.item3 AS item3 FROM TABLE_A VCV END Apparently, the developers created ...