Microsoft announced on August 6^th the general availability Azure Data Factory (ADF). They also updated ADF documentation to match up GA content:

• Learning Map: this page shows what ADF is and how we can efficiently learn how to work with it
• New article on scheduling: this page shows you the core concepts of ADF.\

Have fun with ADF now!

Last week, Azure Data Factory (ADF) team upgraded the way JSON is used in ADF. The main reason for this upgrade is to simplify or clarify ADF artifacts that are linked services, datasets and pipelines. This upgrade enhance the clarity of the JSON used in these artifacts. Here the link to ADF release notes to get all JSON format changes.

https://azure.microsoft.com/en-us/documentation/articles/data-factory-release-notes/

Christian

Microsoft SQL Server team introduced an official SSIS blog page. This page will give you lots of information’s on new SSIS features and tips.

Happy reading!

Christian

I will have the pleasure to make a session on Azure Data Factory on June 27^th at Vancouver SQL Saturday. I love these events. There are awesome sessions where we learn a lot on new technologies. Speakers always share their techniques based on their expertise or how they use the technology in their work every day.

I’m pleased to announce that the SSIS team at Microsoft have now made available to the public a SSIS feature pack that’ll allow on-premise access to Azure blob and HDInsight. Here are the links to download and install the feature pack for SSIS 2012 and 2014:

SSIS 2012: http://www.microsoft.com/en-us/download/details.aspx?id=47367

SSIS 2014: http://www.microsoft.com/en-us/download/details.aspx?id=47366

Here are the functionalities that this feature pack provides:

• Download and upload files to Azure Storage Blob container.
• Create and delete Azure HDInsight cluster.
• Loop over blobs in an Azure Storage container.
• Call Hive and Pig tasks.

Other functionalities will be integrated in future versions of the feature pack. For me, being a big fan of big data and cloud technology, I think that this is a great new. And that’ll certainly help organizations to support hybrid data movement scenarios (on-prem and cloud data).

In the next few days, I’ll dig into each of these feature pack functionalities in future articles.

Stay tuned!

Christian

I have the pleasure to share the link to an article I wrote on how we can integrate Self-Service BI in Corporate BI strategy. It talks about how important and useful self-service technologies are for most enterprises. The self-service BI strategy sould be part of modern data warehouses strategy . As I state in the article, I find new tools like PowerBI, PowerPivot, PowerQuery, PowerMap and PowerView really useful to get users requirements and involvement in the project.

Spe

I will have the pleasure to speak on HDInsight and modern data warehouse tools at Winnipeg’s SQL Saturday on November 22^nd. I always enjoy speaking at those events because I have the occasion to meet many knowledgeable speakers and attendees. It’s a fantastic occasion for me to learn new things on SQL Server and exchange with SQL Server community.

Christian

I had the pleasure to receive the MVP award for the 6^th time this morning. I have been Visual Studio MVP for 3 years and this is my 3^rd year as SQL Server MVP. There are lots of exciting new features coming in the few next years in the Microsoft BI world. I’m proud to be able to help SQL Server team improving their BI offer.

Christian

SQL Server 2008 R2 Service Pack 3 Now Available!
SP has been released!

More info here: http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/09/26/sql-server-2008-r2-service-pack-3-has-released.aspx

Download SQL Server 2008 R2 Service Pack 3

http://www.microsoft.com/en-us/download/details.aspx?id=44271

Je présenterai le 12 juillet en ligne au Pass Global French Chapter sur les entrepôts de données. Voici les détails de la session :

Inscrivez-vous à Modernisez votre entrepôt de données avec SQL Server 2014 et HDInsight le 12 juil. 2014 13:00 EDT ici :

https://attendee.gotowebinar.com/register/3298516551114248449

Les architectes d'entrepôts de données font face à plusieurs défis dû à l'apparition de nouvelles sources de données et des besoins de plus en plus pressants des utilisateurs. Cette session démontrera les nouvelles fonctionnalités qui s'offrent aux architectes/désigners d'entrepôts de données avec SQL Server 2014 et Microsoft Azure HDInsight.

Conférencier: Christian Coté

Une fois inscrit(e), vous recevez un e-mail de confirmation contenant les informations relatives à la procédure d'accès au webinaire.

L'inscription est gratuite. Je vous y attend!