Recently, at a customer site, I discovered the Attunity connector 1.1 for Oracle. The customer uses this connector to transfer data from Oracle to SQL Server using Integration Services (SSIS) and informed me that performances are greatly improved. So I decided to post a blog about this connector and perform a benchmark between Attunity connector and Microsoft OLE DB provider for Oracle.

In my previous article, I announced the first fix for SQL Server 2012.

One week later, the first cumulative update is available on the Microsoft website.

The so called Release to Manufacturing (RTM) version of SQL Server 2012 now is available.

I have decided to take some time in this cold month of February to continue this small series. This time, I'm going to speak about Reporting Services (SSRS) and some new features. Like my other article "SQL Server 2012: New features on Integration Services (SSIS)", this article presents a summary of new features and enhancements for SQL 2012 Reporting Services.

Like other SQL server 2012 products, Integration Services has a lot of new features and enhancements. I am presenting a summary of these new "goodies" (from CTP1 to RC0), which can be powerful for DBAs and developers.

Since the third CTP version of SQL Server 2012 (codename Denali), there are some new features available to provide an additional value like the for other Microsoft SQL Server versions. These are pooled in the so called 'Feature Pack' as well as in the 'Manageability Tool Kit'. Both are already available, but not in the final version. I have compiled all information in this blog to find it easily. All DBAs should know that Feature Pack exists, how to find it, and of course use it.

For a few months, I have been testing the new  SQL Server 2012 (codename Denali) and I was very surprised from the DMVs of this version. Dynamic management views (DMVs) return server state information that can be used to monitor the health of a server instance, diagnose problems and tune performance. I will focus on some DMVs which are very interesting for a DBA.

During our test to create a failover clustering with the new function 'AlwaysOn High Availability', we had a few difficulties to overcome like the databases restore on the secondary cluster node.

In this article, we will explain how to avoid it before encountering the problem.

Today, Microsoft gives us his secrets of the next SQL Server version.

Many people do not know how to manage multiple database instances and Integration Services, while facing the end of life for Integration Services reference instance. Let's take a small example with Integration Service installed using instance "TOTO", which comes end of line. We will have a look to SSIS information transfer to a second instance "TITI". This article proposes a small working method to transfer these information correctly. We start with the folders transfer and then get an eye on SSIS packages transfer.

Souvent, je me suis aperçu que beaucoup de personnes se posaient des questions simples sur Microsoft SQL Server, comme par exemple : "Depuis quand existe SQL Server ?", "Quelles versions y a-t-il ?", "C'est quoi les services d'SQL Server" ?
C'est pour toutes ces questions que l'on se pose de temps en temps que je vous propose ce petit article sur le sujet.