Infrastructure at your Service

Michael Schwalm

Scripts to duplicate an Oracle database virtual machine: step two

By | Hardware & Storage | No Comments
 

 In January, I promised to show you the next step of a procedure to manage templates with Virtual Box. Don’t worry, I have not forgotten but I was very busy! This step, the final one, consists on customizing of a virtual machine configuration at the start. VMware does it with Templates on ESX, using for example Sysprep for MS Windows guests. I am going to show you how to do it with one simple text file….

Read More
Stéphane Savorgnano

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

By | Database management | One Comment
 

  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. This is my Distributed Replay configuration:   Creation of the trace I will use the two Distributed Replay clients to generate a workload against the target server with two PowerShell Windows which will execute diverse…

Read More
Stéphane Savorgnano

SQL Server 2012 SP 1: Third Cumulative Update (CU3) available

By | Technology Survey | No Comments
 

  Three weeks ago, Microsoft published the third Cumulative Update (CU3) for Microsoft SQL Server 2012 Service Pack one. As usual, if this Cumulative Update solves an issue you are facing, install it quickly – otherwise, do not install it. Which issues are covered by this CU3? It contains 38 Hotfixes: 27 for the Engine 8 for SSAS 3 for SSRS To have more details or information about these hotfixes, click here. Historic of SQL Server…

Read More
Michael Schwalm

Oracle Database Appliance: new ODA X3-2 architecture

By | Operation systems | No Comments
 

  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 ODA release, which leads to a new hardware architecture. So, what’s new with this new ODA version? According to the Release Notes, ODA now supports the new X3-2 architecture which allows additional hardware and storage capabilities….

Read More
Stéphane Savorgnano

SQL Server 2012: Installing and configuring Distributed Replay

By | Database management | No Comments
 

  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 to a new SQL Server test environment. This new functionality is similar to SQL Server Profiler, but with more possibilities: e. g. replaying the trace from multiple clients (up to sixteen), use a stress or…

Read More
Michael Schwalm

Oracle Database Appliance (ODA) – an overview

By | Operation systems | No Comments
 

  Last february, I had the chance to attend an Oracle presentation about ODA: Oracle Database Appliance. I found it interessant to share what I have learned about this technology. Which, I confess, convinced me. Summary Before developing the software and hardware components, here is a small overview of ODA. ODA is an all in one solution providing Hardware, Operating System, and database components. It comes in a 4U rack server form, composed of two…

Read More
Jérôme Witt

Frankfurter Datenbanktage: Bei dbi services hat Ostern schon begonnen…

By | Database management | No Comments
 

 Ganz klar: Unser dbi services Goldhase war das inoffizielle Maskottchen der Frankfurter Datenbanktage! Der Nachfrage nach zu urteilen war es sowohl ein Augen- als auch ein Gaumenschmaus … wir haben auch schon eines “geschlachtet” und brüderlich geteilt. Wir waren in 3 Sessions aktiv und hatten die Freude, viele interessierte Teilnehmer an unserem Stand zu begrüssen! Stéphane Haby hat in seiner Session ein neues SQL Server Monitoring-Tool für Microsoft DBAs vorgestellt: “SQL Server Management Datawarehouse”. Die…

Read More
Stéphane Haby

SQL Server 2012: new perfmon counters

By | Development & Performance | One Comment
 

  I have read some blog postings concerning the new perfmon counters, but I have not seen really extensive overviews yet. In this post, I would like to present not only what is new, but also what has changed (or not) and how to find it. The first step is to select all objects in SQL2008R2 and SQL2012 from the view sys.dm_os_performance_counters. Remarks: All object or counter definitions from this post come from msdn. Objects comparison…

Read More
Stephane Biehler

Ceylon: a new language inspired from Java

By | Technology Survey | No Comments
 

  On 26 February I went to the University of Bern with my colleague Arnaud Berbier to follow an introductory conference on Ceylon, a new language inspired from Java. Unfortunately not presented by Gavin King, the leading developer of Ceylon at Red Hat, the project still was well introduced by Stéphane Epardaud. He is a long-time open source user and contributor, who is now working on the Ceylon compiler: “Because if you’re not writing a…

Read More
Michael Schwalm

Overview of Oracle Linux releases and kernels

By | Operation systems | 2 Comments
 

  As everybody knows, Linux regroups several operating system families. The most popular Linux OS are Debian, Red Hat, or Suse. But each family has many derived Linux distributions. In November 2006, Oracle released the first version of its operating system, totally based on Red Hat Enterprise Linux: Enterprise Linux. Up to release 5, the system came with two kernels: A customized kernel with bug fixes, based on Red Hat kernel, installed and started by…

Read More
Stéphane Haby

SQL Server 2012: Configuring your TCP Port via Powershell

By | Database management | 7 Comments
 

 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 you how to do it. Please note that the code in this article is for SQL Server 2012 on Windows Server 2012. Initialization Run SQLPS to launch the SQL PowerShell in a command prompt. First…

Read More
Jérôme Witt

Wie kann ich Indexes und Daten mittels Data Pump trennen?

By | Database management | No Comments
 

 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 leichter! Dies möchte ich anhand eines ganz normalen Datapump-Export–Files verdeutlichen. In folgendem Beispiel handelt es sich um einen einfachen Schema-Export, der wie folgt erzeugt wurde: oracle@vmoel58:/u00/app/oracle/admin/DB112/etc/ [DB112] cat expdp_SalesApp.par SCHEMAS=sh DIRECTORY=data_pump_dir DUMPFILE=expdp_SH_2013-02-17.dmp LOGFILE=expdp_SH_2013-02-17.log PARALLEL=4 oracle@vmoel58:/u00/app/oracle/admin/DB112/etc/…

Read More