Welcome to my blog!

SQL Server Integration Services (SSIS), Enterprise Information Management (EIM) and general Data Movement
Defining Configurable Settings for your Queries

Defining Configurable Settings for your Queries

(The information in this blog post is current as of the March 2014 release of Power Query.) The Problem A colleague sent me a copy of the Excel workbook they used for a blog post about using Power Query with Project Online (see the fantastic article: Creating burndown charts for Project using Power Pivot and Power Query). The workbook has a query which uses the Project OData API to pull down Task information to produce a “burndown” chart. The query was configured...

OData Source for SSIS

OData Source for SSIS

A new OData Source for SSIS is now available. The 2012 version is available as a standalone download, and the 2014 version is part of the SQL Server 2014 Feature Pack. OData Source for SQL Server 2012 OData Source for SQL Server...

Presenting at SharePoint Conference 2014

Presenting at SharePoint Conference 2014

I’m looking forward to attending and presenting at my first SharePoint Conference next week in Las Vegas! I’ll be presenting two Power BI deep dive sessions (1): #SPC397 - Deep Dive on the Data Management Gateway in Power BI for...

Creating a Date Dimension with a Power Query Script

Creating a Date Dimension with a Power Query Script

Chris Webb has previously blogged a similar approach, but I thought I'd shared my own version of a Power Query function that generates a table of dates that could be used to create a Date Dimension. I first saw Faisal...

Generate an Empty Raw File Without Running your SSIS Package

Generate an Empty Raw File Without Running your SSIS Package

A new feature was added to the Raw File Destination in SQL Server 2012 which allows you to output an empty raw file from the editor UI. Add a Raw File Destination to your data flow, and connect...

Using Hive ODBC from SSIS

Using Hive ODBC from SSIS

Microsoft announced the general availability of Windows Azure HDInsight last week, and released an updated version of the Microsoft Hive ODBC Driver. This post describes how to use this driver to pull data from your HDInsight cluster with an SSIS Data Flow Task. Installing and Configuring the Hive ODBC Driver The download page for the Hive ODBC driver provides a link to an article on how to configure the Hive ODBC driver to connect to HDInsight using Excel. The screenshots in the...

Links from the SSIS Roadmap Session

Links from the SSIS Roadmap Session

Here are some of the resources I mentioned in the SSIS Roadmap session at the PASS Summit. SSIS Reporting Pack from Jamie Thomson   DQS Matching Transform from OH22 Data   DQS Domain Value Import Destination from OH22 Data There is also a great series of blog posts (part 1, part 2, part 3) on using these transforms on the DQS team blog. Data Feed Publishing Components ...

SSIS Content from PASS Summit 2013 on PASS TV

SSIS Content from PASS Summit 2013 on PASS TV

You can now stream sessions from the 2013 PASS Summit on-demand from the PASStv site. There's a lot of amazing content on there, including the Day 1 and Day 2 keynotes. If you're interested in SSIS (and if you're reading...

SQL Server Data Tools – Business Intelligence downloads

SQL Server Data Tools – Business Intelligence downloads

Looking for the SSIS development tools? Formerly known as Business Intelligence Developer Studio (BIDS), the designer is now called SQL Server Data Tools – Business Intelligence (SSDT-BI) (not to be confused with the other SQL Server Data Tools). The version...

Skylanders Power View Workbook

Skylanders Power View Workbook

...

BI Power Hour at PASS Summit 2013

BI Power Hour at PASS Summit 2013

A big thank you to the PASS Summit 2013 attendees who made our BI Power Hour a great success! I have to admit I was a little worried when we lost all power 15 minutes before the session started (highly...

SELECT * From SSIS.DataFlow

SELECT * From SSIS.DataFlow

If you've been looking through the documentation for the Power BI preview, you might have noticed a section on Publishing SSIS Packages as OData Feeds. This functionality lets you create a T-SQL View over an SSIS data flow using a new SSIS add-on called the Data Feed Publishing Components. This add-on works with SQL Server 2012, and is a free download from the Microsoft download center. While the components are useful for a number of Power BI scenarios, the components...

PASS Summit 2013

PASS Summit 2013

Wow, has it really been two months since my last blog post? I guess I’ve been busy! I’ve been hard at work on SSIS and some components for Power BI. I hope to blog about all of the fun projects I’ve been working on this past year, but in case I don’t get a chance, you can come hear me talk all about it at this years PASS Summit! Yes boys and girls, I’ve once again tricked the conference organizers into letting...

Filtering in Data Explorer

Filtering in Data Explorer

I was been manning the Data Discovery & Visualization and Data Warehousing booths at TechEd Europe last week, and we saw lots of excitement over Data Explorer. One of the questions I got was about how Data Explorer does its...

Server Execution Parameters with DTEXEC

Server Execution Parameters with DTEXEC

The SSIS team blogged about executing packages deployed to the SSIS Catalog using DTEXEC a while ago. The post mentions the $ServerOption::SYNCHRONIZED parameter as a way to control whether the execution is synchronous or asynchronous, but there are some other...

SQL Saturday Dublin – this weekend!

SQL Saturday Dublin – this weekend!

Less than a week to go before the next SQL Saturday Dublin event! I’ll be presenting a fun session at the main event (Cats, Facebook, and Online Dating with Microsoft BI), and doing a full day training session...

Quick Tip: How can I tell when my DQS knowledge base has been updated?

Quick Tip: How can I tell when my DQS knowledge base has been updated?

You can improve data quality in your SSIS data flows by using the DQS Cleansing transform (new in SQL 2012). When you’re using DQS, the data is cleansed according to the rules you’ve built up in the DQS knowledge base....

Bulk Loading into MDS using SSIS

Bulk Loading into MDS using SSIS

Each entity in SQL Server 2012 Master Data Services (MDS) will have it’s own staging table (stg.<name>_Leaf). Using this staging table, you can create, update, deactivate and delete left members in bulk. This post describes how to bulk load into an entity staging table and trigger the stored procedure to start the batch import process. Staging Tables and Stored Procedures The new entity based staging tables are an excellent feature in MDS 2012, and make it very...

Advanced SSIS Catalog presentation from TechEd North America 2013

Advanced SSIS Catalog presentation from TechEd North America 2013

Matthew Roche (blog | twitter) and I teamed up once again to present an advanced SSIS Catalog session at TechEd North America 2013 – Deep Inside the Microsoft SQL Server Integration Services Server. The video and slide deck are now available on the Channel9 site. The slide deck actually contains 10 additional slides that we didn’t have time to cover during the regular session (with some further details about the security model). I want to extend a big...

Presentations Galore!

Presentations Galore!

I’m mentally preparing myself for a whole slew of upcoming conferences / speaking engagements over the next month and a half. I love talking about SQL Server technologies, and I’m honored that I’ll have so many chances to do it...