Infrastructure at your Service

Nicolas Jardot

UKOUG 2012: Day 1 – Oracle 12c features and database performance

By | Technology Survey | No Comments
 

  Today was the official launch of UKOUG 2012. We started with keynotes including one from Tom Kytes giving information about Oracle 12c features. Then I had some very interesting sessions on database performance. Oracle 12c When we talk about performance issues on SQL statement, it’s really often due to bad/missing statistics and Oracle using the wrong execution plan. In next Oracle database two features may (or not) help us to deal with this topic: Enhanced…

Read More
Stéphane Savorgnano

SQL Server 2012 SP1: First Cumulative Update (CU1) now available

By | Technology Survey | No Comments
 

  A couple of days ago (20 November 2012), Microsoft rolled out the first cumulative update (CU1) for SQL Server 2012 Service Pack 1 (SP1). It’s just two weeks after the release of the first Service Pack (SP1) we are talking about here. What this first CU for SQL Server 2012 SP1 features: This CU1 contains 44 hotfixes: 33 for the Engine 3 for SSAS 4 for SSRS 4 for SSIS If you want to…

Read More
Nicolas Jardot

OakTable at UKOUG 2012: Hybrid Columnar Compression (Exadata), SQL tuning, etc.

By | Technology Survey | No Comments
 

  Yesterday, I went to a set of sessions organized by OakTable members just before the kick-off of the UKOUG conference 2012, one of the biggest events on Oracle Technology and E-Business in Europe. This post focuses on some of the covered topics, such as database development, Hybrid Columnar Compression (Exadata), optimizer statistics, and SQL tuning. There were 2 streams with very interesting topics. I attended to sessions covering the following topics: Application development: Keep…

Read More
Gérard Wisson

DOAG 2012: News on WebLogic 12c, monitoring, licensing

By | Application integration & Middleware | No Comments
 

 I spent three interesting days at the DOAG Konferenz 2012 – the German Oracle User Group’s conference. It was the 25th birthday and my first time as a DOAG Konferenz speaker. In this post, I will not talk about my presentation, but rather give you information from the sessions I went to. I will talk about three areas: Oracle WebLogic 12c, monitoring & diagnostics, and licensing. Regarding WebLogic, Mr. Munz from munz & more described…

Read More
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…

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…

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 sized…

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…

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