Infrastructure at your Service

Integration services Archives - Page 2 of 2 - Blog dbi services

Stéphane Haby

SQL Server 2012: new features for Reporting Services (SSRS)

By | Business Intelligence | No Comments

I decided to take some times in this cold February’s month to continue this small series. This time, I’m going to speak about Reporting Services (SSRS) and these new features.

Like my other article “SQL Server 2012: New features on Integration Services (SSIS)“, this article presents a summary from new features and enhancements for SQL 2012 Reporting Services.

Read More
Stéphane Haby

SQL Server 2012: Feature Pack

By | Database Administration & Monitoring | 2 Comments

Since the third CTP version of SQL Server 2012 codename Denali, you have some features available to provide an additional value for Microsoft® SQL Server 2012 like the other SQL Server versions. This Feature Pack or Manageability Tool Kit are available but are not the final version. I have compiled all information in this blog to find it easily.

All DBA should know that Feature Pack exists, how to find it and of course use it.Wink

Read More
Stéphane Haby

SQL Server 2012 ‘Denali’: a new panel of DMVs

By | Database management | One Comment

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.
Since few months, I test the future new version SQL Server 2012 codename Denali and I was very surprised form the news DMVs from this version.
I will just explain some DMVs very interesting for a DBA.
My article is based on msdn web site reference and you find in the end from each chapter a msdn reference for more details of the DMV.

Read More
Stéphane Haby

Changing the reference instance for SQL Server Integration Service (SSIS)

By | Database management | No Comments

In my experience, I have seen many clients do not know how to do when they have multiple databases instances and Integration Servicet for manage the end of the instance that is the reference for Integration Services.

When Integration Service is installed with the instance “TOTO” and that it is at the end of his life, we’ll see how to transfer information to the second instance “TITI”. We present you a small working method to transfer information correctly.

Only the folders transfert is presented in this article and the  transfert of the SSIS packages are explained at the end.

Read More