If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> DevExpressASP.NET Controls p 4i | Crystal Reports 2008<br /> September 2010<br /> The Smart Guide to Building World-Class Applications<br /> a g a z i n e<br /> Working with<br /> Predicate-Based<br /> Query Filters p. 17<br /> J<br /> Database Design Essentials p. 25<br /> PowerPivot for Excel 2010:<br /> Load, Model, & Analyze Data p. 29<br /> >jMiiuil Hit/<br /> Enhanced Code Features<br /> in Visual Studio 2010 p. 33<br /> The Top 4 Ways to Address<br /> Performance Problems p. 39<br /> r<br /> r_<br /> t<br /> the<br /> <br /> Join Us for<br /> Practical Windows PowerShell<br /> Intensive, In-person 3-Day Workshop<br /> September 14-16, 2010<br /> Minneapolis<br /> September 21-23, 2010<br /> Philadelphia<br /> You'll spend 3 days with scripting author, instructor, and Microsoft MVP, Don Jones<br /> See the Entire Course Agenda at<br /> windowsitpro.com/go/PracticalPowerShell<br /> This all-new, immersion workshop has been <a title="September 2010 page 1" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=1"> DevExpressASP.NET Controls p 4i | Crystal Repor</a> <a title="September 2010 page 2" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=2"> Join Us for Practical Windows PowerShell Intens</a> <a title="September 2010 page 3" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=3"> WWW.SQLMAG.COM Contents SQL Server Storage in the</a> <a title="September 2010 page 4" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=4"> Subscribe Now to the New r Dev Connections (f</a> <a title="September 2010 page 5" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=5"> Contents </a> <a title="September 2010 page 6" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=6"> database results set of tools from Altova \ a </a> <a title="September 2010 page 7" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=7"> EDITORIAL The SubsystemYou Never KnewYou Need</a> <a title="September 2010 page 8" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=8"> // // VISION SOLUTIONS WELCOMES DOUBLE-TAKE </a> <a title="September 2010 page 9" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=9"> READER TO READER Pusher and QueryPusher Pick U</a> <a title="September 2010 page 10" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=10"> READER TO READER the result set's character wid</a> <a title="September 2010 page 11" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=11"> 8. Execute the QueryPusher utility. Note th</a> <a title="September 2010 page 12" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=12"> READER TO READER · Update the INSERT @Files stat</a> <a title="September 2010 page 13" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=13"> Is It a Bad Idea to Rebuild All Indexes Every Nig</a> <a title="September 2010 page 14" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=14"> SQL SERVER QUESTIONS ANSWERED Avoid Query Error</a> <a title="September 2010 page 15" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=15"> Taking Control of All new Virtual Conference hos</a> <a title="September 2010 page 16" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=16"> COVER STORY SQL Server Storage i</a> <a title="September 2010 page 17" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=17"> STORAGE IN THE VIRTUAL WORLD STORAGE IN THE VIRTU</a> <a title="September 2010 page 18" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=18"> COVER STORY STORAGE IN THE VIRTUAL WORLD traff</a> <a title="September 2010 page 19" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=19"> FEATURE Predicate-Based Query</a> <a title="September 2010 page 20" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=20"> FEATURE PREDICATE-BASED QUERY FILTERS WHERE, </a> <a title="September 2010 page 21" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=21"> PREDICATE-BASED QUERY FILTERS FEATURE the resu</a> <a title="September 2010 page 22" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=22"> FEATURE PREDICATE-BASED QUERY FILTERS This tim</a> <a title="September 2010 page 23" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=23"> with Resources from Left-Brain.com Left-Brain.co</a> <a title="September 2010 page 24" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=24"> THE CONVERSATION SQL SERVER CONNECTIONS Better</a> <a title="September 2010 page 25" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=25"> EGINSHERE I SQLServer (CONNECTIONS) Microsoft </a> <a title="September 2010 page 26" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=26"> - SharePointPro Connections provides guidance t</a> <a title="September 2010 page 27" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=27"> SQL SERVER CLASSICS Essential Aspects of Datab</a> <a title="September 2010 page 28" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=28"> SQL SERVER ESSENTIAL ASPECTS OF DATABASE DESIGNCL</a> <a title="September 2010 page 29" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=29"> ESSENTIAL ASPECTS OF DATABASE DESIGN SQL SERVER C</a> <a title="September 2010 page 30" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=30"> We would never tell a lie. .. but we've been cau</a> <a title="September 2010 page 31" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=31"> FEATURE A Walkthrough of Load, model, and</a> <a title="September 2010 page 32" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=32"> FEATURE POWERPIVOT FOR EXCEL data from 1790 to</a> <a title="September 2010 page 33" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=33"> Date table. Double-click the CalculatedColumn</a> <a title="September 2010 page 34" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=34"> FEATURE POWERPIVOT FOR EXCEL Figure </a> <a title="September 2010 page 35" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=35"> Visual Studio 2 010 The new version offers enhanc</a> <a title="September 2010 page 36" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=36"> FEATURE VISUAL STUDIO 2010 TABLE 1: Comparison o</a> <a title="September 2010 page 37" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=37"> all-browser-based Help. The new Windows Presentat</a> <a title="September 2010 page 38" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=38"> FEATURE VISUAL STUDIO 2010 </a> <a title="September 2010 page 39" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=39"> with Resources from Left-Brain.com Left-Brain.co</a> <a title="September 2010 page 40" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=40"> GIVE YOURSELFA with the new benefits of a Wind</a> <a title="September 2010 page 41" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=41"> FEATURE The 4 Best Ways to Efficiently Addres</a> <a title="September 2010 page 42" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=42"> FEATURE SQL SERVER PERFORMANCE DMF sys.dm_db_</a> <a title="September 2010 page 43" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=43"> PRODUCT REVIEW DevExpress ASP.NET Controls D</a> <a title="September 2010 page 44" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=44"> PRODUCT REVIEW categories, making it possib</a> <a title="September 2010 page 45" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=45"> Crystal Reports 2008 How long have you been in t</a> <a title="September 2010 page 46" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=46"> No Budget for Travel? No Problem! Get the traini</a> <a title="September 2010 page 47" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=47"> Starting My Wish List for Visual Studio Next Vis</a> <a title="September 2010 page 48" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=48"> INDUSTRY BYTES Megan </a> <a title="September 2010 page 49" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=49"> BUSINESS INTELLIGENCE Devart releases dbForge Dat</a> <a title="September 2010 page 50" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=50"> The ACKPage B SQL Server vs. SQL Azure Mic</a> <a title="September 2010 page 51" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=51"> IT MIGHT BE MORE OBVIOUS THAN YOU THINK SQL Sent</a> <a title="September 2010 page 52" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=52"> DOES I T# ??? ??? Forecast Disk Space Usage ??? I</a> <a title="September 2010 page 53" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=53"> + </a> <a title="September 2010 page 54" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=54"> #0-5-> 1+96:6.;796,<+;9-3-):-:)9-0-9- ?+</a> <a title="September 2010 page 55" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=55"> !" " " !" " " " & ! D/5@5:3::;A:</a> <a title="September 2010 page 56" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=56"> # " !" !& '>8GDHD;I 6N6I0>HJ6A-I</a> <a title="September 2010 page 57" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=57"> # " !" :MI:CH>DCH ID NDJG 6EEA>86</a> <a title="September 2010 page 58" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=58"> 6JIDB6I:9 I:HIH >C I=>H K>GIJ6A :CK>GDCB</a> <a title="September 2010 page 59" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=59"> ( .7JI1 ,#-:GK>8:HI6@:HI=:;:6G;68ID</a> <a title="September 2010 page 60" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=60"> ! !& )& $*# (%)% */ $!%!& '>8G</a> <a title="September 2010 page 61" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=61"> ! $*-%(! $ %(,"%&() %&(( % &:6G</a> <a title="September 2010 page 62" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=62"> ! H::=DL-*( .1:7 DGBH86CLDG@>CI>:G9</a> <a title="September 2010 page 63" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=63"> # ! !& " # (%)% */ %+*%</a> <a title="September 2010 page 64" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=64"> # ! "#* #+"* %)$%$**%+ )C #+"* *%+ </a> <a title="September 2010 page 65" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=65"> # !& " )"')(,(# (%)% </a> <a title="September 2010 page 66" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=66"> # B:CI6I>DC6C9H=DLL=NHDB:D;I=:IDD</a> <a title="September 2010 page 67" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=67"> # ), )*&(* ) %(-%(! $ - * *$* #</a> <a title="September 2010 page 68" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=68"> # ID --#- K6G>67A:H 8DCC:8I>DCH </a> <a title="September 2010 page 69" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=69"> ! !& " ) (&% $*# (</a> <a title="September 2010 page 70" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=70"> ! MI:GC6A &>HIH ( . HH:B7AN </a> <a title="September 2010 page 71" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=71"> ! A:6GC=DLID6A><CNDJG<DK:GC6C8:</a> <a title="September 2010 page 72" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=72"> ! *& ** $ %0/- * )(, </a> <a title="September 2010 page 73" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=73"> ! I>DCHJH>C<*:G;DGB6C8:*D>CI-:G</a> <a title="September 2010 page 74" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=74"> !!" ! $ %*$*$+!%$$* %$)E !/$</a> <a title="September 2010 page 75" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=75"> $ B:CIHDB:D;I=:@:N8DG: DI(:I(J@:;:6</a> <a title="September 2010 page 76" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=76"> ! $ %$()$# '#,$' ( $%(I#$+ "%"I2</a> <a title="September 2010 page 77" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=77"> ' #'!""!$&' &+&!&+!'$& ! !+ SCOTT </a> <a title="September 2010 page 78" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=78"> ! ! !%"! .=C</a> <a title="September 2010 page 79" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=79"> ' ! $ $%&$&! '% + !&! !(</a> <a title="September 2010 page 80" href="https://secure.viewer.zmags.com/publication/6e47d22c?page=80"> Penton Media c/o Tech Conferences, Inc. 731 Main </a>