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.
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.
How to Manually Enable the Collection of SharePoint Usage Data
To monitor PowerPivot for SharePoint, PerformancePoint Services, and Excel Services, you need to enable SharePoint's collection of usage data. If this functionality isn't already enabled, here's how you can manually enable it.
Monitoring SQL Server and SharePoint BI Components 1
Get a better understanding of how to monitor the performance and usage of the business intelligence (BI) components available through SQL Server 2012 and SharePoint 2010.
Delivering BI through SQL Server and SharePoint
Find out how the technologies in SQL Server and SharePoint can work together to deliver business intelligence in organizations.

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
business people around a table and laptop
Oct 9, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 10: Dynamic Detection Gotcha #3

You can interject a SQL Server Job Step into your Jobs and have this new/injected Job Step do some checking for you. Here's a look at everything that’s involved in such an approach....More
Man holding a piece of paper with the word GOTCHA
Oct 7, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 9: Dynamic Detection Gotcha #2 3

Given that a USE statement is parsed before code is actually run, there are a few options that could be used as a around when it comes to detecting whether or not code should be run....More
iceberg
Oct 2, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 8: Dynamic Detection Gotcha #1 1

Learn about why the option of dynamically detecting whether or not to run a SQL Server Job at execution time is quite a bit more problematic than you might think....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) ×