This is Christian Coté's Typepad Profile.
Join Typepad and start following Christian Coté's activity
Join Now!
Already a member? Sign In
Christian Coté
Recent Activity
Je suis fier et honoré d'avoir reçu mon renouvellement comme Microsoft Most Valuable Professional (MVP) pour une 8e année consécutive. Depuis 2009, j'ai le plaisir de faire partie d'une communauté qui aide à améliorer les produits Data Platform de Microsoft tout en étant très généreux dans le partage des connaissance avec leurs pairs ainsi qu'avec la communauté de développeurs au travers le mode. J'espère faire partie de cette communauté pour plusieurs années encore! I'm glad and honoured to be awarded a Data Platform Microsoft Most Valuable (MVP) for another year. Since 2009, eight years now, I have the pleasure to... Continue reading
Posted Oct 1, 2016 at ETL/BI Blogger
Je me joins à Isabelle Van Campenhoudt (@isabellevancampenhoudt) pour vous convier au premier 24 HOP (hour of PASS) de notre groupe virtuel francophone. Nous somme fiers d'avoir organisé cet événement. Isabelle et moi avons sélectionné des conférenciers de haut niveau provenant d'un peu partout dans la communauté francophone mondiale. La cédule des présentations étant maintenant disponible, je vous invite à vous inscrire aux présentations qui vous intéressent, c'est gratuit! Christian Coté #24HOPfrancophone Continue reading
Posted Sep 10, 2016 at ETL/BI Blogger
Image
For years I have been controlling how tasks in event handlers or execute package tasks were called using empty sequence containers and expressions. Here is an example of package call I was doing: My package has a parameter named CallPackage1 as shown in picture below: The above parameter is then used in the paths precedence constraints expression to determine if the package will be called or not: So, whenever the parameter was set, the package would execute or not. Since SSIS 2008, we have the ability to disable the package execution without using a sequence container as illustrated above. We... Continue reading
Posted May 25, 2016 at ETL/BI Blogger
I was faced today with a SQL Server collation issue. The new SQL Server instance we had set up was using the wrong collation at both instance and database/tables/columns. This blog post will talk on how I fixed both issues. Changing instance level collation This was the easiest task to do. I followed a well documented method that can be found there. Here is the command I used: Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=mssqlserver /SQLSYSADMINACCOUNTS="<MyMachine\SysadminUser>" /SAPWD=<MySysadminPassword> /SQLCOLLATION=Latin1_General_100_CI_AI As indicated in the command, we're rebuilding the databases here. We have to use a sysadmin user since we're modifying the core database of our... Continue reading
Posted Nov 26, 2015 at ETL/BI Blogger
I'm glad to announce that the book I've been working on with Cem Demircioglu (@cemdemircioglu) is on pre-sale at Amazon: http://www.amazon.ca/Getting-started-Azure-Data-Factory-ebook/dp/B017FI1KNU/ref=sr_1_1?ie=UTF8&qid=1446676613&sr=8-1&keywords=azure+data+factory We're in the revision phase of the book and it should be available way before that the advertised date (January 2016). Writing a book is surely a lot of work but the knowledge you get out of this is invaluable! #Azure, #SSIS Continue reading
Posted Nov 4, 2015 at ETL/BI Blogger
Image
While writing an article earlier on how we could have comments in SSIS, I noticed a property I had never noticed before: we can have a lookup failing when there are duplicates in the reference set. Suppose we have a small package like the one in Figure 1 Figure 1 We have a source and a lookup, the lookup simulates a dimension that would have duplicate reference column values. Here js the reference set returned by the dimension. Figure 2 The name "Christian" appears twice with two different ID's. This should never happen in dimensions but it might be the... Continue reading
Posted Nov 3, 2015 at ETL/BI Blogger
Image
SSIS data flow are very powerful and can sometime be very complex and long. Therefore, like any other programs, we would like the ability to comment sections of the data flows. This post will describe various way to d this. Annotations The obvious way to add comments or notes is to use annotations. Annotations can be used everywhere in a package, control flow, data flows and event handlers. There are efficient and easy to move around everywhere in the package. Figure 1 Now, one feature I like a lot in SSIS data flows is the ability to re-arrange data flows... Continue reading
Posted Nov 3, 2015 at ETL/BI Blogger
Image
Bonjour, ne manquez pas le SQL Saturday à Montréal le 21 novembre prochain ! Voici le lien pour vous y inscrire : http://www.sqlsaturday.com/466/eventhome.aspx L'inscription est gratuite. Des frais de 10$ peuvent s'appliquer si vous désirez manger sur place L'agenda est disponible en suivant ce lien : http://www.sqlsaturday.com/466/sessions/schedule.aspx Hi, don't miss the Montreal SQL Saturday this coming November 21st! Here is the link to register: http://www.sqlsaturday.com/466/eventhome.aspx Registration is free, there's an optional fee (10$) for the lunch if you're interested to eat at the event location. The schedule for the event is available there: http://www.sqlsaturday.com/466/sessions/schedule.aspx Continue reading
Posted Oct 3, 2015 at ETL/BI Blogger
Renewed as SQL Server MVP! I'm glad to be nominated MVP for the 7th time! @MVPAward @Microsoft Continue reading
Posted Oct 1, 2015 at ETL/BI Blogger
HCatalog add a lot of functionalities when we want to reuse schemas between processing tools (Pig, MapReduce). It greatly simplifies data consumption by storing the metastore of Hive tables. There's a great documentation about using HCatalog there. Now, let's look at this scenario. A developer created an external table in Hive and another wants to use it in Pig. For example, a Pig developer want to use the HiveSampleTable. This is a sample table that is created when you create an HDInsight cluster. Without the HCatalog, the Pig developer would have to know where the data is stored and its... Continue reading
Posted Sep 11, 2015 at ETL/BI Blogger
Image
Azure Data Factory (ADF) is always improving. This post will talk about how the editor has improved since its introduction. SHIFT+F10, get the help menu Pressing SHIFT+F10, the following menu appears. From the image above, you can see that several commands are available from this menu: Go to Symbol: displays a list of elements in the JSON that you can access when selecting an element from the list. Change All Occurrences: as it indicates, will change all occurrences of a specific element that you selected. Format Code: this command will correct indentation and align the code correctly for you. If... Continue reading
Posted Aug 22, 2015 at ETL/BI Blogger
Microsoft announced on August 6th 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! Continue reading
Posted Aug 9, 2015 at ETL/BI Blogger
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 Continue reading
Posted Jul 26, 2015 at ETL/BI Blogger
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 Continue reading
Posted Jul 2, 2015 at ETL/BI Blogger
I will have the pleasure to make a session on Azure Data Factory on June 27th 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. Continue reading
Posted Jun 21, 2015 at ETL/BI Blogger
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... Continue reading
Posted Jun 11, 2015 at ETL/BI Blogger
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. Continue reading
Posted Nov 19, 2014 at ETL/BI Blogger
Spe I will have the pleasure to speak on HDInsight and modern data warehouse tools at Winnipeg's SQL Saturday on November 22nd. 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 Continue reading
Posted Nov 11, 2014 at ETL/BI Blogger
I had the pleasure to receive the MVP award for the 6th time this morning. I have been Visual Studio MVP for 3 years and this is my 3rd 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 Continue reading
Posted Oct 1, 2014 at ETL/BI Blogger
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 Continue reading
Posted Sep 29, 2014 at ETL/BI Blogger
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... Continue reading
Posted Jul 1, 2014 at ETL/BI Blogger
I have the pleasure to present at SQL Server 2014 launch in Mississauga this coming June 21st. I will do a session on Modern Data Warehouse: how we incorporate Microsoft HDInsight in our Data Warehouse. The schedule is very interesting and I can't wait to attend the event as well. Continue reading
Posted Jun 8, 2014 at ETL/BI Blogger
Power BI reached General Availability. This a great new for BI community! Thanks to Andrew Burst for the info. Christian Continue reading
Posted Feb 10, 2014 at ETL/BI Blogger
I found that article recently and I found it interesting. It describes how IT and business interact together. Also, it points out how new technologies like in memory models in spreadsheets (read PowerPivot) should be used. I presented many times on PowerPivot and, being a data warehouse (back end) specialist, this article resume pretty much my thoughts on how the new end user tools should be used. I use a strategy similar to the one outlined in the article with some of my clients and it works very well. It allow me to deliver data quickly to the users and... Continue reading
Posted Dec 13, 2013 at ETL/BI Blogger
As Marco Russo states in this post, MCA and MCM certifications would be very beneficial for the Microsoft BI community. I encourage everyone to follow what Marco ask and tell Microsoft that these certifications are needed. So, if you are interested, send an email to advcert@microsoft.com and tell them that we need theses certification. This will help the industry to become more mature with Microsoft BI. Christian Cote #ssas #mcsm #sqlserver Continue reading
Posted Aug 22, 2013 at ETL/BI Blogger