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 I will share it with you… CONTEXT All morning, a policy checks orphan database user on all databases from all…
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 changed the retention period, ran the cleanup but finally, I had always a big database… Why, Why, Why? My first step for…
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 is the same than SQL Server Integration Services 10.0. With SQL Server 2005, the SSIS version is not contained in the service name. To…
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 talking about here. What this first CU for SQL Server 2012 SP1 features: This CU1 contains 44 hotfixes: 33 for the…
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) included in VSTS. What is SQL Server Data Tools? These new tools replace BIDS (Business Intelligence Development Studio). But they…
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 To have more information and download it, click here Historic of SQL Server 2012 If you update your SQL Server…
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, also called EIM
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
…
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.
The so called Release to Manufacturing (RTM) version of SQL Server 2012 now is available.
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.
Like the others products of SQL server 2012, Integration Services has a lot of new features and enhancements.
