All articles

First installation of SQL Server on Linux REHL 7.2

As you certainly know Microsoft announced yesterday the first preview of SQL Server vNext on Linux. Obviously we are far from a final version suitable for production and the list of unsupported features will probably be good indicator of the(…)

SQL Server 2016 SP1 and unlocked enterprise features!

Starting with the release of SQL Server 2016 SP1, you will probably notice that the standard edition will benefit from a lot of features previously available only on Enterprise edition. Such features concern different areas as performance,(…)

Run SQL Server everywhere!

Running SQL Server everywhere is not a dream anymore!  Microsoft has just announced the first release of SQL Server CTP1 on Linux today! But that’s not all! SQL Server Vnext is also available on Windows,(…)

12cR2: CREATE_FILE_DEST for PDB isolation

By Franck Pachot . Two years ago I filled an OTN idea to 'Constrain PDB datafiles into specific directory' and made it an enhancement request for 12c Release 2. When you provision a PDB, the PDB(…)

Managing My Amazon Web Services Redhat Instance

By Mouhamadou Diaw In a precedent Blog I talked about how to create an AWS linux instance. Some questions can be: How to create a new user and to connect with, how to transfert files from my(…)

Linux Instance in Amazon Web Services (AWS)

By Mouhamadou Diaw In this article I will talk about how to create a linux machine in the cloud amazon AWS. For testing a trial account can be created. Once registered, we can connect by using(…)

12cR2 Single-Tenant: Multitenant Features for All Editions

By Franck Pachot . Now that 12.2 is there, in the Oracle Public Cloud Service, I can share the slides of the presentation I made for Oracle Open World:(…)

12cR2 new index usage tracking

By Franck Pachot . A common question is: how to know which indexes are not used, so that I can drop them. If you tried to use index monitoring you probably have seen the limits of it which make it(…)

12cR2 has new SQL*Plus features

By Franck Pachot . 12cR2 is there. What's new in SQL*Plus? For sure, you can't expect lot of things from it. The new command line is the SQL*Developer sqlcl which aims to be 100% compatible with SQL*Plus with lot of(…)

Documentum – Cannot delete document due to VD/assembly references

I went into an error that you might already have once, so here is a quick guide on how to fix it. When deleting a document from D2 I had a popup with an error like: Cannot delete file because(…)