If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> Comparative Review:<br /> Sizing Up Data Modeling Software p. 37<br /> A PENTON PUBLICATION<br /> >Denny Cherry<br /> Configuring<br /> Cfii<br /> SQL Server<br /> Service Broker<br /> Service Broker<br /> p.21<br /> January 2011<br /> The Smart Guide to Building World-Class Applications<br /> SQL Server<br /> Performance<br /> Tuning Tips<br /> p.10<br /> Techniques for<br /> Pivoting Data p. 15<br /> >SSIS Novices' Guide:<br /> Moving Data into the<br /> Data Warehouse p. 25<br /> Investigating Partitio<br /> Query Performance p.<br /> ning<br /> 32Comparative Review:<br /> January 201 I<br /> The Smart Guide to Building World-Class Applications<br /> J.<br /> >Denny Cherry<br /> Configuring<br /> SQL Server<br /> Service Broker<br /> i??<br /> SQL Server<br /> Performance<br /> Techniques for<br /> Pivoting Data p. 15<br /> >SSIS Novices' Guide:<br /> Moving Data into the<br /> Data <a title="January 2011 page 1" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=1"> Comparative Review: Sizing Up Data Modeling Softw</a> <a title="January 2011 page 2" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=2"> Smarter technology for a Smarter Planet: What da</a> <a title="January 2011 page 3" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=3"> WWW.SQLMAG.COM Contents </a> <a title="January 2011 page 4" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=4"> I ??? I I ??? Turn Up the Heat on SQL Se</a> <a title="January 2011 page 5" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=5"> Contents </a> <a title="January 2011 page 6" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=6"> EDITORIAL Michael Otey (motey@sql</a> <a title="January 2011 page 7" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=7"> marter technology for a Smarter ???*?????? What</a> <a title="January 2011 page 8" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=8"> <g 9 PROUD TO ANNOUNCE: Recipient of</a> <a title="January 2011 page 9" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=9"> How Many Indexes Should I Create? Y ou'v</a> <a title="January 2011 page 10" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=10"> SQL SERVER QUESTIONS ANSWERED being the clusteri</a> <a title="January 2011 page 11" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=11"> The Conversation Begins Here mobile connections</a> <a title="January 2011 page 12" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=12"> COVER STORY Top 10 SQL Server Performance Tuning</a> <a title="January 2011 page 13" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=13"> COVER STORY Tune your SQL Server environment f</a> <a title="January 2011 page 14" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=14"> COVER STORY PERFORMANCE TUNING TIPS often resu</a> <a title="January 2011 page 15" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=15"> </a> <a title="January 2011 page 16" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=16"> COVER STORY PERFORMANCE TUNING TIPS server and</a> <a title="January 2011 page 17" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=17"> Pivoting Data Identify pivoting elements and put </a> <a title="January 2011 page 18" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=18"> FEATURE PIVOTING DATA shipperid shipcity</a> <a title="January 2011 page 19" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=19"> PIVOTING DATA F E EATUR </a> <a title="January 2011 page 20" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=20"> F ATURE E PV I OTING DATA </a> <a title="January 2011 page 21" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=21"> PIVOTING DATA F E EATUR $/ </a> <a title="January 2011 page 22" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=22"> FEATURE ! ) - </a> <a title="January 2011 page 23" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=23"> PIVOTING DATA F E EATUR ! </a> <a title="January 2011 page 24" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=24"> FEATURE - + - )- - </a> <a title="January 2011 page 25" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=25"> PIVOTING DATA F E EATUR </a> <a title="January 2011 page 26" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=26"> FEATURE PIVOTING DATA !#!# $#$ !* # </a> <a title="January 2011 page 27" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=27"> FROM Sales.Orders WHERE shipcountry = N'Spain' GR</a> <a title="January 2011 page 28" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=28"> FEATURE PIVOTING DATA to least recent, you can</a> <a title="January 2011 page 29" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=29"> FROM Sales.Orders WHERE shipcountry = N'Spain' )</a> <a title="January 2011 page 30" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=30"> FEATURE PIVOTING DATA LISTING 1: Dynamic Pivot </a> <a title="January 2011 page 31" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=31"> FEATURE Configuring SQL Server Service Broker </a> <a title="January 2011 page 32" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=32"> FEATURE CONFIGURING SERVICE BROKER LISTING 1: C</a> <a title="January 2011 page 33" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=33"> CONFIGURING SERVICE BROKER FEATURE the compute</a> <a title="January 2011 page 34" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=34"> FEATURE CONFIGURING SERVICE BROKER LISTING 5: Co</a> <a title="January 2011 page 35" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=35"> FEATURE SSIS Novices' Guide to Data Warehouses</a> <a title="January 2011 page 36" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=36"> FEATURE DATA WAREHOUSING Step 1: Add the Databas</a> <a title="January 2011 page 37" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=37"> it much in the long term. It provides an easy-to-</a> <a title="January 2011 page 38" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=38"> FEATURE DATA WAREHOUSING automated project setup</a> <a title="January 2011 page 39" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=39"> tab. Execute the task again and watch it turn gre</a> <a title="January 2011 page 40" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=40"> "Those who can envision a plausible future that'</a> <a title="January 2011 page 41" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=41"> s I MONITOR??? .SQL Monitor is the future of SQ</a> <a title="January 2011 page 42" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=42"> FEATURE Investigating Partitioning Query Perfo</a> <a title="January 2011 page 43" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=43"> PARTITIONING QUERY PERFORMANCE FEATURE pre–SQL</a> <a title="January 2011 page 44" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=44"> FEATURE PARTITIONING QUERY PERFORMANCE </a> <a title="January 2011 page 45" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=45"> PARTITIONING QUERY PERFORMANCE FEATURE that th</a> <a title="January 2011 page 46" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=46"> FEATURE PARTITIONING QUERY PERFORMANCE Fi</a> <a title="January 2011 page 47" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=47"> Sizing Up Data Modeling Software The best fit dep</a> <a title="January 2011 page 48" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=48"> COMPARATIVE DATA MODELING SOFTWARE TABLE 1: Exc</a> <a title="January 2011 page 49" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=49"> Color-coding of the keys is another feature</a> <a title="January 2011 page 50" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=50"> COMPARATIVE DATA MODELING SOFTWARE DATABASE</a> <a title="January 2011 page 51" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=51"> standard, re-useable attributes similar to user-d</a> <a title="January 2011 page 52" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=52"> COMPARATIVE DATA MODELING SOFTWARE · t</a> <a title="January 2011 page 53" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=53"> vice versa. Reports are saved with the model, aft</a> <a title="January 2011 page 54" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=54"> SQLServer [CONNECTIONS) March 27-30, 2011 JOIN</a> <a title="January 2011 page 55" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=55"> 2010 Best of Connections Awards P enton Media's </a> <a title="January 2011 page 56" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=56"> Performance monitoring and tuning doesn't have </a> <a title="January 2011 page 57" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=57"> BUSINESS INTELLIGENCE ActiveAnalysis 2 Enhances B</a> <a title="January 2011 page 58" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=58"> The ACKPage B 4 SQL Azure Enhancements Mi</a> <a title="January 2011 page 59" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=59"> WHAT AREN'T YOU SEEING? SQL SENTRY CAN IDENTIFY </a> <a title="January 2011 page 60" href="https://secure.viewer.zmags.com/publication/fc0fd42e?page=60"> THIS DOCTOR MAKES HOUSE CALLS! SQL $ ?? ctor </a>