Database management

Oracle Database 12c: Gérer le Password File avec ASM

En dehors de l’annonce de Flex ASM, ASM évolue peu dans Oracle 12c. La plus intéressante des améliorations pour les administrateurs de bases de données en cluster est l’introduction de la gestion des “Password Files” dans ASM. C’est l’objet(…)

Oracle 12c now available for download on OTN and Oracle E-delivery

Finally after some months … The Oracle’s long-awaited 12c database (12.1.0.1) is now available for download on OTN and Oracle E-delivery ( http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html). Without any surprise the first platforms are Linux and Solaris! Weird, but until now(…)

SQL Server 2012: System views poster available

Good news for all SQL Server DBAs: DMVs and DMFs poster are now available for SQL Server 2012. You can download them here. You can choose between 2 formats: pdf and xps. What’s new?(…)

SQL Server 2012: CompoundCurve – a new geospatial feature

There are three new geospatial features in Microsoft SQL Server 2012: CircularString, CurvePolygon, and CompoundCurve. For the fun and as an example, I will test CompoundCurve, a set of circular strings that may be combined with line strings, and(…)

Monitoring SQL Server with Oracle OEM Grid Control 11g

Recently, I had the chance to install the SQL Server Plug-in for Oracle Entreprise Management Grid Control 11g to monitor a SQL Server instance based on a windows host. Our client, who monitors these Oracle databases via OEM Grid Control(…)

SQL Server 2012: Create & replay a trace with Distributed Replay

My last blog was about installing and configuring Microsoft SQL Server 2012 Distributed Replay. This time, I will show you how you can create a trace and replay it with Distributed Replay Clients on a specific SQL Server target.

SQL Server 2012: Installing and configuring Distributed Replay

Distributed Replay is a new fonctionality of Microsoft SQL Server 2012. It helps you assess the impact of future upgrades (SQL Server, hardware, OS) or SQL Server tunings by replaying a trace captured from a productive SQL Server environment(…)

SQL Server 2012: Configuring your TCP Port via Powershell

Changing the default TCP port 1433 for SQL Server is an important step for securing your SQL Server. I have written a script in PowerShell to modify the port number that helps me perform this task. This blog posting will show(…)

Wie kann ich Indexes und Daten mittels Data Pump trennen?

Diese Frage habe ich in den letzten Jahren öfters gehört. Zumindest seitdem die DBAs Oracle Datapump verwenden anstatt des alten Export/Import Tools. Angeblich war es früher mit dem Import-Parameter-Tool „INDEXFILE“ viel einfacher. Tja, die Wahrheit ist: Mit Datapump geht es noch(…)

Mysqldump issue – SELECT command denied to user

During one of my last MySQL mission, I encountered a “security error” with mysqldump. The mission was about migrating a MySQL database from one box to another MySQL version and from Windows to Linux with different users. In order(…)