If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> Product Review: DBMoto 6.6 p. 45<br /> October 2009<br /> The Smart Guide to Building World-Class Applications<br /> >SQL Server 2008 Monitor<br /> 4 NEW<br /> DATE & TIME SQL Server<br /> DATA TYPES p.19<br /> 2008 with<br /> >Use SSIS OpsMgr<br /> A NEW WAY<br /> p. 31<br /> TO ACCESS<br /> WMI DATA p.23<br /> GENERATE A<br /> SIMPLE BACKUP<br /> STATUS REPORT p. 37<br /> USE CLR AND C#<br /> TO TRANSPOSE<br /> A QUERY’S<br /> RESULT SET p.41<br /> DONALD<br /> Farmer<br /> ON MANAGED<br /> SELF-SERVICE BI p.12fimrr<br /> Q^tober 2009<br /> The Smart Guide to Buildiflg World-Class Applications<br /> >Use SSIS<br /> i A NEW WAY<br /> TO ACCESS<br /> WMI DATA P 23<br /> E<br <a title="October 2009 page 1" href="https://secure.viewer.zmags.com/publication/3a53a328?page=1"> Product Review: DBMoto 6.6 p. 45 </a> <a title="October 2009 page 2" href="https://secure.viewer.zmags.com/publication/3a53a328?page=2"> Smarter technology for a Smarter Planet: Findin</a> <a title="October 2009 page 3" href="https://secure.viewer.zmags.com/publication/3a53a328?page=3"> IBM, the IBM logo, ibm.com, Smarter Planet and th</a> <a title="October 2009 page 4" href="https://secure.viewer.zmags.com/publication/3a53a328?page=4"> BOOST "SQL Backup has always been a great produc</a> <a title="October 2009 page 5" href="https://secure.viewer.zmags.com/publication/3a53a328?page=5"> Contents </a> <a title="October 2009 page 6" href="https://secure.viewer.zmags.com/publication/3a53a328?page=6"> Expert Knowledge Backup and Recovery Performance </a> <a title="October 2009 page 7" href="https://secure.viewer.zmags.com/publication/3a53a328?page=7"> Contents </a> <a title="October 2009 page 8" href="https://secure.viewer.zmags.com/publication/3a53a328?page=8"> Connect legacy technologies affordably with the c</a> <a title="October 2009 page 9" href="https://secure.viewer.zmags.com/publication/3a53a328?page=9"> Getting Started with BI Dogenceus(eBI)? SQL Ser</a> <a title="October 2009 page 10" href="https://secure.viewer.zmags.com/publication/3a53a328?page=10"> READER TO READER Shaunt Khal</a> <a title="October 2009 page 11" href="https://secure.viewer.zmags.com/publication/3a53a328?page=11"> %! !" 6&+*C $#$! !" !!</a> <a title="October 2009 page 12" href="https://secure.viewer.zmags.com/publication/3a53a328?page=12"> $ !" ,>7(;,5;</a> <a title="October 2009 page 13" href="https://secure.viewer.zmags.com/publication/3a53a328?page=13"> !! # " % " $! </a> <a title="October 2009 page 14" href="https://secure.viewer.zmags.com/publication/3a53a328?page=14"> %! !" 6&+*C ! %! % " 6></a> <a title="October 2009 page 15" href="https://secure.viewer.zmags.com/publication/3a53a328?page=15"> One Place,OneTime ... DevConnections NOVEMBER 9-</a> <a title="October 2009 page 16" href="https://secure.viewer.zmags.com/publication/3a53a328?page=16"> READER TO READER Figure 1 Excerpt fro</a> <a title="October 2009 page 17" href="https://secure.viewer.zmags.com/publication/3a53a328?page=17"> AbaPerls Quickly automate and script databases an</a> <a title="October 2009 page 18" href="https://secure.viewer.zmags.com/publication/3a53a328?page=18"> COVER STORY </a> <a title="October 2009 page 19" href="https://secure.viewer.zmags.com/publication/3a53a328?page=19"> COVER STORY SQL Server 2008 R2 edge workers—</a> <a title="October 2009 page 20" href="https://secure.viewer.zmags.com/publication/3a53a328?page=20"> COVER STORY MANAGED SELF-SERVICE BI da</a> <a title="October 2009 page 21" href="https://secure.viewer.zmags.com/publication/3a53a328?page=21"> Yossi </a> <a title="October 2009 page 22" href="https://secure.viewer.zmags.com/publication/3a53a328?page=22"> COVER STORY MANAGED SELF-SERVICE BI and</a> <a title="October 2009 page 23" href="https://secure.viewer.zmags.com/publication/3a53a328?page=23"> WHATISA SQLVIRTUAL DATABASE? SQLvirtual database </a> <a title="October 2009 page 24" href="https://secure.viewer.zmags.com/publication/3a53a328?page=24"> NEW FROM IDERA! SQLvirtualdatabase™ SQL virtual</a> <a title="October 2009 page 25" href="https://secure.viewer.zmags.com/publication/3a53a328?page=25"> SQL VIRTUAL DATABASE Everhadtorestoreabackupfi</a> <a title="October 2009 page 26" href="https://secure.viewer.zmags.com/publication/3a53a328?page=26"> NEW! SQLVIRTUAL DATABASE TRYITFORYOURSELF! Downl</a> <a title="October 2009 page 27" href="https://secure.viewer.zmags.com/publication/3a53a328?page=27"> SQL Server Magazine: They see the value in it but</a> <a title="October 2009 page 28" href="https://secure.viewer.zmags.com/publication/3a53a328?page=28"> Get the Best of Both Worlds With every</a> <a title="October 2009 page 29" href="https://secure.viewer.zmags.com/publication/3a53a328?page=29"> FEATURE Date&Time Support in</a> <a title="October 2009 page 30" href="https://secure.viewer.zmags.com/publication/3a53a328?page=30"> FEATURE DATE AND TIME IN SQL 2008 storage is e</a> <a title="October 2009 page 31" href="https://secure.viewer.zmags.com/publication/3a53a328?page=31"> DATE AND TIME IN SQL 2008 FEATURE depend</a> <a title="October 2009 page 32" href="https://secure.viewer.zmags.com/publication/3a53a328?page=32"> FEATURE DATE AND TIME IN SQL 2008 DECLARE @dto</a> <a title="October 2009 page 33" href="https://secure.viewer.zmags.com/publication/3a53a328?page=33"> FEATURE UseSSISAccess </a> <a title="October 2009 page 34" href="https://secure.viewer.zmags.com/publication/3a53a328?page=34"> FEATURE ACCESS WMI DATA </a> <a title="October 2009 page 35" href="https://secure.viewer.zmags.com/publication/3a53a328?page=35"> DevConnections THE CUTTING EDGE EVENT FOR DEVELOP</a> <a title="October 2009 page 36" href="https://secure.viewer.zmags.com/publication/3a53a328?page=36"> DEVCONNECTIONS STAY CONNECTED: Dive into Microso</a> <a title="October 2009 page 37" href="https://secure.viewer.zmags.com/publication/3a53a328?page=37"> Check online for speakerbios and additional key</a> <a title="October 2009 page 38" href="https://secure.viewer.zmags.com/publication/3a53a328?page=38"> ASP.NET MICROSOFT DAY & REGULAR SESSIONS ASP.NET </a> <a title="October 2009 page 39" href="https://secure.viewer.zmags.com/publication/3a53a328?page=39"> ASP.NET SESSIONS SECURITY ASC301: CREATE CLAIM</a> <a title="October 2009 page 40" href="https://secure.viewer.zmags.com/publication/3a53a328?page=40"> ASP.NET SESSIONS plates, create data converters</a> <a title="October 2009 page 41" href="https://secure.viewer.zmags.com/publication/3a53a328?page=41"> VISUAL STUD IO & .NET MICROSOFT DAY THE FUTURE O</a> <a title="October 2009 page 42" href="https://secure.viewer.zmags.com/publication/3a53a328?page=42"> VISUAL STUDIO & .NET MICROSOFT DAY & REGULAR SE</a> <a title="October 2009 page 43" href="https://secure.viewer.zmags.com/publication/3a53a328?page=43"> V ISUAL STUDIO & .NET SESSIONS types. With Vis</a> <a title="October 2009 page 44" href="https://secure.viewer.zmags.com/publication/3a53a328?page=44"> MOBILE SESSIONS VMD301: BUILDING WINDOWS MOBILE </a> <a title="October 2009 page 45" href="https://secure.viewer.zmags.com/publication/3a53a328?page=45"> ARCHITECT SESSIONS ARCHITECTURE CONNECTIONS V</a> <a title="October 2009 page 46" href="https://secure.viewer.zmags.com/publication/3a53a328?page=46"> CLOUD COMPUTING MICROSOFT DAY & REGULAR SESSIONS</a> <a title="October 2009 page 47" href="https://secure.viewer.zmags.com/publication/3a53a328?page=47"> C LOUD COMPUTING SESSIONS conjunction with th</a> <a title="October 2009 page 48" href="https://secure.viewer.zmags.com/publication/3a53a328?page=48"> SHAREPOINT SESSIONS MICROSOFT DAY SESSIONS Key</a> <a title="October 2009 page 49" href="https://secure.viewer.zmags.com/publication/3a53a328?page=49"> SHAREPOINT SESSIONS HDV305: MANAGE YOUR BUSINES</a> <a title="October 2009 page 50" href="https://secure.viewer.zmags.com/publication/3a53a328?page=50"> SHAREPOINT SESSIONS HIT310: IMPLEMENT SHAREPOINT</a> <a title="October 2009 page 51" href="https://secure.viewer.zmags.com/publication/3a53a328?page=51"> OPENFORCE ’09 SESSIONS The session also focus</a> <a title="October 2009 page 52" href="https://secure.viewer.zmags.com/publication/3a53a328?page=52"> SQL SERVER MICROSOFT DAY MICROSOFT PROJECT COD</a> <a title="October 2009 page 53" href="https://secure.viewer.zmags.com/publication/3a53a328?page=53"> Attend Microsoft ASP.NET, Visual Studio & .NET,</a> <a title="October 2009 page 54" href="https://secure.viewer.zmags.com/publication/3a53a328?page=54"> SQL SERVER SESSIONS SDV309: FOLLOW THE RABBIT</a> <a title="October 2009 page 55" href="https://secure.viewer.zmags.com/publication/3a53a328?page=55"> SQL SERVER SESSIONS SDB304: PRACTICAL PERFORMA</a> <a title="October 2009 page 56" href="https://secure.viewer.zmags.com/publication/3a53a328?page=56"> PRE-CONFERENCE WORKSHOPS </a> <a title="October 2009 page 57" href="https://secure.viewer.zmags.com/publication/3a53a328?page=57"> Workshops and speakers are subjectto change. Se</a> <a title="October 2009 page 58" href="https://secure.viewer.zmags.com/publication/3a53a328?page=58"> POST-CONFERENCE WORKSHOPS SHAR</a> <a title="October 2009 page 59" href="https://secure.viewer.zmags.com/publication/3a53a328?page=59"> and additional speakers. Check Web site for Mi</a> <a title="October 2009 page 60" href="https://secure.viewer.zmags.com/publication/3a53a328?page=60"> HOTEL INFORMATIONJoin us in LAS VEGAS, NV MANDAL</a> <a title="October 2009 page 61" href="https://secure.viewer.zmags.com/publication/3a53a328?page=61"> FULL CONFERENCE REGISTRATION </a> <a title="October 2009 page 62" href="https://secure.viewer.zmags.com/publication/3a53a328?page=62"> DevConnections 2009 c/o Tech Conferences, Inc. 73</a> <a title="October 2009 page 63" href="https://secure.viewer.zmags.com/publication/3a53a328?page=63"> This needs to be a comma-separated list, so don’t</a> <a title="October 2009 page 64" href="https://secure.viewer.zmags.com/publication/3a53a328?page=64"> FEATURE ACCESS WMI DATA </a> <a title="October 2009 page 65" href="https://secure.viewer.zmags.com/publication/3a53a328?page=65"> the design surface of the Data Flow tab. Draw a p</a> <a title="October 2009 page 66" href="https://secure.viewer.zmags.com/publication/3a53a328?page=66"> Smarter technology for a Smarter Planet: Is you</a> <a title="October 2009 page 67" href="https://secure.viewer.zmags.com/publication/3a53a328?page=67"> </a> <a title="October 2009 page 68" href="https://secure.viewer.zmags.com/publication/3a53a328?page=68"> Stock Your IT Toolbox with All the Tools You Need</a> <a title="October 2009 page 69" href="https://secure.viewer.zmags.com/publication/3a53a328?page=69"> FEATURE Monitor SQL Server 2008 </a> <a title="October 2009 page 70" href="https://secure.viewer.zmags.com/publication/3a53a328?page=70"> FEATURE MONITOR SQL SERVER 2008 </a> <a title="October 2009 page 71" href="https://secure.viewer.zmags.com/publication/3a53a328?page=71"> Services, respectively.) 2. Execute the follo</a> <a title="October 2009 page 72" href="https://secure.viewer.zmags.com/publication/3a53a328?page=72"> FEATURE MONITOR SQL SERVER 2008 THE FUTURE OFTHE</a> <a title="October 2009 page 73" href="https://secure.viewer.zmags.com/publication/3a53a328?page=73"> MONITOR SQL SERVER 2008 FEATURE Using </a> <a title="October 2009 page 74" href="https://secure.viewer.zmags.com/publication/3a53a328?page=74"> Prime Your Mind with Resources from L</a> <a title="October 2009 page 75" href="https://secure.viewer.zmags.com/publication/3a53a328?page=75"> FEATURE Checking on MultipleBackupSta SQL </a> <a title="October 2009 page 76" href="https://secure.viewer.zmags.com/publication/3a53a328?page=76"> FEATURE CHECKING BACKUP STATUS LISTING 1: Scri</a> <a title="October 2009 page 77" href="https://secure.viewer.zmags.com/publication/3a53a328?page=77"> see “Linking Servers” in BOL. The subse</a> <a title="October 2009 page 78" href="https://secure.viewer.zmags.com/publication/3a53a328?page=78"> Your BI Environment with FREE BI Sizer Tool Pr</a> <a title="October 2009 page 79" href="https://secure.viewer.zmags.com/publication/3a53a328?page=79"> FEATURE How SQL Server </a> <a title="October 2009 page 80" href="https://secure.viewer.zmags.com/publication/3a53a328?page=80"> FEATURE SQL SERVER CLR Figure 2 A s</a> <a title="October 2009 page 81" href="https://secure.viewer.zmags.com/publication/3a53a328?page=81"> • Limit number of queried rows to 2048—When an</a> <a title="October 2009 page 82" href="https://secure.viewer.zmags.com/publication/3a53a328?page=82"> FEATURE SQL SERVER CLR Figure 7 A m</a> <a title="October 2009 page 83" href="https://secure.viewer.zmags.com/publication/3a53a328?page=83"> DBMoto 6.6 Maintaining multiple database platform</a> <a title="October 2009 page 84" href="https://secure.viewer.zmags.com/publication/3a53a328?page=84"> INDUSTRY NEWS Bytes from the Blog www.sqlmag.co</a> <a title="October 2009 page 85" href="https://secure.viewer.zmags.com/publication/3a53a328?page=85"> DATABASE MONITORING Monitor SSAS with New Perform</a> <a title="October 2009 page 86" href="https://secure.viewer.zmags.com/publication/3a53a328?page=86"> The Michael Otey (motey@sqlmag.com</a> <a title="October 2009 page 87" href="https://secure.viewer.zmags.com/publication/3a53a328?page=87"> The complete performance solution </a> <a title="October 2009 page 88" href="https://secure.viewer.zmags.com/publication/3a53a328?page=88"> \MEKNQJW MATTERS (smallest is besti New! SQL Safe</a>