If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> REVIEWS: SQL diagnostic manager 5.0 p.43 | DXtreme p.44<br /> A PENTON PUBLICATION<br /> February 2008<br /> You Asked for It:<br /> A CUSTOM DBA<br /> REPOSITORY<br /> p. 14<br /> DATA WAREHOUSING:<br /> Tame MONSTER Dimensions<br /> p. 19<br /> ITZIK BEN-GAN:<br /> TROUBLESOME Updates<br /> p. 23<br /> FORGET SELF-JOINS:<br /> 5 STEPS to Hierarchical Reporting<br /> p. 27<br /> KALEN DELANEY:<br /> The INSIDE EDGE on<br /> Unindexed Columns<br /> p. 33<br /> BI TOOLS: TOOLTIME<br /> WHAT IS PerformancePoint? with Kevin Kline<br /> p. 37 p. 13REVIEWS: SQL diagnostic<br /> ical Reporting<br /> KALEN DELANEY:<br /> The INSIDE EDGE on<br /> Unindexed Column<br /> ,33<br /> brmancePoint?<br /> <br /> PAY UP TO<br /> 72% LESS<br /> FOR Y<a title="February 2008 page 1" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=1"> REVIEWS: SQL diagnostic manager 5.0 p.43 | DXtr</a> <a title="February 2008 page 2" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=2"> PAY UP TO 72% LESS FOR YOUR BUSINESS INTELLIGENCE</a> <a title="February 2008 page 3" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=3"> Dell, Microsoft®, and AMD can help reduce the cos</a> <a title="February 2008 page 4" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=4"> "We were really impressed. The 75 GB backup that </a> <a title="February 2008 page 5" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=5"> WWW.SQLMAG.COM Contents </a> <a title="February 2008 page 6" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=6"> For SQL Server consolidation, there’s only one so</a> <a title="February 2008 page 7" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=7"> Contents COLUMNS 13 ToolTime: SQLPi</a> <a title="February 2008 page 8" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=8"> Drag & Drop Data Conversion Check out Alt</a> <a title="February 2008 page 9" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=9"> Where SQL Server Should Go from Here Alethaosiun</a> <a title="February 2008 page 10" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=10"> READER TO READER Create Calculated MembersTh</a> <a title="February 2008 page 11" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=11"> </a> <a title="February 2008 page 12" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=12"> </a> <a title="February 2008 page 13" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=13"> 0?-1445*7-;<8145)686716:</)6<0<-);>81:-<+=<)741</a> <a title="February 2008 page 14" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=14"> *7<01<)6,<0->1:<=)415)/16-;07;<-,761<):-8:7<-+<-,</a> <a title="February 2008 page 15" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=15"> ;-:>-:764A*-16/)*4-<7*-8:-;-6<-,<776->1:<=)415)/1</a> <a title="February 2008 page 16" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=16"> </a> <a title="February 2008 page 17" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=17"> Join Your Community Windows IT Pro is much, </a> <a title="February 2008 page 18" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=18"> READER TO READER ([Calendars].[Calendars]. [W</a> <a title="February 2008 page 19" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=19"> Business Objects YOU'VE NEVER SEEN A REPORT DO TH</a> <a title="February 2008 page 20" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=20"> ApexSQL Studio your One-Stop-Shop for SQL Server</a> <a title="February 2008 page 21" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=21"> SQLPing Scans your network to find new and unprot</a> <a title="February 2008 page 22" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=22"> COVER STORY Use SSRS and SSIS Rodney Landrum</a> <a title="February 2008 page 23" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=23"> COVER STORY Enhancements to the original soluti</a> <a title="February 2008 page 24" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=24"> COVER STORY CREATE A DBA REPOSITORY </a> <a title="February 2008 page 25" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=25"> ADVERTISING 10</a> <a title="February 2008 page 26" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=26"> DISASTER RECOVERY 5 Replication: </a> <a title="February 2008 page 27" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=27"> CREATE A DBA REPOSITORY COVER STORY </a> <a title="February 2008 page 28" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=28"> COVER STORY CREATE A DBA REPOSITORY </a> <a title="February 2008 page 29" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=29"> FEATURE Data Warehousing: Rapidly Changing MON</a> <a title="February 2008 page 30" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=30"> FEATURE </a> <a title="February 2008 page 31" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=31"> IT’SAPERFECT FIT! INTRODUCING TH</a> <a title="February 2008 page 32" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=32"> Everything should have automated recovery to poin</a> <a title="February 2008 page 33" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=33"> SQL Server Read-Consistency PROBLEMS, PART 3 Upd</a> <a title="February 2008 page 34" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=34"> FEATURE READ CONSISTENCY, PART 3 LISTING 2: Co</a> <a title="February 2008 page 35" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=35"> IKBE !## ),%*-"*!,(**%)&#+* %</a> <a title="February 2008 page 36" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=36"> "$!$ !!$ &+%* &%/-!(% #(%$&(&+*(,( +%++ *-%</a> <a title="February 2008 page 37" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=37"> !$ !)!$ &$$$!&& + !&%$%'&&! %)%&!$'"&% !</a> <a title="February 2008 page 38" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=38"> ! + " $ '#,)-) .3O')(3*,#&O'#,)-) .3 ,</a> <a title="February 2008 page 39" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=39"> %#%$($, ! &! % '#,)-) .3O')(3*,#&O'#</a> <a title="February 2008 page 40" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=40"> %#%$($, ! &! % :ELH=BL<NLLFHGBMHK</a> <a title="February 2008 page 41" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=41"> %#%$($, ! &! % =BO>BGMHMA>KHE>H?MA</a> <a title="February 2008 page 42" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=42"> %#%$($, ! &! % %%%! % %"$%$%'&&! %</a> <a title="February 2008 page 43" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=43"> %#%$($, ! &! % HGAHPMA>/>LHNK<>$HO</a> <a title="February 2008 page 44" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=44"> $%&$!$%#%$($! &! % && &%%%%! %!$$ </a> <a title="February 2008 page 45" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=45"> $%&$!$%#%$($! &! % && &%%%%! %!$$ )))</a> <a title="February 2008 page 46" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=46"> $%&$!$%#%$($! &! % && &%%%%! %!$$ ))</a> <a title="February 2008 page 47" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=47"> !$ !)!$ &$$$!&& %"$%$%'&&! %)%&!$'"&% </a> <a title="February 2008 page 48" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=48"> %&'$+"$%' +"$ *,)( ,(1),%-")*-O-./,3*,#&-/</a> <a title="February 2008 page 49" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=49"> %&'$+"$%' +"$ *,)( ,(1),%-")*-O-./,3*,#&-/(</a> <a title="February 2008 page 50" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=50"> %&'$+"$%' +"$ *,)( ,(1),%-")*-O-./,3*,#&-/</a> <a title="February 2008 page 51" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=51"> &'$%+"$ *)-.)( ,(1),%-")*-O."/,-3*,#& -,01 </a> <a title="February 2008 page 52" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=52"> !$ !)!$ &$$$!&&B!$ !!$ %("$%-%("$*</a> <a title="February 2008 page 53" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=53"> ("!%!%&'%'"!!(&,!"'"!#%'# '%"("&!&&&"!#%%# (</a> <a title="February 2008 page 54" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=54"> IKBE %@;1=4>->@;45=B5@#1@@9>BB %"%*-* @??64E:@</a> <a title="February 2008 page 55" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=55"> TABLE 1: Reading the Same RowTwice empid salary </a> <a title="February 2008 page 56" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=56"> </a> <a title="February 2008 page 57" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=57"> Reporting on Hierarchical</a> <a title="February 2008 page 58" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=58"> IBM, the IBM logo and Take Back Control are trade</a> <a title="February 2008 page 59" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=59"> .INFRASTRUCTURE LOG _DAY 69: All we need is one s</a> <a title="February 2008 page 60" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=60"> FEATURE CRYSTAL-CLEAR REPORTING ON HIERARCHICAL D</a> <a title="February 2008 page 61" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=61"> CRYSTAL-CLEAR REPORTING ON HIERARCHICAL DATA FEAT</a> <a title="February 2008 page 62" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=62"> April 20-23, 2008 Marriott Orlando World Center </a> <a title="February 2008 page 63" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=63"> FEATURE COLUMN STATISTICS EDGOPETIMIZER </a> <a title="February 2008 page 64" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=64"> FEATURE COLUMN STATISTICS </a> <a title="February 2008 page 65" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=65"> The most efficient join plans usually occur when </a> <a title="February 2008 page 66" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=66"> EnhanceReportingServiceswith thetechnologyofthefu</a> <a title="February 2008 page 67" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=67"> UNVEILING PSeErRfoVrEmR a2n0</a> <a title="February 2008 page 68" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=68"> FEATURE PERFORMANCEPOINT SERVER 2007 </a> <a title="February 2008 page 69" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=69"> PERFORMANCEPOINT SERVER 2007 divisions with be</a> <a title="February 2008 page 70" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=70"> You Know... Along with windowsifpro.com and sqlma</a> <a title="February 2008 page 71" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=71"> SharpenYour Basic SQL Server Skills Database back</a> <a title="February 2008 page 72" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=72"> FEATURE SHARPEN YOUR SKILLS and simple. In the</a> <a title="February 2008 page 73" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=73"> PRODUCT REVIEW SQL diagnostic manager 5.0 Ido</a> <a title="February 2008 page 74" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=74"> PRODUCT REVIEW DXtreme for Windows Enterprise </a> <a title="February 2008 page 75" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=75"> Bytes from the Blog www.sqlmag.com/go/industrybyt</a> <a title="February 2008 page 76" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=76"> NEW PRODUCTS Editor’s Ti</a> <a title="February 2008 page 77" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=77"> MARKETPLACE February 2008 47 Connecting reade</a> <a title="February 2008 page 78" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=78"> The Michael Otey (motey@sqlmag.com)</a> <a title="February 2008 page 79" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=79"> SQtSENnm Event Manager The Best Database Manageme</a> <a title="February 2008 page 80" href="https://secure.viewer.zmags.com/publication/a8b69cea?page=80"> OVER 70,000 SQL SERVERS MONITORED WORLDWIDE htm S</a>