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
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.
What's New in Microsoft SQL Server 2012 PowerPivot
Learn about the key new capabilities in the PowerPivot for Excel 2010 add-in and some related enhancements in PowerPivot for SharePoint.
Introducing Microsoft Power View 1
Power View is an easy-to-use business intelligence (BI) tool that helps people make sense of their data.
Introducing PowerPivot for SharePoint
Traditionally, the business intelligence (BI) process has been heavily dependent on IT’s involvement. PowerPivot breaks with tradition by giving end users the tools they need to own some or all of the process.
Backup Basics for SQL Server Analysis Services 1
As your SSAS databases become increasingly important, they should also become part of your backup strategy. Here’s how to preserve this crucial data.
A Walkthrough of PowerPivot for Excel 2010
Learn how to use the key capabilities of PowerPivot for Excel to load, model, and analyze data in Excel without assistance from IT.
Optimizing Time-Based Calculations in SSAS 2
Although several approaches to time-based calculations for SSAS already exist, they have shortcomings. Here's a novel approach that overcomes the shortcomings and provides end users with calculations that are flexible, easy to use, and efficient.
The Concepts Behind Time Calculations in SSAS 1
The built-in MDX functions such as PrevMember and ParallelPeriod might seem in of themselves sufficient for integrating time-based calculations in cubes, but there are shortcomings you need to know about.
SQL Server Reporting Services Questions Answered 6
Use these techniques and sample reports to get answers to your most frequently asked reporting questions.
Using the MapPoint Web Service to Fix a Bug in AdventureWorks2008
See how a new application uses geocoding to fix some AdventureWorks2008 spatial values
JavaScript Development
Learn about two solutions that make writing JavaScript easier
Integrating SQL Server 2008 Spatial Capabilities with Microsoft Virtual Earth 1
See how to put the SQL Server 2008 GEOGRAPHY and GEOMETRY data types to work in your applications.

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 22, 2017
Sponsored

Chief Data Officer Playbook: How to Be Successful in This Ground-Breaking Role

Companies looking to grow and extract value from their data are increasingly turning to Chief Data Officers (CDOs) to execute their data strategy. The role is new, and a playbook is necessary to address the many challenges CDOs face....More
May 12, 2017
blog

5 Common Challenges to Building BI in the Cloud

After spending 20 years building analytics, BI and database solutions, I've focused on Cloud data solutions over the past 2 years. I've chosen 5 common challenges that I face every day with Cloud migrations and that you'll face in your Cloud BI projects....More
Sep 15, 2016
Sponsored

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

Sponsored Introduction Continue on to (or wait seconds) ×