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
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.
CLR UDT Caveats
CLR UDTs aren't intended to turn SQL Server into a full-blown object-oriented database. Learn about the proper place of CLR UDTs and methods for overcoming common objections to using them.
Using Large CLR UDTs in SQL Server 2008 1
See how the VarBinaryComp UDT takes advantage of new support for large types to store,compress, and decompress up to 2GB of binary data.
Creating a Custom Data-Processing Extension 5
Learn how to create a data-processing extension that will wrap around the default SSRS data-process extension to prevent complex queries or queries with large estimated result sets from running.
Working with Estimated Query Execution Plans 1
If you want to be able to see the complexity and size of queries, consider implementing estimated execution plans in your organization.
Estimated Execution Plans' Shortcomings
Estimated execution plans are very useful when trying to see how complex and large a query is. However, these plans aren't always generated. Find out why estimated execution plans aren't generated in certain situations.
SQL Server 2005 Data Mining Add-ins for Office 2007
Data Mining Add-ins for Office 2007 help you develop business intelligence by using the power of SQL Server 2005 and Microsoft Office Excel 2007 to analyze your organization's data.
Excel 2007's Powerful PivotTables
Microsoft Excel 2007 PivotTables give you more ways than ever to analyze and present data from SQL Server Analysis Services 2005 OLAP cubes.
Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Health check note on computer keyboard
Jul 28, 2014
Sponsored

Grasp the Business Value of a Complete SQL Server Health Check

A comprehensive SQL Server health check will provide you with a better understanding of your complex database environment, and delivers answers you need....More
Baby duck swimming alone
Jul 15, 2014
blog

The Marginalization of SQL Server Standard Edition 5

Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....More
Jul 8, 2014
blog

Replication: Sometimes More is Less

The unconventionality of having two publications for complex, unruly databases typically ends up saving huge amounts of time over the long haul and makes replication much easier to manage....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) ×