Below are some of the articles that I’ve had the honor of being an author, contributor, or reviewer.  Some of my presentations can be found on the Presentations page. Enjoy!


Learning PySpark Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX
Professional Microsoft PowerPivot for Excel and SharePoint Professional Microsoft SQL Server Analysis Services 2008 with MDX
Transforming Health Care Through Information: Case Studies Professional SQL Server 2000 Data Warehousing with Analysis Services

Apache Spark





Introduction to Databricks Introduction-to-Databricks Databricks Visualizations Visualizations-in-Databricks Cluster Manager and Jobs Databricks-Cluster-Manager-and-Jobs
Data Exploration Data-Exploration-on-Databricks Databricks Collaboration Collaborations-in-Databricks Healthcare Analytics

Hadoop on Azure / d3.js



Analysis Services

Integration Services

Reporting Services

SQL Server


  1. Please provide the link for PowerPivot Best Practices / Capacity Planning Guide

    1. We have yet to complete this guide – as soon as it is completed, I will definitely post it up. Sorry!

  2. Hey Denny,

    I have a question on how you handle SAN Snapshots and Load Balancing… My question is a little more technical in nature than the “Scale-Out Querying for Analysis Services with Read-Only Databases”. Can you please help?

    1. To handle SAN snapshots and load balancing, best to work with your Systems Engineer as each SAN vendor operates SAN differently. As for Load balancing, please reference the Analysis Services 2008 R2 Operations Guide.


  3. Phillip Labry

    Hi Denny,
    It looks like all your SQLCAT links are being redirected to this page


    1. Sorry for the delayed response, a lot of the original SQLCAT articles have been removed and not re-generated. I will eventually work on seeing if I can get some of the original articles posted on my site. If you have any requests – please ping me (or tweet me @dennylee) and I’ll see if I can find them. HTH!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s