Storage

SQL Server 2016 CTP2: Stretch database feature – Part 2

In my previous blog SQL Server 2016 CTP2: Stretch database feature – Part 1, I explained how to prepare your instance and your database to enable the Stretch feature for your table. Now I present you how to enable(…)

SQL Server 2016 CTP2: Stretch database feature – Part 1

SQL Server 2016 CTP 2 has introduced some interesting new features such as Always Encrypted, Stretch database, the configuration of the tempdb in the SQL Server installation, aso… Regarding the configuration of the tempdb in SQL Server 2016 CTP 2,(…)

Considerations about SQL Server database files placement, Netapp storage and SnapManager

When you install SQL Server, you have to consider how to place the database files. At this point you will probably meet the well-known best practices and guidelines provided by Microsoft but are you really aware of the storage vendor(…)

Oracle Database 12c: Information Lifecycle Management

More and more resources are used in companies to manage data. Most companies buy more and more storage systems because of poor resource utilization. Starting with Oracle 11g, Oracle has introduced Information Lifecycle Management (ILM) which can use different kinds(…)

Oracle Database Appliance: new ODA X3-2 architecture

A few weeks ago, I posted an article about Oracle Database Appliance, focusing on ODA version 2.5.0.0.0. However, a new update of ODA, version 2.5.5.0.0, was released by Oracle on 5 March. This posting will focus on the new(…)

Bug on Oracle 11.2 “ORION FAILS WITH ORA-27061”: Patch available!

In march 2011, my colleague Gregory Steulet published an article about Simulating and testing I/O performances with Orion. In this article, he wrote about a bug concerning Orion on Oracle(…)

SnapManager for SQL Server: databases limitation policy

I recently talked to a customer about SnapManager, its recommendation on the number of databases and about a way to prevent the creation of more than 35 databases. The NetApp recommendation is no more than 35 databases on a single(…)

PostgreSQL : Qu’ai-je installé, Où sont mes données ?

Dans mon dernier article sur PostgreSQL, j'ai présenté l'installation du logiciel en explorant les 2 solutions suivantes, l'installation Debian et l'installation EntrepriseDB. Ces deux installations créent immédiatement un cluster de base de données, Debian nous imposant le point de stockage(…)

Oracle Basics (2) – Data Storage

What is finally the primary objective of a database? Storing Data The question is, how Oracle makes it. For many beginners a confusing topic isto get the picture between physical storage and logical one. So how does it(…)