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

AlwaysOn Availability Groups and SQL Server Jobs, Part 29: Practical Implementation Tips

My initial goal in writing this series of posts was to outline some of the concerns surrounding Availability Groups (AGs) and SQL Server Agent Jobs – and call out how there is virtually no guidance from Microsoft on this front and then detail some of the pitfalls and options available for tackling this problem domain. I initially expected this series of posts to have between 25 and 30 posts – according to some of the early outlines I created ‘way back when’....More
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
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) ×