Infrastructure at your Service

 
Microsoft Team

SQL Server 2014: Availability groups failover impossible with Failover Cluster Manager

By | Hardware & Storage | 2 Comments

A couple of weeks ago, I worked for a customer that wanted to implement SQL Server 2012 (and not SQL Server 214) AlwaysOn with availability groups. During our tests we performed a bunch of failover tests and the customer tried to perform a failover of one of the installed availability group by using the failover cluster manager (FCM). Of course, I told him this is not best practice because the failover cluster manager is not…

Read More
Franck Pachot

How to list all Oracle system schemas

By | Database management, Oracle | 4 Comments

By Franck Pachot . Do you want to know which users come with the Oracle Database and which are the ones you have created? This is that not easy, especially prior to Oracle 12c. You know SYS and SYSTEM, but there are many others – especially when you have installed all options. And it is important to know them all, e. g. when you import or apply a password policy, etc. Let’s see the options…

Read More
Stéphane Savorgnano

How to avoid Failover Cluster with PowerShell scripting

By | Application integration & Middleware | No Comments

One of my colleague asked me some days ago if I could create a PowerShell script to get rid from Windows Server Failover Cluster. The reason is that it has, in some specific cases, the bad habit to failover a resource or a service even when we don’t want it. To be honest, I use a lot the Failover Cluster feature of Windows Server without any problems as a SQL Server DBA, but for this specific…

Read More
Morgan Patou

Configure a Kerberos Client and Alfresco as a Kerberized application

By | Application integration & Middleware | No Comments

In the previous blog, I described How to install and manage a Kerberos Server but that’s useless if there are no clients and if no application have been kerberized! That’s why in this blog I will explain in the first part how to install a kerberos client in linux. The second part will be dedicated to the configuration of a browser to use Kerberos tickets and the last part will explain how to configure a…

Read More
Franck Pachot

Oracle Exadata – poor optimization for FIRST_ROWS

By | Database Administration & Monitoring, Oracle | 3 Comments

By Franck Pachot . In a previous blog, I discussed the difference between rownum and row_number(), in particular their behaviour in implicitely adding a first_rows(n) to the optimizer. That reminded me that I forgot to blog about an issue I encountered and which concerns both approaches. It was on an Exadata: a nice full table scan with smartscan was taking a long time. And forcing to an index access – with a very bad index…

Read More
Microsoft Team

Tempdb enhancements with SQL Server 2014

By | Application integration & Middleware | No Comments

SQL Server 2014 is definitively designed for performance and I will try to demonstrate it during this blog post. I like to talk about hidden performance features because generally it does not require any changes for applications unlike in-memory tables for instance (aka hekaton tables). Since SQL Server 2005 version some improvements have been made for tempdb. Tempdb caching is one of them and allows to reduce the page allocation contention. Basically to create a…

Read More
Franck Pachot

Oracle 12c extended datatypes better than CLOB?

By | Database management, Oracle | 8 Comments

By Franck Pachot . 12c has introduced character strings that can can go above 4000 bytes. In the previous versions, in PL/SQL only we were allowed to have VARCHAR2 up to 32k. In SQL the VARCHAR2 datatype was limited to 4000 and CHAR was limited to 2000. That became a bit small especially when lot of applications needed to store unicode characters. From 12c we can have SQL datatypes having up to 32k bytes for…

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