Tyler Chessman


Tyler Chessman is a technology specialist for Microsoft, helping customers evaluate and adopt Microsoft's business intelligence (BI) platform. He's the author of the book Understanding the United States Debt (CreateSpace).

How to Dramatically Decrease Data Warehouse Load Times with Memory-Optimized Tables 6


Recently, I needed to optimize a nightly batch process for a SQL Server data warehouse that involved loading over 250,000 flat files.  With a bit of experimentation and research, I was able to decrease the overall load time from 14 hours to under 15 minutes.  To do so, I used:

  • something old - the T-SQL BULK INSERT command,

  • something new - Memory-Optimized tables in SQL Server 2014, and

HDInsight Create a New Cluster screenshot
Integrating Hadoop with SQL Server
Get a real-world example of how to combine the strengths of Hadoop with SQL Server to make a data professional's job easier and more efficient.
green apple
Hadoop Basics
At a high-level, Hadoop has two key components made up of Hadoop Distributed File System (HDFS) and Map Reduce.
Loading QWI Data from the U.S. Census Bureau into Hadoop
Step-by-step instructions on how to download U.S. Census Burearu Quarterly Workforce Indicator data files into a Hadoop cluster.
bar graph showing improvement
Improving Hive Performance
Similar to SQL Server, Hive has a number of performance-related features.
Session 1: Understanding the Power BI Components 

Running Time: 88 minutes |

Walking through an end-to-end example, you'll learn how Power BI starts in Excel (Power Query, PowerPivot, Power View, and Power Map) and extends to Office 365 to allow organization to share and collaborate BI solutions.

Session 2: Power BI for Office 365 Administration 

Running Time: 79 minutes |

We'll install and configure Office 365 on the desktop, then setup and configure a new Power BI for Office 365 tenant. This session will also cover the Power BI for Office 365 licensing and site provisioning requirements.

Session 3: Data Integration 

Running Time: 80 minutes |

Power BI for Office 365 can tap into both cloud and on premise data sources. We'll walk through the setup and configuration of the Data Management Gateway (used for on premise connectivity), review the role of the data steward, and discuss future integration capabilities.

Oracle 12c
Connecting to an Oracle Database from SQL Server and Microsoft BI Tools
Learn how to connect to an Oracle database from SQL Server and Microsoft business intelligence (BI) tools.
Oracle logo
Installing an Oracle Database for Testing Purposes
If you don't have an Oracle database to use for testing purposes,consider a pre-built developer virtual machine (VM) that's already installed and configured.
Oracle database 12c
Oracle Data Provider for .NET (ODP.NET)
For pure .NET application development, there's a new provider from Oracle that you might want to consider: Oracle Data Provider for .NET (ODP.NET).
Introducing Microsoft Power Map
Microsoft's latest self-service business intelligence tool helps users visualize geographic information using 2D and 3D maps.
word cloud with BUSINESS INTELLIGENCE in center
Introducing Microsoft Power Query
With Power Query, end users can easily gather, refine, and combine data from both public and private data sources.
Understanding Time Series Forecasting Concepts 1
With an understanding of the key concepts in time series forecasting and exposure to some of the underlying details, you'll be in a better position to start using the forecasting capabilities in SQL Server Analysis Services (SSAS).
Understanding PowerPivot and Power View in Microsoft Excel 2013 2
Microsoft Excel 2013 is a big step forward with respect to business intelligence. The native integration of PowerPivot and Power View provides a whole new level of scalability and functionality.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.


From the Blogs
Sep 15, 2016

Power BI Desktop “Publish to Pyramid Server” Button

Many organizations today cannot use public cloud solutions because of security concerns, administrative challenges and functional limitations. However, they still need a centralized platform where end users can conduct self-service analytics in an IT-enabled environment....More
Jul 6, 2016

Using BI Office Together with Microsoft Power BI Desktop to Unlock Business Insights

It is crucial to move away from data and analytics stored on individual desktop computers. Today’s solutions must promote holistic, collective intelligence. The strong, continued alliance between Microsoft and Pyramid Analytics helps make all this possible....More
Jul 6, 2016

Why It’s Important to Unlock Business Insights Trapped on Individual Desktops

To become a truly data-driven enterprise, many business leaders recognize that they must extend the capabilities of self-service business intelligence (BI) and analytics to more of their business users. Many BI tools tackle part of this need, but they don’t offer a complete enterprise solution....More

Sponsored Introduction Continue on to (or wait seconds) ×