If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> A PENTON PUBLICATION<br /> Is SQL Server 2008 R2 For You? p. 9<br /> December 2009<br /> The Smart Guide to Building World-Class Applications<br /> BEST<br /> PRODUCTS<br /> OF 2009<br /> EDITORS' BEST &<br /> COMMUNITY CHOICE<br /> AWARDS<br /> p.12<br /> >Itzik Ben-Gan PASSING NULL ADMINISTERING<br /> MORE ON PARAMETERS p.33 SHAREPOINT<br /> CALCULATING CONTENT<br /> CONCURRENT >SSAS DATABASES p. 27<br /> SESSIONS p.21 BUILDING YOUR<br /> FIRST CUBE p.39<br /> Smarter technology for a Smarter Planet:<br /> Finding meaning<br /> in the noise.<br /> An unprecedented amount of information flows through companies every<br /> day<a title="December 2009 page 1" href="https://secure.viewer.zmags.com/publication/5300812c?page=1"> A PENTON PUBLICATION Is SQL Server 2008 R2 For Y</a> <a title="December 2009 page 2" href="https://secure.viewer.zmags.com/publication/5300812c?page=2"> Smarter technology for a Smarter Planet: Findin</a> <a title="December 2009 page 3" href="https://secure.viewer.zmags.com/publication/5300812c?page=3"> IBM, the IBM logo, ibm.com, Smarter Planet and th</a> <a title="December 2009 page 4" href="https://secure.viewer.zmags.com/publication/5300812c?page=4"> Expert Knowledge Backup and Recovery</a> <a title="December 2009 page 5" href="https://secure.viewer.zmags.com/publication/5300812c?page=5"> Contents </a> <a title="December 2009 page 6" href="https://secure.viewer.zmags.com/publication/5300812c?page=6"> Smarter technology for a Smarter Planet: Is you</a> <a title="December 2009 page 7" href="https://secure.viewer.zmags.com/publication/5300812c?page=7"> </a> <a title="December 2009 page 8" href="https://secure.viewer.zmags.com/publication/5300812c?page=8"> SQL Server Magazine Congratulates Quest Software </a> <a title="December 2009 page 9" href="https://secure.viewer.zmags.com/publication/5300812c?page=9"> Contents </a> <a title="December 2009 page 10" href="https://secure.viewer.zmags.com/publication/5300812c?page=10"> REWARD 30-day Free Trial www.altova.com/wanted ji</a> <a title="December 2009 page 11" href="https://secure.viewer.zmags.com/publication/5300812c?page=11"> </a> <a title="December 2009 page 12" href="https://secure.viewer.zmags.com/publication/5300812c?page=12"> </a> <a title="December 2009 page 13" href="https://secure.viewer.zmags.com/publication/5300812c?page=13"> A sample of our great sessions. Check online for </a> <a title="December 2009 page 14" href="https://secure.viewer.zmags.com/publication/5300812c?page=14"> </a> <a title="December 2009 page 15" href="https://secure.viewer.zmags.com/publication/5300812c?page=15"> Is SQL Server 2008 R2 ForYou? With SQL Server 200</a> <a title="December 2009 page 16" href="https://secure.viewer.zmags.com/publication/5300812c?page=16"> Over 90% reduction in storage footprint Introdu</a> <a title="December 2009 page 17" href="https://secure.viewer.zmags.com/publication/5300812c?page=17"> TOOL TIME SQL Server PowerShell Extensions </a> <a title="December 2009 page 18" href="https://secure.viewer.zmags.com/publication/5300812c?page=18"> COVER STORY SQL Server Magazine by the SQL Serve</a> <a title="December 2009 page 19" href="https://secure.viewer.zmags.com/publication/5300812c?page=19"> COVER STORY We chose— and you</a> <a title="December 2009 page 20" href="https://secure.viewer.zmags.com/publication/5300812c?page=20"> COVER 2009 SQL SERVER MAGAZINE AWARDS ST</a> <a title="December 2009 page 21" href="https://secure.viewer.zmags.com/publication/5300812c?page=21"> 2009 SQL SERVER MAGAZINE AWARDS COVER </a> <a title="December 2009 page 22" href="https://secure.viewer.zmags.com/publication/5300812c?page=22"> COVER 2009 SQL SERVER MAGAZINE AWARDS ST</a> <a title="December 2009 page 23" href="https://secure.viewer.zmags.com/publication/5300812c?page=23"> Yossi </a> <a title="December 2009 page 24" href="https://secure.viewer.zmags.com/publication/5300812c?page=24"> COVER 2009 SQL SERVER MAGAZINE AWARDS STOR</a> <a title="December 2009 page 25" href="https://secure.viewer.zmags.com/publication/5300812c?page=25"> 2009 SQL SERVER MAGAZINE AWARDS COVER </a> <a title="December 2009 page 26" href="https://secure.viewer.zmags.com/publication/5300812c?page=26"> SQL Server Magazine Congratulates HyperBacTechnol</a> <a title="December 2009 page 27" href="https://secure.viewer.zmags.com/publication/5300812c?page=27"> Calculating Concurrent Part 2 A better s</a> <a title="December 2009 page 28" href="https://secure.viewer.zmags.com/publication/5300812c?page=28"> FEATURE CONCURRENT SESSIONS -- Part 1 CREA</a> <a title="December 2009 page 29" href="https://secure.viewer.zmags.com/publication/5300812c?page=29"> manipulation compared with set-based solu- tions,</a> <a title="December 2009 page 30" href="https://secure.viewer.zmags.com/publication/5300812c?page=30"> SQLServerMagazine Congratulates EMC Corporation </a> <a title="December 2009 page 31" href="https://secure.viewer.zmags.com/publication/5300812c?page=31"> Deployments e</a> <a title="December 2009 page 32" href="https://secure.viewer.zmags.com/publication/5300812c?page=32"> Sometimes the SQL Server performance problem is o</a> <a title="December 2009 page 33" href="https://secure.viewer.zmags.com/publication/5300812c?page=33"> FEATURE Administer WSS 3.0 Content </a> <a title="December 2009 page 34" href="https://secure.viewer.zmags.com/publication/5300812c?page=34"> FEATURE ADMINISTER WSS 3.0 IN SQL SERVER </a> <a title="December 2009 page 35" href="https://secure.viewer.zmags.com/publication/5300812c?page=35"> ADMINISTER WSS 3.0 IN SQL SERVER FEATURE </a> <a title="December 2009 page 36" href="https://secure.viewer.zmags.com/publication/5300812c?page=36"> FEATURE ADMINISTER WSS 3.0 IN SQL SERVER Store</a> <a title="December 2009 page 37" href="https://secure.viewer.zmags.com/publication/5300812c?page=37"> POWERFUL & INTUITIVE BUSINESS INTELLIGENCE </a> <a title="December 2009 page 38" href="https://secure.viewer.zmags.com/publication/5300812c?page=38"> Get the Best of Both Worlds With every</a> <a title="December 2009 page 39" href="https://secure.viewer.zmags.com/publication/5300812c?page=39"> FEATURE Passing NULL Parameters How to handle</a> <a title="December 2009 page 40" href="https://secure.viewer.zmags.com/publication/5300812c?page=40"> FEATURE PASSING NULL PARAMETERS LISTING 2: Exe</a> <a title="December 2009 page 41" href="https://secure.viewer.zmags.com/publication/5300812c?page=41"> FEATURE Design Your DataWarehouse </a> <a title="December 2009 page 42" href="https://secure.viewer.zmags.com/publication/5300812c?page=42"> FEATURE WAREHOUSE STORAGE PERFORMANCE Discover </a> <a title="December 2009 page 43" href="https://secure.viewer.zmags.com/publication/5300812c?page=43"> WAREHOUSE STORAGE PERFORMANCE FEATURE which is </a> <a title="December 2009 page 44" href="https://secure.viewer.zmags.com/publication/5300812c?page=44"> FEATURE WAREHOUSE STORAGE PERFORMANCE writes. I</a> <a title="December 2009 page 45" href="https://secure.viewer.zmags.com/publication/5300812c?page=45"> Building Your First Get at your BI data more</a> <a title="December 2009 page 46" href="https://secure.viewer.zmags.com/publication/5300812c?page=46"> FEATURE </a> <a title="December 2009 page 47" href="https://secure.viewer.zmags.com/publication/5300812c?page=47"> conference and expo MARCH 22-25, 2010 FOCUS ON </a> <a title="December 2009 page 48" href="https://secure.viewer.zmags.com/publication/5300812c?page=48"> Prime Your Mind with Resources from Left-Brain.co</a> <a title="December 2009 page 49" href="https://secure.viewer.zmags.com/publication/5300812c?page=49"> FIRST CUBE FEATURE Data Source View (DSV)</a> <a title="December 2009 page 50" href="https://secure.viewer.zmags.com/publication/5300812c?page=50"> FEATURE FIRST CUBE </a> <a title="December 2009 page 51" href="https://secure.viewer.zmags.com/publication/5300812c?page=51"> We would never tell a lie... ... but we’ve been c</a> <a title="December 2009 page 52" href="https://secure.viewer.zmags.com/publication/5300812c?page=52"> Hit Your </a> <a title="December 2009 page 53" href="https://secure.viewer.zmags.com/publication/5300812c?page=53"> FEATURE DBCC CHECKDB for LARGE Very </a> <a title="December 2009 page 54" href="https://secure.viewer.zmags.com/publication/5300812c?page=54"> FEATURE DBCC CHECKDB FOR VLDBS </a> <a title="December 2009 page 55" href="https://secure.viewer.zmags.com/publication/5300812c?page=55"> When the @VLDB parameter is set to 1, mnt</a> <a title="December 2009 page 56" href="https://secure.viewer.zmags.com/publication/5300812c?page=56"> GIVE YOURSELFA withthenewbenefitsofa WindowsIT</a> <a title="December 2009 page 57" href="https://secure.viewer.zmags.com/publication/5300812c?page=57"> Bytes from the Blog www.sqlmag.com/go/industrybyt</a> <a title="December 2009 page 58" href="https://secure.viewer.zmags.com/publication/5300812c?page=58"> INDUSTRY NEWS </a> <a title="December 2009 page 59" href="https://secure.viewer.zmags.com/publication/5300812c?page=59"> Business Intelligence for DBAs Iwas reading Mich</a> <a title="December 2009 page 60" href="https://secure.viewer.zmags.com/publication/5300812c?page=60"> INDUSTRY NEWS Savv yAssistan ts Your guide to spo</a> <a title="December 2009 page 61" href="https://secure.viewer.zmags.com/publication/5300812c?page=61"> 2010 SUMMIT & EXPO MARCH 1619, 2010 BELLAGIOLAS</a> <a title="December 2009 page 62" href="https://secure.viewer.zmags.com/publication/5300812c?page=62"> The Michael Otey (motey@sqlmag.com</a> <a title="December 2009 page 63" href="https://secure.viewer.zmags.com/publication/5300812c?page=63"> The complete performance solution </a> <a title="December 2009 page 64" href="https://secure.viewer.zmags.com/publication/5300812c?page=64"> WE KNOW SIZE MATTERS. (smallest is best.) </a>