If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> Expert Advice for Virtualizing SQL Server p. 41<br /> A PENTON PUBLICATION<br /> April 2009<br /> SQL Server 2008’s Resource Governor<br /> Take Control of<br /> SQL Server<br /> Performance!<br /> p. 12<br /> More SQL Server<br /> 2008 Enhancements p.17<br /> SQL SERVER 2008<br /> FILESTREAM Storage p.21<br /> Uncovering a<br /> Hidden SQL Server<br /> Performance Killer p.25<br /> 7 STEPS for Successfully<br /> Managing Data Warehouse<br /> Projects p. 29<br /> Increase Storage<br /> Performance Without<br /> Increasing Costs p. 35<br /> T-SQL 101<br /> Transfer Data with<br /> CASE Functions p.39<br /> “30% INCREASE<br /> IN SPEED AND<br /> PERFORMANCE.”<br /> – Daniel Cosey, CareerBuilder*<br /> Every month, 23 million people use CareerBuilder.com to find their next job.<br /> Dell™ PowerEdge™ servers and Microsoft® SQL Server® helped CareerBuilder<br /> deliver reports up to 30% faster<a title="April 2009 page 1" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=1"> Expert Advice for Virtualizing SQL Server p. 41 </a> <a title="April 2009 page 2" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=2"> “30% INCREASE IN SPEED AND PERFORMANCE.” – Da</a> <a title="April 2009 page 3" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=3"> Every month, 23 million people use CareerBuilder.</a> <a title="April 2009 page 4" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=4"> RAPIDLY "SQL Backup has by far the most user- fr</a> <a title="April 2009 page 5" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=5"> WWW.SQLMAG.COM Contents </a> <a title="April 2009 page 6" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=6"> </a> <a title="April 2009 page 7" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=7"> Contents IN EVERY ISSUE 7 Editorial: </a> <a title="April 2009 page 8" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=8"> Ease into XBRL compliance with the complete set o</a> <a title="April 2009 page 9" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=9"> Find SQL Server Cost Savings InStheersvertrsyhio</a> <a title="April 2009 page 10" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=10"> We’re10! We’re Going Strong! And We L</a> <a title="April 2009 page 11" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=11"> Riding Out the IT Storm Evsperaynnminogrnfianrg</a> <a title="April 2009 page 12" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=12"> READER TO READER Find OutWhat’s Going On InsideY</a> <a title="April 2009 page 13" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=13"> Providing the vision and intellige</a> <a title="April 2009 page 14" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=14"> COVER STORY Conguring SQL Server 2008’s </a> <a title="April 2009 page 15" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=15"> COVER STORY REGAIN CONTROL of your SQL Server s</a> <a title="April 2009 page 16" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=16"> COVER STORY RESOURCE GOVERNOR</a> <a title="April 2009 page 17" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=17"> unresponsive to new logins and you might need to </a> <a title="April 2009 page 18" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=18"> </a> <a title="April 2009 page 19" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=19"> MORE SQL Server 2008 T-SQL IMPROVEMENTS </a> <a title="April 2009 page 20" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=20"> REQUIRED T-SQL IMPROVEMENTSREADING </a> <a title="April 2009 page 21" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=21"> T-SQL IMPROVEMENTS </a> <a title="April 2009 page 22" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=22"> REQUIRED T-SQL IMPROVEMENTSREADING </a> <a title="April 2009 page 23" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=23"> Using SQL Server 2008 FILESTREAM Storage New </a> <a title="April 2009 page 24" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=24"> FEATURE SQL SERVER 2008 FILESTREAM STORAGE </a> <a title="April 2009 page 25" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=25"> SQL SERVER 2008 FILESTREAM STORAGE FEATURE </a> <a title="April 2009 page 26" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=26"> FEATURE SQL SERVER 2008 FILESTREAM STORAGE LIS</a> <a title="April 2009 page 27" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=27"> FEATURE Removing Forwarded Records from HeapTa</a> <a title="April 2009 page 28" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=28"> FEATURE REMOVING FORWARDED RECORDS TABLE 1: Fo</a> <a title="April 2009 page 29" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=29"> REMOVING FORWARDED RECORDS FEATURE TABLE 2: Fo</a> <a title="April 2009 page 30" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=30"> FEATURE REMOVING FORWARDED RECORDS LISTING 3: </a> <a title="April 2009 page 31" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=31"> FEATURE 7 Steps for Successful Data Warehouse </a> <a title="April 2009 page 32" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=32"> FEATURE 7 STEPS FOR SUCCESSFUL DATA WAREHOUSE PRO</a> <a title="April 2009 page 33" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=33"> 7 STEPS FOR SUCCESSFUL DATA WAREHOUSE PROJECTS FE</a> <a title="April 2009 page 34" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=34"> FEATURE 7 STEPS FOR SUCCESSFUL DATA WAREHOUSE PRO</a> <a title="April 2009 page 35" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=35"> 7 STEPS FOR SUCCESSFUL DATA WAREHOUSE PROJECTS FE</a> <a title="April 2009 page 36" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=36"> Join Us at TechEd is one of</a> <a title="April 2009 page 37" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=37"> FEATURE MAXIM I ZE STORAGE PERFORMANCE Incr</a> <a title="April 2009 page 38" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=38"> FEATURE MAXIMIZE STORAGE PERFORMANCE TABLE 2: </a> <a title="April 2009 page 39" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=39"> MAXIMIZE STORAGE PERFORMANCE FEATURE backup t</a> <a title="April 2009 page 40" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=40"> FEATURE MAXIMIZE STORAGE PERFORMANCE in case o</a> <a title="April 2009 page 41" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=41"> FEATURE T-SQL 101: The CASE Function In Les</a> <a title="April 2009 page 42" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=42"> FEATURE T-SQL 101 An Example of a Simple CASE F</a> <a title="April 2009 page 43" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=43"> Views from the Field: Expert Advice on Virtualizi</a> <a title="April 2009 page 44" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=44"> MARKET VIRTUALIZING SQL SERVERWATCH project’s s</a> <a title="April 2009 page 45" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=45"> VIRTUALIZING SQL SERVER MARKET WATCH all the ho</a> <a title="April 2009 page 46" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=46"> SQL Server </a> <a title="April 2009 page 47" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=47"> Bytes from the Blog www.sqlmag.com/go/industrybyt</a> <a title="April 2009 page 48" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=48"> We would never tell a lie... ... but we’ve been c</a> <a title="April 2009 page 49" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=49"> DATABASE MANAGEMENT CA ERwin Data Modeling Suite </a> <a title="April 2009 page 50" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=50"> The Michael Otey (motey@sqlmag.com)</a> <a title="April 2009 page 51" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=51"> The New Standard in Monitoring and Performance </a> <a title="April 2009 page 52" href="https://secure.viewer.zmags.com/publication/a0aedcea?page=52"> SQL SERVER Sleuth? Elementary, my dear Watso</a>