The Challenge: Modern Data Complexity As businesses scale, so do their data environments. With hybrid cloud adoption, legacy system migrations, and stricter compliance requirements, IT teams must ensure test environments are: The Solution: Delphix & OMrun Also for your heterogenouse data storage technology, Delphix and OMrun provide a seamless way to virtualize, anonymize and validate your test data securely and…
If you read my previous blog, you know why I’m doing a migration 🙂 If not let’s explain it a bit, since 1 year I play with M-Files using an VM in the cloud, but I reached the limits and running a lot of Vaults start to become costly for a simple playground.Additionally as the VM is stopped during the…
In many cases, you need a data migration from an existing on-premises databases to the cloud. Not only is it necessary to move your data, but often you also need to change the technology stack. In addition, it is very important to ensure that all records have been transferred correctly. OMrun is the ideal tool to achieve these goals with…
Procedure to check a one-to-one migration between different database types autogenerated and generically with OMrun.
I’m currently setting up a lab for Nutanix Era in order to be able to provide some presentation on this subject and see how Nutanix Era interacts with Oracle databases. I therefore thought it would be certainly helpful and a good opportunity to share the feedback I’m getting from this experience. The lab has been built using Nutanix Cluster free…
AWS S3 offers different Storage Classes, allowing to optimize cost among others. For instance, some classes are used for archiving purposes: S3 Glacier and S3 Glacier Deep Archive. It means the storage cost is the lowest you can obtain, but your data is not available immediately and the access cost is increased. In the case of S3 archive classes, retrieving…
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…
A customer asks me, what is the collation for System Center products? Do we have a general collation for all products? And what is the BP for Tempdb? And how work the licencing for SQL Server in System Center (is SQL Server included)??? I answer just “OK, OK, I understand, I wil check those points…” I search those information on…
I often noticed default values for database file autogrow settings during my audits. You don’t trust me? Let me talk about a funny story about an incredible (and extreme) situation that concerns a transaction log file and its default settings. First of all, during my intervention, my customer complained of some performance issues, so I decided to take a look…
This blog post is focused on the new supportability of SSIDB catalog on AlwaysOn architecture. Others studies are available here: New database issue level detection for automatic failover Potential features in standard edition Automatic failover enhancements New load balancing features with read-only replicas New clustered columnstore index support A couple of weeks ago, I was involved in an SSIS infrastructure…
WHAT IS? Boundaries: are Static limits that cannot be exceeded by design. An example of a boundary is the 2 GB document size limit. Thresholds: are configurable limits that can be exceeded to accommodate specific requirements. A good example is the document size limit. Supported limits: are configurable limits that have been set by default to a tested value. An…
Since SQL Server 2014 CTP2, Microsoft has introduced a new kind of index which is the Range index. We have now two ways for indexing an In-Memory table: using either an Hash index or a Range index. These two indexes are slightly different. In fact, a Hash index is a set of buckets, 8-bytes memory pointers, which points to the…
