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
How to Dramatically Decrease Data Warehouse Load Times with Memory-Optimized Tables 4

Introduction

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
Jul 6, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 28: Additional Options for Tackling Jobs Failover

Throughout this series of posts I’ve taken a somewhat pessimistic view of how SQL Server Agent jobs are managed within most organizations – meaning that most of the code and examples I’ve provided up until this point were based on assumptions about how CHANGE to jobs is managed. That pessimism, to date, has come in two forms:...More
Jul 1, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 27: Options and Concerns for More Advanced Deployments

In this series of posts I’ve called out some of the concerns related to SQL Server AlwaysOn Availability Groups and their interaction with SQL Server Agent jobs – both in the form of Batch Jobs (see post #3) and backups....More
Jun 10, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 26: Using Master Servers for Job Administration

When I initially decided to write about AlwaysOn Availability Groups and SQL Server Jobs, I knew I’d have a bunch of different posts on a variety of different topics. To that end, I initially planned on this series of posts being comprised of 3 main parts:...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) ×