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 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.
SSIS Logging and Data Auditing
Use Business Intelligence Development Studio (BIDS) to customize package logging.

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
Feb 25, 2015
Commentary

Data Profiling to the Rescue by Pushing Metadata Boundaries 1

Don’t let bad data sneak up on you when and where you least expect it. Ferret out bad data with Melissa Data’s newest Profiling Component for SSIS. Learn how to take control of your data using knowledge-base-driven metadata. The truth shall set you free!...More
Feb 16, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 18: Health Checks for Availability Groups 1

Now that we’ve outlined the process to let servers in a SQL Server AlwaysOn Availability Group "talk to each other" by means of setting up linked servers, it’s possible to set up some additional or improved checks on Availability Group Health....More
Feb 11, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 17: Creating Jobs to Check on Synchronization

In my previous post, I provided a high-level outline of the core logic (and rationale behind that logic) that would be needed to set up regular synchronization checks on SQL Server Agent Jobs for servers where AlwaysOn Availability Groups have been deployed. In this post, I’ll walk through the steps--and the code--needed to setup those checks....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) ×