All articles

SQL Server 2016 – Security: Dynamic Data masking

After my first blog on Security with Row level Security, I test the second Security new feature in the next version of SQL Server: Dynamic Data Masking. I presented(…)

Linux Magic System Request Key Hacks

Recently at a customer we needed to power-cycle a database system because we wanted to be sure that a cluster resource fails over to a remaining node as expected. The issue was that we did not have access to the(…)

SQL> alter database switchover to …

By Franck Pachot . In 12c the manual switchover to physical standby requires only one command (ALTER DATABASE SWITCHOVER) instead of two (ALTER DATABASE COMMIT TO SWITCHOVER on each database). We usually recommend to use the broker and I(…)

SQL Server 2016 query store

One of the most new interesting features that will be introduced by SQL Server 2016 is certainly the query store that will complete the performance tuning toolbox of database administrators. Basically, the query store will track queries, their query plans(…)

Oracle Cloud Service – my first outage

By Franck Pachot . We experienced the first planned outage this week-end, so let's see how it is notified and what happens.

You are in Standard Edition, when to worry?

By Franck Pachot . A previous blog post explaining what happens for those in 'Standard Edition One' had a "don't worry" in the title because you can upgrade to SE2 with minimal additional cost - except(…)

11.2.0.4 support? Don’t worry until 2017

By Franck Pachot . Customers reluctant to go to 12c before 12.2, in addition to Standard Edition contract changes when going to 12c, has lead to lot of upgrades to 11.2.0.4 but what about support? Don't worry. It's supported for(…)

SQL Server 2016: New possibilities for Index Maintenance Task

The new CTP 2.4 has been released some weeks ago by Microsoft. My colleagues and I have already blogged about some new functionalities. I will focus in this blog about the new possibility of Index Maintenance Tasks regarding Indexes. Until(…)

dbsnmp expiring password, manually triggering metrics collections

When you use Enterprise Manager Cloud control 12c, the monitor username commonly used is dbsnmp. Depending on the Oracle profile used for this user, the dbsnmp password can expire, and as a consequence multiple targets will be seen in a(…)

How to migrate your tablespace from 11g to a PDB in the Cloud

Goal We will take a tablespace named FOR TRAVEL for migrate it into a PDB situated in your Europe Cloud in extreme performance database. This migration will be executed with Data Pump and transportable tablespace method. We will migrate the(…)