Infrastructure at your Service

 
Microsoft Team

SQL Server 2014 : New incremental statistics

By | Application integration & Middleware | One Comment

Do you use partitioning with SQL Server? If yes this post is for you because there are good news about partitioning with SQL Server 2014. I remember an old job with a healthcare customer who we decided to implement a partitioning strategy for a big transaction archive table for medical records. We used SQL Server 2005 and we already faced to some challenges like statistics updates. Database administrators who use partitioning with version older than…

Read More
Oracle Team

Oracle policy managed databases: Policies and policy sets

By | Database management | One Comment

In this post, I will continue my experiments with Oracle policy managed databases with Grid Infrastructure, and present one of the new features introduced with Grid Infrastructure 12c last June: the cluster configuration policies and policy sets. It allows the administrator to dynamically reconfigure all server pools at a time, with a single command, according to the business workload. To take a simple example, imagine you have two servers allocated for your production instances, and…

Read More
Franck Pachot

Oracle SQL Monitoring reports in flash, html, text

By | Database management, Oracle | One Comment

By Franck Pachot . I have recently posted on the way I like to extract execution plans. When we have Tuning pack, I suggest to get them with SQL Real-Time Monitoring as an active report. However, Martin Preiss said in a comment that he prefers the text format – easier to search, copy, and paste. And that’s a very good remark. We still need plain text. My point is that if you send me the…

Read More
Nathan Courtine

ESPC 2014: Upgrading To SharePoint 2013

By | Application integration & Middleware | 2 Comments

I have decided to make a resume of the presentation “Upgrading SharePoint 2013” by Sam Hassani that I have followed at the European SharePoint Conference 2014. This is meant for the people who did not have the chance to attend to the event taking place from 5 to 8 May 2014 in Barcelona! For more details on the Conference presentations, have a look at the agenda. History of upgrades in SharePoint Historically, there are three…

Read More
Stéphane Haby

One day @ Bob Ward’s SQLOS Workshop

By | Technology Survey | No Comments

We had the opportunity with David Barbarin, to fly to Wroclaw (Poland) to participate in the SQLDay 2014 (annual conference of the Polish SQL Server User Group) for the first time. We don’t speak Polish but we met Bob Ward who held a very interesting level 500 workshop titled “Inside SQLOS and Memory”. This pre-conference seminar session was for us the opportunity to benefit from Bob Ward’s Expertise. This event was held at the football…

Read More
Franck Pachot

Exploring Oracle SE & EE performance statistics with Orachrome Lighty

By | Database management, Oracle | No Comments

By Franck Pachot . At dbi services, we really like Lighty for Oracle, a tool which helps exploring performance statistics whether they originate from AWR (available only in Enterprise Edition with Diagnostic Pack option) or from Statspack (available via Standard Edition). As a matter of fact, we like it so much that we have became Orachrome Partner. If you want to try it out for yourselves, there is a free trial here. If you have…

Read More
Oracle Team

Implementing policy-managed Oracle databases

By | Database management | No Comments

Policy-managed databases appeared with Oracle 11g R2 but are not very common yet. I never had the opportunity to administer these kind of databases. Since Oracle now presents policy-databases as the default installation mode and as a best practice, I wanted to know more about this feature which fully automatizes the databases repartition within an Oracle cluster. In this post, I will describe how to implement and handle policy-managed databases, and in a future post…

Read More
Nathan Courtine

Improving your SharePoint performance using SQL Server settings (part 1)

By | Database management | 4 Comments

SharePoint performance is a recursive problem and preoccupation. As a Database Administrator, we have to deal with SharePoint when configuring SQL Server databases. In this article, I will propose a list of best practices in SQL Server settings aimed to reduce SharePoint performance issues. This article is inspired from the presentation Optimizing SQL Server for Speedy SharePoint by Sahil Malik held at the European SharePoint Conference 2014 in Barcelona. Autogrowth Do not keep the default…

Read More
Microsoft Team

SQL Server 2014: SELECT INTO operators can run in parallel

By | Application integration & Middleware | No Comments

A couple of weeks ago, I had to provide some best practices in term of architecture for a “heavy writes” environment that consists in importing data from different sources into SQL Server tables. At the customer place, I was asked about interesting new SQL Server features that could be used to increase the performance speed of the data import process. Indeed, SQL Server 2014 provides an interesting enhancement of SELECT INTO statement that is often…

Read More
Franck Pachot

ROWNUM vs ROW_NUMBER() and 12c fetch first

By | Database management, Oracle | 4 Comments

By Franck Pachot . Prior to Oracle 12c, there were two ways to do ‘top-n’ queries: use rownum after sorting rows with “order by” use row_number() over (order by) Top-n queries are usually required for result pagination. The application shows the first 10 rows, then the next 10 on the following page, etc. In these queries, user interactions are often stateless, so we cannot just open a cursor and fetch 10 rows on each user…

Read More
Franck Pachot

Oracle 12c CDB – metadata & object links internals

By | Database management, Oracle | 24 Comments

By Franck Pachot . Warning: this is only geek stuff about internals on multitenant database dictionary, metadata, and object links. It has nothing to do with the operations that you can do on your database. Don’t try that in production or you can corrupt the whole dictionary. In 12 multitenant database (aka CDB) we know that each pluggable database is isolated in order to act as a standalone database. But they share some common resources…

Read More