Infrastructure at your Service

 
Yann Neuhaus

DOAG Konferenz 2012 – mein Fazit: wärmstens zu empfehlen!

By | Technology Survey | No Comments

Die DOAG Konferenz 2012 ist vorbei. Wie immer war sie sehr bereichernd! Wir von dbi services hatten dieses Jahr über drei Präsentationen die Gelegenheit, unser Wissen in den Bereichen Cloud Control 12c – Thema: Datenbank-Backup und Handling des Java-Diagnostic-Tools JVMD (Gérard Wisson) – sowie Linux Container (David Hueber) an die Teilnehmer weiterzureichen. dbi services hat ebenfalls seinen Beitrag zum Treffen der Schweizer Oracle User Group (SOUG) geleistet, einem unter anderem durch das Engagement unseres Partners…

Read More
Stéphane Savorgnano

Risk and Health Assessment Program for Microsoft SQL Server

By | Database management | One Comment

I recently had the chance to go through a so called Risk and Health Assessment Program for Microsoft SQL Server (SQLRAP) at one of our clients. The SQLRAP assesses your SQL Server implementations to ensure proper productive use. It is an excellent opportunity to review the best practices and perform a validation of your client environment by a Microsoft SQL Server Engineer. The SQLRAP program will collect data from the SQL Servers, perform a very thorough analysis,…

Read More
Arnaud Berbier

Oracle Apex 4.2 now released

By | Application integration & Middleware | No Comments

Oracle Apex 4.2 is now available on the Oracle Website. It is available since 12 october 2012. This new release comes with new features briefly described in this blog posting. First of all, here are the new features delivered by the Apex 4.2 release. HTML 5 and CSS 3 improvements: Relooking of all the administration workspace Html 5 charts Html 5 item types (number, e-mail, telephone and URL) New Html 5 themes Mobile support with…

Read More
Oracle Team

Unable to resize tmpfs on Oracle Enterprise Linux 6 versions

By | Operation systems | 4 Comments

I recently helped to create a lab dedicated to a training about Oracle backup and recovery, with Oracle 11g databases. While creating several databases on an Oracle Enterprise Linux 6.1, I wanted to resize the tmpfs to allocate more memory to the databases for AMM (Automatic Memory Management). That was a small challenge 🙂 … By default, the value of the tmpfs is the half of the installed memory. So, on my 3 GB memory…

Read More
Stéphane Savorgnano

SQL Server 2012: Service Pack 1 (SP1) now available

By | Technology Survey | No Comments

Some days ago, the 6th of November, the first Service Pack for SQL Server 2012 was made available on the Microsoft website. SQL Server 2012 Service Pack 1 includes SQL Server 2012 Cumulative Update 1 (CU1) and SQL Server 2012 Cumulative Update 2 (CU2) and therefore all hotfixes that they were included. Which issues are fixed in the SP1: There are 13 issues fixed: 2 for Availability Group 1 for SSIS 1 for Data Quality Client…

Read More
Stéphane Haby

Office 2013 and SQL Server 2012: an integrated, powerful BI solution

By | Business Intelligence | No Comments

I have recently read that PowerPivot and Power View are natively present in Office 2013 and especially in Excel 2013. I found this fun and decided to install the preview of Office 2013!:-D First, what are PowerPivot and Power View? PowerPivot is an add-on to Excel which is used for adding and integrating large amounts of data in Excel workbooks. More information here. Power View is a feature of SQL Server 2012 Reporting Services Add-in…

Read More
Oracle Team

Manage templates manually with Oracle Virtual Box

By | Hardware & Storage | No Comments

To create environments for testing, development, or demonstration, several identical virtual machines are required. Use a technology as VMware vSphere or Microsoft Hyper-V, for implementing a dedicated virtualized infrastructure and use templates, would be the best choice. This solution offers both advanced administration and security capabilities, and allows a centralized access for users. However such an infrastructure needs dedicated servers and networks and could represent high costs. Furthermore it is not always usable from outside…

Read More
Stéphane Savorgnano

Overview of Microsoft Visual LightSwitch

By | Application integration & Middleware | No Comments

Microsoft Visual Studio LightSwitch is a new application development tool wich allows to create fast and nice web and desktop applications. The development environment is the same as the other .NET development tools and creating a new application with LightSwitch works, at the beginning, exactly like with other .NET application: create a new project and choose your programmation’s language between Visual Basic and C#. The following will change our habits. In fact instead of creating…

Read More
Gérard Wisson

Java Virtual Machine Diagnostics: Starting/stopping JVMD manager

By | Application integration & Middleware | No Comments

Although the managed server on which Java Virtual Machine Diagnostics (JVMD) manager is deployed is configured to use the the Node Manager like OMS and admin server, it is not started automatically with OMS. In this post, I will describe how to start JVMD manager automatically when the physical server boots. To implement the script, several steps have to be executed: Creation of a config file containing the encrypted password to connect to the NodeManager Test the…

Read More
Stéphane Haby

SQL Server 2012: SQL Server Data Tools (SSDT) – Schema and Data Comparison

By | Database management | 3 Comments

In my life prior to SQL Server, I worked with Visual Studio Team System (VSTS). The “Schema and Data Comparison” feature of SQL Server 2012 Data Tools is a direct descendant of Visual Studio for Databases Professionnals (aka Data Dude) included in VSTS. What is SQL Server Data Tools? These new tools replace BIDS (Business Intelligence Development Studio). But they are more than just relational database development tools. SQL Server Data Tools (SSDT), code-named Juneau,…

Read More
Jérôme Witt

OOW Day 4: Dive in, Rock out – Oracle Party & Tomy Kyte’s 12 things on Oracle 12c

By | Technology Survey | No Comments

Well, this last day really was funny! We met some old friends (they will recognize themselves) and also Oracle guru Jonathan Lewis. We must confess Larry Ellison really has good friends. His America’s cup boat is really amazing (see picture below) as was last night’s party. Today, we were really tired 😉 and the speakers too. Most of today’s content was a review of what Pierre and I reported during the week. It fits exactly…

Read More