By Tyler Chessman, 06/21/2011
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 ...
By Tyler Chessman, 03/17/2011
As your SSAS databases become increasingly important, they should also become part of your backup strategy. Here’s how to preserve this crucial data.
By Tyler Chessman, 08/23/2010
Learn how to use the key capabilities of PowerPivot for Excel to load, model, and analyze data in Excel without assistance from IT.
By Tyler Chessman, 02/16/2010
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 ...
By Tyler Chessman, 02/16/2010
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 ...
By Tyler Chessman, 10/20/2009
Use these techniques and sample reports to get answers to your most frequently asked reporting questions.
By Tyler Chessman, 11/24/2008
See how to put the SQL Server 2008 GEOGRAPHY and GEOMETRY data types to work in your applications.
By Tyler Chessman, 11/24/2008
Learn about two solutions that make writing JavaScript easier
By Tyler Chessman, 11/24/2008
See how a new application uses geocoding to fix some AdventureWorks2008 spatial values
By Tyler Chessman, 09/29/2008
Use Business Intelligence Development Studio (BIDS) to customize package logging.
By Tyler Chessman, 05/28/2008
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 ...
By Tyler Chessman, 05/28/2008
See how the VarBinaryComp UDT takes advantage of new support for large types to store,compress, and decompress up to 2GB of binary data.
By Tyler Chessman, 03/05/2008
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 ...
By Tyler Chessman, 11/20/2007
If you want to be able to see the complexity and size of queries, consider implementing estimated execution plans in your organization.
By Tyler Chessman, 11/20/2007
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 ...
By Tyler Chessman, 04/19/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 ...
By Tyler Chessman, 03/22/2007
Microsoft Excel 2007 PivotTables give you more ways than ever to analyze and present data from SQL Server Analysis Services 2005 OLAP cubes.
By Tyler Chessman, 11/20/2006
How can you use SQL Server 2005 Reporting Services to deploy reports when Windows Authentication isn’t available—and without the risk of one partner seeing another’s data? Here’s ...
By Tyler Chessman, 11/20/2006
Are you wondering about alternatives for providing reports in a non-Windows–authenticated environment? One effective approach is the use of the Report Server Web service. Here are ...
By Tyler Chessman, 05/23/2006
Check out Report Builder, a new and easy-to-learn ad hoc reporting tool in SQL Server 2005 Reporting Services.