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
May 18, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 24: Synchronizing SSIS Packages

In my previous post I covered options for adding “If-checks” into SSIS Packages – or SQL Server Maintenance Plans (which are, effectively, specialized SSIS packages). Once you’ve tackled that process, you’ll need to tackle something else when it comes to managing SSIS packages in conjunction with AlwaysOn Availability Groups. Or, more specifically, you’ll actually need to tackle two tasks....More
May 13, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 23: Maintenance Plan Backups and SSIS Packages

In my last post, we took a look at some of the details involved in actually implementing backups against databases being hosted in AlwaysOn Availability Groups. In addition to providing a high-level overview of how sys.fn_hadr_backup_is_preferred_replica() works, I also mentioned that integrating it into backups managed by SQL Server Maintenance Plans isn’t as easy as what you’ll run into with other types of backups....More
Apr 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 22: Executing Backups

Ultimately, there are a number of ways that DBAs can regularly create backups of their databases. Some of the more common options for managing backups include:...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) ×