Database management

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(…)

Configuration des options en Oracle 11g EE avec ‘chopt’

La configuration des options sous Entreprise Edition avant Oracle 11g pouvait être un véritable parcours du combattant. Donc, une attention particulière devait avoir lieu avant l’installation des binaires Oracle; à savoir quelles options devaient être installées! Depuis la version 11g,(…)

Oracle Automatic Memory Management: real memory usage!

When using Automatic Memory Management for Oracle, it is sometimes difficult to monitor the memory usage and in particular to find the right tools to get the right information about currently allocated structures. The instance which will be analyzed has(…)

Oracle Enterprise Manager 12c: creation and management of administrators through emcli

Cloud Control 12c (and the former Grid Control 11g) offers the possibility to create administrators and manage their privileges through the “emcli” command line utility. The main advantage of this method (based on scripts) is to be able to reproduce(…)