What’s New in SQL Server 2017 for BI

Just when you thought you’re done upgrading to SQL Server 2016, SQL Server 2017 is on the horizon. SQL Server 2017 delivers exiting new features and enhancements. Discover what’s coming up in the three BI pillars in SQL Servers: SSIS, SSRS, and SSAS.

ADOMD Connection Pooling

A .NET class that demonstrates connection pooling for ADOMD connections.

Applied Microsoft SQL Server 2012 Analysis Services (Tabular Modeling)

The entire source code for the book “Applied Microsoft SQL Server 2012 Analysis Services (Tabular Modeling)” by Teo Lachev

Applied Microsoft SQL Server 2008 Reporting Services

The source code for Applied Microsoft SQL Server 2008 Reporting Services book by Teo Lachev

Applied Microsoft Analysis Services 2005

The source code for the book Applied Microsoft Analysis Services 2005 by Teo Lachev.

Microsoft Reporting Services in Action

The code accompanying the book Microsoft Reporting Services in Action.

Can Your Data Analytics Solution Scale?

Does your ETL exceed its processing window? Do your users complain about the SSRS spinny? Can your SQL Server database design deliver the expected performance? Can the system scale to thousands of users? Join this session to learn best practices and tips for isolating bottlenecks and improving the performance of data analytics solutions. I’ll dissect the layers of a “classic” solution (relational database, ETL, data model, reports) and share solutions harvested from real-life projects to address common performance-related issues.

Atlanta.MDF 2010 Presentation

The code and slides for my presentation What’s New in Reporting Services 2008 R2?

TechEd 2009 North America BIN304

Filed under: TechEd

The slides and code from my Reporting Services 2008 Tips, Tricks, Now and Beyond breakout presentation delivered on May 13th 2009.