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
Man deciding which door to choose
Aug 15, 2014
Sponsored

Choosing the Right Health Check

For some businesses, conducting a health check can be cumbersome, time-consuming, and the results, well, frustrating. However, a health check can be easy and rewarding for any business that wants to improve server performance, especially if you take the time to find the right solution provider....More
SQL Server Management Studip Options screenshot
Aug 5, 2014
blog

SQL Server Management Studio’s Ugly ANSI_PADDING Bug

Learn more about the problem with SQL Server Management Studio's generation of scripts with ANSI_PADDING OFF along with a helpful solution....More
Save money red computer keyboard key
Jul 30, 2014
blog

When More Expensive Processors Actually Cost Less

Smart organizations are always looking for ways to cut costs when it comes to licensing SQL Server. Here are two ideas, or options, to save money....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) ×