Infrastructure at your Service

Stéphane Savorgnano

SQL Server 2014: Readable Secondary with In-Memory objects

By | Database management | No Comments

In-Memory OLTP is one of the best new functionalities of SQL Server 2014 as it was the case with AlwaysOn and SQL Server 2012. In-Memory OLTP is fully integrated with AlwaysOn and also with AlwaysOn Availability Group. During my test with AlwaysOn Availability Group under SQL Server 2014 CTP2, I discovered that a Readable Secondary Replica was not able to access In-Memory OLTP objects. I have a Readable Secondary Replica named pc1 with a database…

Read More
Stéphane Haby

SQL Server 2014: Rebuilding Clustered Columnstore Indexes

By | Database management | No Comments

I was surprised that you have to rebuild indexes that are stored In Memory. My previous posting “SQL Server 2014 – New Features: xVelocity memory optimized columnstore index” explains all processes connected with columnstore indexes. In this article, I will explain why, when, and how to rebuild them. Why do we need to rebuild the Clustered Columnstore Indexes? When a row is deleted, SQL Server marks the row as logically deleted. Physically, the row is…

Read More
Oracle Team

Archivelog deletion policy for Standby Database in Oracle Data Guard

By | Database Administration & Monitoring, Oracle | 43 Comments

By Franck Pachot . Do you use ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY for your Oracle databases in Data Guard? Maybe you also use the Fast Recovery Area as archive log destination. That’s good practice! But did you ever check that it works as expected? What I mean is this: The archived logs that you don’t need are reclaimable by the FRA when space is needed And the archived logs that are required…

Read More
Oracle Team

Oracle LOBs: Infer the file type with dbms_lob package

By | Application integration & Middleware | 3 Comments

LOBs (Large OBjects) first appeared in Oracle 7 and were created to store large amount of data such as document files, video, pictures, etc. Today, we can store up to 128 TB of data in a LOB, depending on the DB_BLOCK_SIZE parameter settings. In this posting, I will show you how to load LOB files into the Oracle database and will present a way to identify the file type of the LOB stored in the…

Read More
Oracle Team

Oracle 12c: Applying PSU 12.1.0.1.1 with Multitenant DB & unplug/plug

By | Database management | No Comments

The concept of Multitenant databases, which was introduced with Oracle 12c in June 2013, allows to run several databases on a single instance. Oracle presents this feature as a good solution for Oracle patching. The reason behind it is that it is now possible to unplug a container database (called PDB) from its original container (called CDB), in order to plug it into a new local or remote Container with a higher level of PSU….

Read More
Oracle Team

Sockets, Cores, Virtual CPU, Logical CPU, Hyper-Threading: What is a CPU nowadays?

By | Application integration & Middleware, Oracle | 6 Comments

By Franck Pachot . Because people know that I really like Oracle AWR reports, they send them to me from time to time. Here is one I have received for Christmas with the following question: ‘Since our AIX server is virtualized, the response times are 4x longer. I feel that we are CPU bound, but cpu usage is mostly idle. Is there something hidden?’ It is a question that is frequently raised with virtualized environments….

Read More
Pierre Sicot

Implementing Oracle Database as a Service (DBAAS)

By | Database management | 3 Comments

Oracle DBAAS (Database As a Service) offers a good solution for on demand access to software and infrastructure. In this posting, I will describe the DBAAS implementation with Enterprise Manager Cloud 12c. Why Database as a Service is interesting When a developer team needs a new database, the system administrator has to configure the host, the storage administrator has to configure the storage, and the database administrator has to download the latest oracle database version…

Read More
Stéphane Haby

With Power Query, converting an internet table to Excel is an easy job!

By | Application integration & Middleware | No Comments

While exploring SQL Server 2014, I was surprised by the powerful Power Query feature. In the recent past, converting an internet table to Excel was a nasty work leading to format problems, implicit conversions, etc. With Power Query, importing tables from the internet is very easy! What is Power Query? Power Query is a tool based on the concept of Power BI (more on this tool here). Power BI is composed of: PowerPivot The first…

Read More
Stéphane Haby

SQL Server 2014 – New Features: xVelocity memory optimized columnstore index

By | Application integration & Middleware | No Comments

Some customers or colleagues recently asked me about the SQL Server concept xVelocity and in particular the SQL Server 2014 feature new xVelocity memory optimized columnstore index. So I decided to write a few words on the dbi services blog. What is xVelocity? Introduced in SQL Server 2012, xVelocity is composed of two features:  xVelocity in-memory analytics engine  xVelocity memory-optimized columnstore index xVelocity in-memory analytics engine The xVelocity in-memory analytics engine is an update of…

Read More
Pierre Sicot

Oracle Database 12c: Database Migration Assistant for Unicode

By | Technology Survey | One Comment

The choice of the correct character set before you create an Oracle 12c database is an important decision. You have to know the type of data you have to store and the languages needed by the Oracle database. Oracle recommends to choose Unicode for its universality and compatibility. It supports all written languages and most of the technical and scientific symbols. Before Oracle 12c changing the database character set was an pretty nasty task and…

Read More
Microsoft Team

IT Pro TechDays 2013 in Lausanne: BYOD, SQL Server & SharePoint

By | Technology Survey | No Comments

I had the opportunity to attend the IT Pro day at the Microsoft Techdays in Lausanne. Let me give you a few insights on my day there. Being a SharePoint specialist but also ramping up on Microsoft SQL Server I tried to balance between SQL and SharePoint related sessions. BYOD As usual, the day started with a Keynote focusing on an overview of the new Windows 8.1 and Windows Server 2012 R2 features. Well… it…

Read More