SQL Server Magazine

BI and Web Site News, and a Tool Time “Thank You”

SQL Server Magazine launches a new business intelligence (BI) e-newsletter, a reader gets help from Tool Time, and we respond to reader feedback about Sqlmag.com and the price of a SQL Mag subscription.

Data Warehousing: Junk Dimensions

Find out how you can keep your data warehouse design simple by placing miscellaneous attributes into junk dimensions.

New Products

Check out new and improved SQL Server-related products from LogRhythm, Embarcadero, Vertica, and Markus Gruber.

SQL Server 2008 Business Intelligence Enhancements

Business Intelligence (BI) enhancements to SQL Server 2008 Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS) improve performance and make reporting easier.

Dundas and SSRS 2008: a New Visualization Platform

Panorama Provides BI Functionality in Google Docs

We recently met with Panorama to discuss its partnership with Google and latest product offerings.

SQL Server 2008's Report Designer Preview

This week, Derek discusses the Report Designer Preview feature that will be included with SQL Server 2008.

SQL Server 2008's Report Designer Preview

Readers and Authors Swap Ideas

A reader asks Douglas McDowell a question about his PerformancePoint Server Eye on BI article, forum members debate SQL Server trace methods, and Rodney Landrum updates his repository solution, in direct response to readers' feedback.

Master Data Management Challenges

Microsoft is rebuilding Stratature's MDM solution for release later this year, so it's smart to start talking about MDM now.

Data Warehousing: Slowly Changing Dimensions

When dealing with slowly changing dimensions, you can respond in three different ways. Find out what these responses to change are, and under what circumstances each response type should be used.

My PerformancePoint Server Wish List

Microsoft Office PerformancePoint Server 2007 can enhance your BI and BPM capabilities. But the product could be even better—here's a wish list for new features and for how to integrate the various components of PPS in future releases.

New Products

Check out new and improved SQL Server–related products from GridApp Systems, O'Reilly Media, SqlLabs, Tableau Software, and xSQL Software.

Are SSIS Experts More Aligned with OLAP than OLTP?

This week, Brian explores whether SSIS experts have an affinity for BI.

Data Warehousing: Dimensional Role-Playing

Dimensional roles can play many different parts in an accumulating snapshot fact table. Find out how dimensional role-playing can benefit your star schema.

Getting MDX to Work in Reporting Services

Annoyed by the fact that SSRS restricts the structure of the MDX queries you’re allowed to write? We've got a workaround or two that can help.

SQL Server Trends in 2008

Learn which Microsoft and third-party products will have the tools you need to stay on top of SQL Server development, administration, and business intelligence (BI) challenges in the coming year.

What's Next for the BI Market?

SAP scooped up Business Objects, Oracle purchased Hyperion Solutions, and IBM just gobbled up Cognos. Microsoft is touting PerformancePoint Server 2007 and their acquisition of visualization technology from Dundas for SQL Server 2008. What's Next for BI?

IBM Acquires Cognos, the Last Major Standalone BI Vendor

With IBM's acquisition of Cognos, most of the big BI vendors are now owned by Microsoft, Oracle, SAP, and IBM.

A Total BI Solution from Dell and Microsoft