SQL Server Magazine

Getting the most from BI in a Tough Economy

Join me on July 23rd and learn how to quickly deliver actionable information to your company's leaders.

Lessons Learned from Poor Data Warehouse Design

Here are the business and design factors that you need to consider and address when designing your data warehouse.

Azure: Data Mining in the Cloud

SQL Server data mining goes into the clouds

Access Analysis Services Cubes with WCF

A recent project I’ve been working on involves powering advanced Silverlight 2 interfaces with data coming from Analysis Services cubes via Windows Communication Foundation (WCF).

How to Determine the Average Number of Days Between Orders or Other Important Events

Using a looping algorithm to determine the average number of days between orders can be painfully slow code to write and run. A better approach is to use the ROW_NUMBER function.

Standardize Your SSIS Package Deployments

BI xPress,now available from Pragmatic Works, integrates with Business Intelligence Development Studio (BIDS) and Visual Studio to standardize your SQL Server Integration Services (SSIS) package deployments without manual coding.

Privacy, Surveillance, and the Persistence of Data

Jeff Jonas, a Las Vegas resident, data expert, and popular conference speaker, tells how he uses his insights into data to shine a spotlight on the bad guys—be they casino scammers or international terrorists.

Silverlight Dashboards

Microsoft Silverlight provides advanced data visualization dashboards.

Integrating SharePoint Data with SQL Server

SharePoint can become an isolated data island--unless you use SQL Server Integration Services to integrate that data into SQL Server databases.

European BI Market Trends Shifting

Check out Seamus Quinn's article about how the European BI market is shifting from third-party BI solutions to SQL Server's native BI tools.

Understanding the Fast Track Data Warehouse Reference Architectures

Brian provides information about Microsoft's SQL Server Fast Track Data Warehouse and points you to resources that you can use to learn more about this product's reference architecture.

MCM & MCA Programs...Great if you’re not in BI

A plee to Microsoft to create MCM & MCA BI Programs

Tomorrow's Microsoft BI Platform

A Current Forecast of the Next Generation Microsoft Business Intelligence Platform

BI in a Tough Economy

Take the time to revaluate if your organization can leverage their existing software & hardware assets to further strengthen its overall health in such turbulent times with Microsoft Business Intelligence.

CA ERwin Data Modeling Suite Now Includes CA ERwin Data Profiler and Crystal Reports

CA ERwin Data Modeling Suite now includes CA ERwin Data Profiler 3.2, CA ERwin Data Modeler 7.3, and CA ERwin Data Modeler Community Edition.

Game Changing Announcement for Microsoft BI

Business Intelligence Demand Counter-Cyclical

PerformancePoint 2007 Standalone + Vista = Permission Issues

A quick troubleshoot of handling PerformancePoint Application Pool permissions for standalone Vista development.

Upcoming PASS User Group Presentations

My colleague Barry Ralston from ComFrame Software (www.comframe.com ) and I are giving a series of local user group presentations starting with these two events.

Extending Integration Services Capabilities with Premier 3rd Party Products

Two 3rd Party SSIS vendors that have delivered substantial additional value.