Infrastructure at your Service

 
Oracle Team

Creating Custom reports with BI Publisher

By | Database management | No Comments

BI Publisher offers you the possibility to create your own custom reports, I will describe you how to create a report displaying the tablespace size and used size in a simply way. It is advised to create a specific folder in which we will create our reports, because in case of upgrade you won’t lose your BI reports. In the catalog window, you select create folder: We have to grant permissions to this folder to…

Read More
Oracle Team

EM 12.1.0.4 and BI Publisher Configuration

By | Database management | No Comments

This document explains how to configure BI Publisher in Enterprise Manager Cloud Control 12.1.0.4.0. Before the 12.1.0.4, the BI Publisher installation was fastidious, it was necessary to download, install and configure it. In Enterprise Manager 12.1.0.4 BI Publisher is already packaged. After a fresh installation or an upgrade to 12.1.0.4, BI publisher is installed but not configured. By selecting the BI publisher report menu, the following message will be displayed:     You can follow…

Read More
Franck Pachot

Oracle 12c: comparing TTS with noncdb_to_pdb

By | Database management, Oracle | No Comments

By Franck Pachot . How to migrate from non-CDB to CDB? Of course all known migration methods works. But there is also another solution: upgrade to 12c if necessary and then convert the non-CDB to a PDB. This is done with the noncdb_to_pdb.sql which converts a non-CDB dictionary to a PDB one, with metadata and object links. But do you get a clean PDB after that ? I tested it and compared the result with…

Read More
Grégory Steulet

Security improvements in MySQL 5.7

By | Database management | One Comment

If you have a look on the last mysql 5.7.4 version or later you will probably see that there are several security improvements. The list of added security features and improvements can be seen on the following page: http://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html There are three main improvements that are shortly described in this blog: 1. Nonempty plugin column 2. Password lifetime policy 3. mysql_install_db secured Nonempty plugin column As of MySQL 5.7.2, the server requires account rows in…

Read More
Franck Pachot

When Oracle resets session statistics

By | Database management, Oracle | No Comments

By Franck Pachot . During our Oracle 12c New Features workshop I had a very good question about whether the session statistics are reset or not when doing ALTER SESSION SET CONTAINER. My initial thought was that they were not reset because it’s the same session (same SID and SERIAL#). But when I’m not 100% sure about something, I test it. And once again, it proves that even the instructor can learn something new when…

Read More
Stéphane Savorgnano

Windows Server 2012 R2: solving .NET Framework 3.5 installation problems

By | Operation systems | 25 Comments

I faced a problem at a customer site last week when I tried to install the .NET Framework 3.5 – a prerequisite for installing SQL Server 2012 on a Windows Server 2012 R2. I opened the Server Manager and then navigated to the Manage, Add Roles and Features section: I selected the .NET Framework 3.5 Features option: I specified an alternate source path: … and surprise! Even though an ISO of Windows Server 2012 R2…

Read More
Grégory Steulet

Oracle AVDF – Database Firewall Policies

By | Database management | 4 Comments

The successful deployment of a Database Firewall depends on an effective policy. Oracle AVDF includes preconfigured firewall policies as described in the Firewall Policy page in the Policy tab of the Audit Vault Server console. These include policies that log all SQL statements, or log only unique SQL statements. In addition, the Database Firewall policy editor enables you to design your own policies quickly and efficiently. Policy rules can depend on any combination of the…

Read More
Franck Pachot

Oracle 12c privilege analysis rocks

By | Database management, Oracle | 4 Comments

By Franck Pachot . 12c came with a very nice feature: privilege analysis. You don’t know which privileges are required? then just grant DBA, run your application, and check which minimal privileges are needed. And today, I’ve discovered how it is very powerful: you can even see privileges used internally, even when not done by SQL, and even not documented. It starts like that, with a question from Vladimir Sitnikov (who publishes very interesting stuff…

Read More
Microsoft Team

WSFC : Manual or automatic failover? That is the question!

By | Hardware & Storage | 2 Comments

During the night, you receive an alert concerning your SQL Server failover cluster or your availability groups and you’re in panic mode because the message displayed is : a failover has occured .. see the log for more details … So keep quiet and after connecting to your environment you are not able to find anything … What was happen? Maybe someone has triggered manually a failover and you are not aware of it. I’m…

Read More
Stéphane Haby

SQL Server tips: Executing a query with the EXECUTE command

By | Database management | No Comments

This short SQL Server blog post is meant to help people who have experienced the error messages 2812 and 203 with the EXECUTE command. The goal is to execute a simple query from a variable in a string format with the EXECUTE (exec) command. Very easy, isn’t it? Ok, let’s GO! If I execute “select * from sys.databases” in SSMS, in SQLCMD or in PowerShell – no problem, I have the list of all databases…

Read More
Microsoft Team

JournĂ©es SQL Server 2014: il n’est pas trop tard pour vous inscrire

By | Technology Survey | No Comments

Le plus grand Ă©vĂ©nement français va bientĂ´t avoir lieu (1 et 2 dĂ©cembre) Ă  Paris et il vous reste  encore une semaine pour vous y inscrire! Pensez Ă©galement Ă  commander votre lunch box, ce qui peut ĂŞtre pratique si vous voulez manger 🙂     Pour ma part j’aurai l’occasion d’ouvrir le bal et de vous retrouver au cours d’une session sur SQL Server et les groupes de disponibilitĂ© (cela devient presque une habitude) lundi matin…

Read More
Microsoft Team

SQL Server 2014: buffer pool extension & corruption

By | Database management | No Comments

I had the opportunity to attend Paul Randal’s session on advanced data recovery techniques at the Pass Summit. During this session one attendee asked Paul if a page that has just been corrupted can remain in the buffer pool extension (BPE). As you probably know, BPE only deals with clean pages. Paul hesitated a lot and asked us to test and this is exactly what I will do in the blog post. First, let’s start…

Read More