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.

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).

Silverlight Dashboards

Microsoft Silverlight provides advanced data visualization dashboards.

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.

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.

2009 is upon us, take the time to Reflect and Plan

SQL Server 2008 Change Data Capture

The new, asynchronous CDC feature built into the SQL Server 2008 relational database engine replaces the need to create custom CDC solutions and provides better performance.

Business Intelligence Explained for the DBA

Derek explains the basic solutions, components, and best practices used in deploying enterprise-class BI solutions for Database Administrators.

Change Data Capture w/o the SQL Server 2008 Relational Engine

SSAS 2005: Cube Performance Tuning Lessons Learned

A recent project has forced me (which is a good thing) to learn both the internals of SSAS 2005 as well as various performance tuning techniques to get maximum performance out of the OLAP server.

Upcoming Scalability Experts Events

Scalability Experts (my employer) is providing several high-value presentations in the coming months on a variety of hot SQL Server topics.

The Meaning of the Microsoft MVP Award

Having recently been awarded my first Microsoft MVP award I quickly realized the award's true representation.

Measure Twice, Cut Once: The Importance of a Solid Dimensional Model

One of the first steps in an enterprise-class DW/BI project is the modeling process. Ensuring you have a solid dimensional model completed prior to entering later tasks in the DW/BI lifecycle is key to success.

Use Data Warehousing to Make Better Business Decisions

Data warehousing and business intelligence (BI) systems have the potential to provide some of the highest ROI of any enterprise system. BI exists solely to support better decision-making.

Use Data Warehousing to Make Better Business Decisions

The Importance of Planning in BI

Business Intelligence projects are prone to the same bad, ad-hoc implementation practices as found in software development. Take the time to plan accordingly.