February, 2010
Optimizing Time-Based Calculations in SSAS
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.
SQL Server Magazine
|
February, 2010
The Concepts Behind Time Calculations in SSAS
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 Magazine
|
October, 2009
SQL Server Reporting Services Questions Answered
Use these techniques and sample reports to get answers to your most frequently asked reporting questions.
SQL Server Magazine
|
November, 2008
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.
SQL Server Magazine
|
November, 2008
JavaScript Development
Learn about two solutions that make writing JavaScript easier
SQL Server Magazine
|
November, 2008
Using the MapPoint Web Service to Fix a Bug in AdventureWorks2008
See how a new application uses geocoding to fix some AdventureWorks2008 spatial values
SQL Server Magazine
|
September, 2008
SSIS Logging and Data Auditing
Use Business Intelligence Development Studio (BIDS) to customize package logging.
SQL Server Magazine
|
May, 2008
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.
SQL Server Magazine
|
May, 2008
Using Large CLR UDTs in SQL Server 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.
SQL Server Magazine
|
November, 2007
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 Magazine
|
November, 2007
Working with Estimated Query Execution Plans
If you want to be able to see the complexity and size of queries, consider implementing estimated execution plans in your organization.
SQL Server Magazine
|
April, 2007
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.
SQL Server Magazine
|
March, 2007
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.
SQL Server Magazine
|
November, 2006
Using Reporting Services in an Internet/Extranet Environment
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.
SQL Server Magazine
|
November, 2006
What About Web Services?
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.
SQL Server Magazine
|
May, 2006
Creating Report Models
Learn different ways to build a report model.
SQL Server Magazine
|
May, 2006
No-Nonsense Reporting Tool
Check out Report Builder, a new and easy-to-learn ad hoc reporting tool in SQL Server 2005 Reporting Services.
SQL Server Magazine
|
April, 2006
Refining a Report Model
The Visual Studio 2005 report wizards are great for creating simple reports. But read on if you want to learn more about refining your report model.
SQL Server Magazine
|
February, 2006
Zip Your Data
Add compression capabilities to SQL Server 2005 by leveraging the Common Language Runtime (CLR) and taking advantage of the new varbinary(max) data type.
SQL Server Magazine
|
February, 2006
Compression Basics
If you're embarking on a solution for compressing data, you'll find this compression overview helpful.
SQL Server Magazine
|