Integration services

Delete an orphan user-database under SSISDB

I post a little tips for orphan database-users that we cannot drop so easily in the SSISDB… I discovered this by a customer and it was very tricky to find the explanation and the solution. This is the reason why(…)

SSISDB is too big and it is not every time the retention period’s fault!

In all blogs that I read, the solution is just to change the retention period to a reasonable value. Yes, it is true but in some case you need to go deeper in the analysis… Like you, I(…)

SQL Server, Integration Services and Package Versions

A lot of people ask me about the different versions of SQL Server Integration Services and packages. I create rapidly this little table to summarize it: With SQL Server 2008 and 2008 R2, the SSIS version(…)

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

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(…)

SQL Server 2012: SQL Server Data Tools (SSDT) – Schema and Data Comparison

In my life prior to SQL Server, I worked with Visual Studio Team System (VSTS). The “Schema and Data Comparison” feature of SQL Server 2012 Data Tools is a direct descendant of Visual Studio for Databases Professionnals (aka Data Dude)(…)

SQL Server 2012: Cumulative Update 3 (CU3) now available

This week, the third cumulative update was made available on the Microsoft website. What is in this CU for SQL Server 2012? This CU has 36 hotfixes: 25 for the engine 1 for SSAS 4 for SSIS 6 for SSRS(…)

Stéph@TechEd 2012: End – the new Certification Cycle for SQL Server 2012

For this last day () of the TechEd 2012, I going to present the new certification cycle for dba who wants to be certified for SQL Server 2012. But before, let's start with a brief introduction on Enterprise Information Management,(…)

SQL Server: Attunity connectors for data transfer to Oracle

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(…)

SQL Server 2012: First cumulative update is online

In my precedent article, I announce you the first fix for SQL Server 2012. One week after, the first cumulative update is downloadable on Microsoft website for SQL Server 2012.

SQL Server 2012: RTM now available

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