Excel is a wonderful tool for examining the data in your SSAS cubes. MVP Brian Knight shows how you can access the data in Analysis Services or a SQL Server database from Excel 2007.

Calculating Mathematical Values in SQL Server

by Additional Articles

MSSQLTips.com

T-SQL

In our application we have the need to perform mathematical calculations. Right now we are doing so in our front end application. Unfortunately we are starting to experience performance problems with large data sets and differences in calculations due to developers using different logic. We are seeking some other options to perform the calculations. Does SQL Server perform basic mathematical calculations?

SQL Server 2005 Express Edition - Part 27 - Implementing Basic Service Broker Objects

by Additional Articles

Database Journal

SQL Server Express

Marcin Policht explains the interaction of the primary elements of Service Broker's asynchronous messaging framework and describes a process of setting up the database objects necessary to demonstrate their sample implementation (which will be the subject of our next article).

The Active DBA

by Steve Jones

SQLServerCentral.com

Editorial - MP3

This Friday Steve Jones asks a poll about what you do to avoid being too sedentary.

Share Database Knowledge with Office and SQL Server

by Bill Wunder

SQLServerCentral.com

Full-Text Search

Longtime SQL Server expert Bill Wunder has written a very interesting article on how to share knowledge among IT staff using the tools you already have in your organization.