Downloads

Here are slide deck downloads and code downloads from different articles or community presentations. Many of these follow my standard "Baker's Dozen, 13 Tip" format. Feel free to use these in your work as you see fit.

Download	Description	Date
SQL 2016 In-Memory and Columnstore	SQL 2016 In-Memory Content	4/2/2019
Creating Power BI Content	Creating content with Power BI Desktop	3/16/2016
Advanced SSAS	13 tips for Intermediate/Advanced SSAS Development	3/11/2015
MDX Programming	A detailed slide deck with MDX Examples	3/11/2015
SSRS for Application Developers (Slide Deck and Demos)	Community presentation: SSRS for Application Developer Note: for the samples, run the script DatabaseScriptToStart.SQL in the zip file	1/14/2015
SSRS Data Driven Subscriptions	A detailed walkthrough on SSRS Data Driven Subscriptions	1/14/2015
13 tips for the Columnstore Index	13 tips for the SQL Server Columnstore Index (Slide Deck)	1/13/2015
13 tips for SQL Server 2014 In-Memory Optimized OLTP	13 tips for SQL Server 2014 In-Memory Optimized OLTP (Hekaton)	1/13/2015
Transact SQL for Developers	A community presentation (slides plus T-SQL demo code) for T-SQL features of interest to applications developers	11/21/2014
13 Tips: Data Warehousing Patterns with SQL BI Tools	13 Tips for Implementing the Kimball Data Warehouse Patterns for using the SQL/BI tools (updated 10/16/2017)	10/16/2017
13 Excel Tips for Developers	13 Excel Tips that database developers should know about.	11/13/2014
13 Steps: Introduction to Power BI for Office 365	An absolute beginner's presentation for using Power BI for Office 365 – 13 steps for getting started	10/27/2014
13 Tips: Integrating SSRS with SharePoint	13 tip for integrating SQL Server Reporting Services with SharePoint	7/26/2014
Tips for SQL Server Integration Services 2008	A community presentation (slides plus an SSIS 2008 example project) on using SQL Server 2008 Integration Services (Also the example project for the July/August 2010 issue of CoDe Magazine!)	06/22/2010
Building OLAP Cubes with SSAS 2008	A community presentation (slides only) for building OLAP cubes with SSAS 2008	05/03/2010
SSRS 2008R2 Reporting Gallery	A community presentation (slides and demo project) for reports in SSRS 2008 and SSRS2008R2)	07/21/2010
Change Data Capture in SQL Server 2008	A community presentation (slides, demo code, and SSIS project) for implementing Change Data Capture in SQL 2008	07/21/2010
PowerPivot and SharePoint Integration	A community presentation (slides) for an Introduction to PowerPivot and SharePoint Integration	8/1/2010
PerformancePoint Services 2010	A community presentation (slides) for PerformancePoint Services 2010	8/1/2010
Introduction to the MS BI Stack	My presentation at the NY BI User Group meeting on 9/13	9/13/2010