Tyler Chessman

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).

Articles
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.
Getting the Most Out of Microsoft Power View
Microsoft SQL Server 2012 SP1 provides several Power View enhancements. Learn about six tips that can help you get the most of out of Power View.

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
Abstract illustration of linked SQL Servers
Nov 18, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 15: Setting Up Linked Servers

Learn about setting up Linked Server definitions to let two (or more) servers in an AlwaysOn Availability Group talk to each other and check up on job statuses of jobs running on each other....More
SQL Server Availability Groups screenshot
Nov 11, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 14: Establishing Synchronization Checks

When compared to AlwaysOn Failover Cluster Instances or clustered deployments of SQL Server, one of the main problems with AlwaysOn AGs is that a single database is made to straddle multiple hosts....More
Stretch SQL Server into Azure
Nov 5, 2014
blog

SQL PASS Summit 2014 Day One Keynote

Highlights from the PASS Summit 2014 day one keynote....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×