Database Administration & Monitoring

Row Level Security (RLS) is also coming to MS SQL Server

Why “also” in my title? On 29 August, my colleague Daniel Westermann wrote an article about Row Level Security in the next version of PostgreSQL. Row Level(…)

SQL Server 2016: Transaction Performance Analysis Overview & In-Memory OLTP Migration Checklists

To be able to define which Tables or Stored Procedures will us the best performance gain after migration to In-Memory OLTP, SQL Server 2014 provided a tool called AMR (Analysis Migration and Reporting). This tool was really interesting but we(…)

SQL Server 2016 : availability groups with no domain dependencies

Are you aware about the new features of the next Windows version? Currently we’re in TP3 and during my investigation, I was very happy to see the new features for Windows clustering (cf. this blog post from Microsoft). By(…)

SEVERE:OUI-10020:The target area /u01/app/oracle/oraInventory/ is being used as a source by another session

What to do if you get the above error when you try to install Oracle SE2 (did not test if the same issue is there with EE, but probably it is) in silent mode?: ./runInstaller oracle.install.option=INSTALL_DB_SWONLY ORACLE_BASE=/u01/app/oracle/ ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_2_4/ UNIX_GROUP_NAME=oinstall oracle.install.db.DBA_GROUP=dba(…)

Do you use SQL Plan Baselines?

By Franck Pachot . I can hear a lot of complaints about the instability coming from the adaptive features introduced into the optimizer logic at each release. Giving more intelligence to the optimizer is very good to improve the response(…)

SQL Server AlwaysOn : readable secondary replicas and index rebuild online vs offline

A couple of weeks ago, I was involved in a discussion on the French forum developpez.com about SQL Server AlwaysOn and availability groups, index strategies and the impact on the readable secondary replicas. During this discussion,(…)

You are in Standard Edition One? Don’t worry.

By Franck Pachot . You want the amazing features of Oracle SQL and PL/SQL with minimal cost. Your database is too large for Oracle XE edition, but not big enough to require the cost of Enterprise Edition. You accept to(…)

SQL Server 2016 : availability groups and the new ssis_monitor role for SSIDBB catalog

During my investigation about the new AlwaysOn features, I wrote a blog post about the new SSISDB support for AlwaysOn. You can find it here: > SQL Server 2016 : availability groups and the new SSISDB support Just as(…)

Install Oracle instant client and perl DBD::Oracle @ Mac OS X Yosemite

Recently, I tried to install and connect to Oracle databases directly from my new Mac Book using perl  (Yes, perl is still one of the most friendly programming language for DBAs). What first seemed to be easy was in reality(…)

SQL Server AlwaysOn: number of databases and the hadr worker pool

Often, when I’m in charge to implement an SQL Server AlwaysOn infrastructure with availability groups, customers ask me if it exists some best practices and recommendations about the maximum number of databases in an availability group planning. In fact, we(…)