http://www.sqlmag.com/authors/author/author/5035194/rss/5035194en-USFri, 25 May 2012 10:26:59 GMTFri, 25 May 2012 10:26:59 GMThttp://www.sqlmag.com/article/sql-server/introducing-microsoft-power-view-142663
By Tyler Chessman
Power View is an easy-to-use business intelligence (BI) tool that helps people make sense of their data.]]>Tyler ChessmanTue, 22 May 2012 15:17:00 GMThttp://www.sqlmag.com/article/sql-server/introducing-microsoft-power-view-142663http://www.sqlmag.com/article/project-plan-busintelligence-sql-server-2008-r2-82/sharepoint/PowerPivot for SharePoint-135866
By Tyler Chessman
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.]]>Tyler ChessmanTue, 21 Jun 2011 16:34:00 GMThttp://www.sqlmag.com/article/project-plan-busintelligence-sql-server-2008-r2-82/sharepoint/PowerPivot for SharePoint-135866http://www.sqlmag.com/article/project-plan-analysis-sql-server-2008-r2-87/backup-recovery/backup-basics-for-sql-server-analysis-services
By Tyler Chessman
As your SSAS databases become increasingly important, they should also become part of your backup strategy. Here’s how to preserve this crucial data.]]>Tyler ChessmanThu, 17 Mar 2011 07:29:00 GMThttp://www.sqlmag.com/article/project-plan-analysis-sql-server-2008-r2-87/backup-recovery/backup-basics-for-sql-server-analysis-serviceshttp://www.sqlmag.com/article/project-plan-powerpivot-sql-server-2008-r2-84/powerpivotexcel/walkthrough-of-powerpivot-for-excel-2010
By Tyler Chessman
Learn how to use the key capabilities of PowerPivot for Excel to load, model, and analyze data in Excel without assistance from IT.]]>Tyler ChessmanMon, 23 Aug 2010 16:28:00 GMThttp://www.sqlmag.com/article/project-plan-powerpivot-sql-server-2008-r2-84/powerpivotexcel/walkthrough-of-powerpivot-for-excel-2010http://www.sqlmag.com/article/sql-server-analysis-services/optimizing-time-based-calculations-in-ssas-
By Tyler Chessman
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.]]>Tyler ChessmanTue, 16 Feb 2010 00:00:00 GMThttp://www.sqlmag.com/article/sql-server-analysis-services/optimizing-time-based-calculations-in-ssas-http://www.sqlmag.com/article/sql-server-analysis-services/the-concepts-behind-time-calculations-in-ssas
By Tyler Chessman
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.]]>Tyler ChessmanTue, 16 Feb 2010 00:00:00 GMThttp://www.sqlmag.com/article/sql-server-analysis-services/the-concepts-behind-time-calculations-in-ssashttp://www.sqlmag.com/article/reporting2/sql-server-reporting-services-questions-answered
By Tyler Chessman
Use these techniques and sample reports to get answers to your most frequently asked reporting questions.]]>Tyler ChessmanTue, 20 Oct 2009 00:00:00 GMThttp://www.sqlmag.com/article/reporting2/sql-server-reporting-services-questions-answeredhttp://www.sqlmag.com/article/project-plan-powerpivot-sql-server-2008-r2-84/data-types/integrating-sql-server-2008-spatial-capabilities-with-microsoft-virtual-earth-100528
By Tyler Chessman
See how to put the SQL Server 2008 GEOGRAPHY and GEOMETRY data types to work in your applications.]]>Tyler ChessmanMon, 24 Nov 2008 00:00:00 GMThttp://www.sqlmag.com/article/project-plan-powerpivot-sql-server-2008-r2-84/data-types/integrating-sql-server-2008-spatial-capabilities-with-microsoft-virtual-earth-100528http://www.sqlmag.com/article/java/javascript-development
By Tyler Chessman
Learn about two solutions that make writing JavaScript easier]]>Tyler ChessmanMon, 24 Nov 2008 00:00:00 GMThttp://www.sqlmag.com/article/java/javascript-developmenthttp://www.sqlmag.com/article/net-framework2/using-the-mappoint-web-service-to-fix-a-bug-in-adventureworks2008
By Tyler Chessman
See how a new application uses geocoding to fix some AdventureWorks2008 spatial values]]>Tyler ChessmanMon, 24 Nov 2008 00:00:00 GMThttp://www.sqlmag.com/article/net-framework2/using-the-mappoint-web-service-to-fix-a-bug-in-adventureworks2008http://www.sqlmag.com/article/business-intelligence-development-studio-bids/ssis-logging-and-data-auditing
By Tyler Chessman
Use Business Intelligence Development Studio (BIDS) to customize package logging.]]>Tyler ChessmanMon, 29 Sep 2008 00:00:00 GMThttp://www.sqlmag.com/article/business-intelligence-development-studio-bids/ssis-logging-and-data-auditinghttp://www.sqlmag.com/article/common-language-runtime-clr/clr-udt-caveats
By Tyler Chessman
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.]]>Tyler ChessmanWed, 28 May 2008 00:00:00 GMThttp://www.sqlmag.com/article/common-language-runtime-clr/clr-udt-caveatshttp://www.sqlmag.com/article/common-language-runtime-clr/using-large-clr-udts-in-sql-server-2008
By Tyler Chessman
See how the VarBinaryComp UDT takes advantage of new support for large types to store,compress, and decompress up to 2GB of binary data.]]>Tyler ChessmanWed, 28 May 2008 00:00:00 GMThttp://www.sqlmag.com/article/common-language-runtime-clr/using-large-clr-udts-in-sql-server-2008http://www.sqlmag.com/article/database-development/creating-a-custom-data-processing-extension
By Tyler Chessman
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.]]>Tyler ChessmanWed, 05 Mar 2008 00:00:00 GMThttp://www.sqlmag.com/article/database-development/creating-a-custom-data-processing-extensionhttp://www.sqlmag.com/article/quering/working-with-estimated-query-execution-plans
By Tyler Chessman
If you want to be able to see the complexity and size of queries, consider implementing estimated execution plans in your organization.]]>Tyler ChessmanTue, 20 Nov 2007 00:00:00 GMThttp://www.sqlmag.com/article/quering/working-with-estimated-query-execution-planshttp://www.sqlmag.com/article/quering/estimated-execution-plans-shortcomings
By Tyler Chessman
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.]]>Tyler ChessmanTue, 20 Nov 2007 00:00:00 GMThttp://www.sqlmag.com/article/quering/estimated-execution-plans-shortcomingshttp://www.sqlmag.com/article/data-modeling/sql-server-2005-data-mining-add-ins-for-office-2007
By Tyler Chessman
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. ]]>Tyler ChessmanThu, 19 Apr 2007 00:00:00 GMThttp://www.sqlmag.com/article/data-modeling/sql-server-2005-data-mining-add-ins-for-office-2007http://www.sqlmag.com/article/sql-server-analysis-services/excel-2007-s-powerful-pivottables
By Tyler Chessman
Microsoft Excel 2007 PivotTables give you more ways than ever to analyze and present data from SQL Server Analysis Services 2005 OLAP cubes.]]>Tyler ChessmanThu, 22 Mar 2007 00:00:00 GMThttp://www.sqlmag.com/article/sql-server-analysis-services/excel-2007-s-powerful-pivottableshttp://www.sqlmag.com/article/internet/using-reporting-services-in-an-internet-extranet-environment
By Tyler Chessman
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 how to set up custom authentication and filtering for Web-based reporting.]]>Tyler ChessmanMon, 20 Nov 2006 00:00:00 GMThttp://www.sqlmag.com/article/internet/using-reporting-services-in-an-internet-extranet-environmenthttp://www.sqlmag.com/article/reporting2/what-about-web-services-
By Tyler Chessman
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 the pros and cons of this solution.]]>Tyler ChessmanMon, 20 Nov 2006 00:00:00 GMThttp://www.sqlmag.com/article/reporting2/what-about-web-services-