BE SHARING

Database Administration & Monitoring

SQL Server 2016 – Security: Dynamic Data masking

23.10.2015 by Stéphane Haby

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(…)

Database Administration & Monitoring

Linux Magic System Request Key Hacks

22.10.2015 by Daniel Westermann

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(…)

Database Administration & Monitoring

SQL> alter database switchover to …

21.10.2015 by Oracle Team

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(…)

Database Administration & Monitoring

SQL Server 2016 query store

19.10.2015 by Microsoft Team

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(…)

Database Administration & Monitoring

Oracle Cloud Service – my first outage

18.10.2015 by Oracle Team

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

Database Administration & Monitoring

You are in Standard Edition, when to worry?

18.10.2015 by Oracle Team

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(…)

Database Administration & Monitoring

11.2.0.4 support? Don’t worry until 2017

16.10.2015 by Oracle Team

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(…)

Database Administration & Monitoring

SQL Server 2016: New possibilities for Index Maintenance Task

16.10.2015 by Stéphane Savorgnano

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(…)

Database Administration & Monitoring

dbsnmp expiring password, manually triggering metrics collections

16.10.2015 by Oracle Team

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(…)

Database Administration & Monitoring

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

16.10.2015 by

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(…)