SQL Server Magazine

		Options
Deliver BI with SSRS and SharePoint Make the improved information access and report administration from SSRS and MOSS integration work for you. Stacia Misner shows you how to make the combination work, walking you through the environment set up.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

Protect UDM with Dimension Data Security, Part 2

Two approaches let you use MDX expressions to easily secure UDM data: storing security policies in a factless fact table and leveraging SSAS stored procedures to integrate UDM with an external security service.
By Teo Lachev 

Sharpen Your Skills: Routines and Clauses

SQL Server often features several ways to do the same or similar tasks. To select the best technique for the job, you need to understand the differences.
By Pinalkumar Dave 

A Fresh Approach to SQL Server

We've redesigned SQL Server Magazine to sharpen our focus on content you want, such as business intelligence and SQL Server fundamentals, and to make it easier for you to read, interact with the community, and find related content on the Web.
By Karen Forster 

Row-Concatenation Solutions Aren't All Equal

A reader's tests reveal that although various row-concatenation solutions produce the same results, the time it takes to get those results can vary significantly.
By Readers 

Making the Most of Automatic Statistics Updating

Tune performance by using UPDATE STATISTICS and trace flags to improve the quality of index statistics by ensuring they’re regularly updated.
By Kalen Delaney 

Data Warehousing: Dimension Basics

As you plan and create your data warehouse, you'll need to decide the level of detail you want—how finely grained you want your dimensions to be—and you'll need to flatten hierarchies to make data more accessible for users.
By Michelle A. Poolet 

Grouping Sets, Part 1

In this early look at SQL Server 2008, you'll learn about the new version's implementation of grouping sets, which are useful for analyzing aggregated data.
By Itzik Ben-Gan 

New Products

Check out new and improved SQL Server–related products.
By Jeff James 

SQL Nexus

SQL Nexus is a powerful front-end visualization tool for detecting, analyzing, and troubleshooting problems on SQL Server 2005.
By Kevin Kline 

SoftTree Technologies SQL Assistant 2.5

Want to optimize your SQL coding sessions? SoftTree Technologies offers some helpful coding features with SQL Assistant 2.5.
By John Green 

Database Design Tools

The prerequisite for an efficient, high-performance database is a database design. Using one of these nine design tools will make you more productive and the resulting database more efficient.
By Karen Bemowski 

Information Integration: SSRS and MOSS 2007

SSRS and MOSS integration promises better information access and report administration, but what will you have to do to make it work? This first article of a two-part series shows you how to set up SSRS and MOSS's information-integration environment.
By Stacia Misner 

Getting to Know Wait Stats

SQL Server's built-in DMV functionality offers all kinds of management potential. This month, we show you how to monitor wait stats on your SQL Server instance.
By Andrew J. Kelly 

Too Soon for SQL Server 2008? Readers Say "Yes!"

Readers talk back to SQL Server Magazine authors, saying they're not ready for another upgrade so soon after the release SQL Server 2005.
By Anne Grubb 

4 Darn Good Reasons for Not Building Cubes on Transactional Systems

Don't build that cube! OLTP–based cubes are usually poorly designed for BI and contain dirty data. Still not convinced? There's more.
By Douglas McDowell 

Connecting SQL Server to the IBM System i

Connect your SQL Server system to the IBM System i and transfer data in a variety of ways, from BCP to linker servers and more, taking advantage of this relational database system that's widely used in ERP, manufacturing, and distribution.
By Michael Otey