All articles

SQL Server 2014: FCIs, availability groups, and TCP port conflict issues

After giving my session about SQL Server AlwaysOn and availability groups at the last French event “Les journées SQL Server 2014”, I had several questions concerning the port conflict issues, particularly the differences that exist(…)

All you need to know about Oracle Database licensing with VMware

You are running Oracle on VMware and are not 100% sure that you are compliant with the Oracle licensing rules? This article is for you! As I have been confronted several times with Oracle License reviews with VMware installations, I(…)

Flashback logging overhead: ‘db file sequential read’ on UNDO tablespace

By Franck Pachot . in my previous post I’ve reproduced an issue where some bulk insert into a GTT was generating too much undo. But the real case I encountered was worse: the insert was reading lot of(…)

Insert into GTT: bulk with APPEND_VALUES

By Franck Pachot . This post is about the case I had where a GTT was generating too much undo. The effects were amplified by the fact that the database was in flashback logging (see Jonathan Lewis answer in(…)

Don’t forget to configure Power Management settings on Hyper-V

Recently I had the opportunity to audit a SQL Server database hosted on a Hyper-V 2012 cluster. I noticed that the guest operating system had the Power Plan configured to High performance. This is great thing but when I talked to(…)

Managed Backup with SQL Server 2014

In a previous blog post called Backup a SQL Server database from On-Premise to Azure, I presented the different tools to backup your on-premise databases on Azure Storage. SQL Server Managed Backup to Windows Azure was one of(…)

Oracle multitenant dictionary: upgrade

By Franck Pachot . This is a second part of the previous post about metadata link. I’ve shown how a sharing=metadata function becomes a sharing=none function when it is changed in the pdb – i.e when not having(…)

Oracle multitenant dictionary: metadata links

By Franck Pachot . As in previous posts (1 and 2) I’m still playing with multitenant dictionary. You may wonder why I’m spending time to do unsupported things that we will never be able to use in(…)

Oracle multitenant dictionary: object links

By Franck Pachot . I’ve described Oracle 12c metadata and object links internals in a previous post. But before that, the first time I investigated on it, I made a wrong assumption because I was looking at AUDIT_ACTIONS(…)

Creating a schema synonym in Oracle – an unsupported feature

By Franck Pachot . Ivica Arsov (@IvicaArsov) has made an interesting comment about AUDIT_ACTIONS object link table. I’ll blog about it soon, but in the meantime when checking its definition in cataudit.sql it came upon the following:(…)