If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
You need a JavaScript-enabled browser to view this Publication
Please follow these steps to view the Publication:
Enable JavaScript in your browser
Refresh this page
Best regards
Zmags
Comparative Review:
Sizing Up Data Modeling Software p. 37
A PENTON PUBLICATION
>Denny Cherry
Configuring
Cfii
SQL Server
Service Broker
Service Broker
p.21
January 2011
The Smart Guide to Building World-Class Applications
SQL Server
Performance
Tuning Tips
p.10
Techniques for
Pivoting Data p. 15
>SSIS Novices' Guide:
Moving Data into the
Data Warehouse p. 25
Investigating Partitio
Query Performance p.
ning
32Comparative Review:
January 201 I
The Smart Guide to Building World-Class Applications
J.
>Denny Cherry
Configuring
SQL Server
Service Broker
i??
SQL Server
Performance
Techniques for
Pivoting Data p. 15
>SSIS Novices' Guide:
Moving Data into the
Data
Comparative Review: Sizing Up Data Modeling Softw
Smarter technology for a Smarter Planet: What da
WWW.SQLMAG.COM Contents
I ??? I I ??? Turn Up the Heat on SQL Se
Contents
EDITORIAL Michael Otey (motey@sql
marter technology for a Smarter ???*?????? What
How Many Indexes Should I Create? Y ou'v
SQL SERVER QUESTIONS ANSWERED being the clusteri
The Conversation Begins Here mobile connections
COVER STORY Top 10 SQL Server Performance Tuning
COVER STORY Tune your SQL Server environment f
COVER STORY PERFORMANCE TUNING TIPS often resu
COVER STORY PERFORMANCE TUNING TIPS server and
Pivoting Data Identify pivoting elements and put
FEATURE PIVOTING DATA shipperid shipcity
PIVOTING DATA F E EATUR
F ATURE E PV I OTING DATA
PIVOTING DATA F E EATUR $/
FEATURE ! ) -
PIVOTING DATA F E EATUR !
FEATURE - + - )- -
PIVOTING DATA F E EATUR
FEATURE PIVOTING DATA !#!# $#$ !* #
FROM Sales.Orders WHERE shipcountry = N'Spain' GR
FEATURE PIVOTING DATA to least recent, you can
FROM Sales.Orders WHERE shipcountry = N'Spain' )
FEATURE PIVOTING DATA LISTING 1: Dynamic Pivot
FEATURE Configuring SQL Server Service Broker
FEATURE CONFIGURING SERVICE BROKER LISTING 1: C
CONFIGURING SERVICE BROKER FEATURE the compute
FEATURE CONFIGURING SERVICE BROKER LISTING 5: Co
FEATURE SSIS Novices' Guide to Data Warehouses
FEATURE DATA WAREHOUSING Step 1: Add the Databas
it much in the long term. It provides an easy-to-
FEATURE DATA WAREHOUSING automated project setup
tab. Execute the task again and watch it turn gre
"Those who can envision a plausible future that'
s I MONITOR??? .SQL Monitor is the future of SQ
FEATURE Investigating Partitioning Query Perfo
PARTITIONING QUERY PERFORMANCE FEATURE pre–SQL
FEATURE PARTITIONING QUERY PERFORMANCE
PARTITIONING QUERY PERFORMANCE FEATURE that th
FEATURE PARTITIONING QUERY PERFORMANCE Fi
Sizing Up Data Modeling Software The best fit dep
COMPARATIVE DATA MODELING SOFTWARE TABLE 1: Exc
Color-coding of the keys is another feature
COMPARATIVE DATA MODELING SOFTWARE DATABASE
standard, re-useable attributes similar to user-d
COMPARATIVE DATA MODELING SOFTWARE · t
vice versa. Reports are saved with the model, aft
SQLServer [CONNECTIONS) March 27-30, 2011 JOIN
2010 Best of Connections Awards P enton Media's
Performance monitoring and tuning doesn't have
BUSINESS INTELLIGENCE ActiveAnalysis 2 Enhances B
The ACKPage B 4 SQL Azure Enhancements Mi
WHAT AREN'T YOU SEEING? SQL SENTRY CAN IDENTIFY
THIS DOCTOR MAKES HOUSE CALLS! SQL $ ?? ctor