If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> Buyer's Guide: Database Encryption Solutions p. 41 | Product Review: DTS xChange p. 44<br /> A PENTON PUBLICATION<br /> September 2008<br /> INFSRIOGHMTAS MicImprleomesntiongft's<br /> SQL SERVER JOB TRACKING BI Platforpm. 12<br /> BI EXPERT<br /> Plugging the Gaps p.15<br /> REQUIRED READING<br /> SQL Server 2008's<br /> Filtered Indexes &<br /> Statistics p.21<br /> DataWarehouse<br /> Workloads & Use Cases<br /> p.25<br /> MICHELLE A.POOLET<br /> Desperately<br /> Seeking Samples<br /> p.27<br /> T-SQL 101<br /> Create & Use<br /> ViewsWisely p.31<br /> PREMIER<br /> BANKCARD'S<br /> SQL SERVER Q&A BI DIRECTOR,<br /> Ask the Experts RONVAN ZANTEN<br /> p.39 <a title="September 2008 page 1" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=1"> Buyer's Guide: Database Encryption Solutions p. 4</a> <a title="September 2008 page 2" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=2"> “30% INCREASE IN SPEED AND PERFORMANCE.” – Da</a> <a title="September 2008 page 3" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=3"> Every month, 23 million people use CareerBuilder.</a> <a title="September 2008 page 4" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=4"> "Get five top-selling SQL Server titles free when </a> <a title="September 2008 page 5" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=5"> WWW.SQLMAG.COM Contents </a> <a title="September 2008 page 6" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=6"> Change Management Backup and Recovery </a> <a title="September 2008 page 7" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=7"> Contents </a> <a title="September 2008 page 8" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=8"> Drag & Drop Data Conversion Check out Alt</a> <a title="September 2008 page 9" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=9"> EDITORIAL Demystifying SQL Server Virtuali</a> <a title="September 2008 page 10" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=10"> Experience the Power of Connections NOVEMBER 10-</a> <a title="September 2008 page 11" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=11"> TOP 10 TIPS </a> <a title="September 2008 page 12" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=12"> 5 Provide both drill-down navig</a> <a title="September 2008 page 13" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=13"> Get Rid of Gaps in Numerical Sequences It'hsacto</a> <a title="September 2008 page 14" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=14"> READER TO READER returns the first integer in </a> <a title="September 2008 page 15" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=15"> No servers run cooler. Fujitsu PRIMERGY® servers</a> <a title="September 2008 page 16" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=16"> COVER STORY Megan Bearly (m</a> <a title="September 2008 page 17" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=17"> COVER STORY Improve your access to meaningful d</a> <a title="September 2008 page 18" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=18"> COVER STORY Editor's Note Pre</a> <a title="September 2008 page 19" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=19"> Plugging the G·A·P·S in SQL Server JOB TRACKING</a> <a title="September 2008 page 20" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=20"> FEATURE SQL SERVER JOB-TRACKING SCRIPTS TABLE 1</a> <a title="September 2008 page 21" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=21"> D@D:7=3B97CD"',"+7F7?D;?@EB;?6ECDBI,7;J7D:</a> <a title="September 2008 page 22" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=22"> -;<DBC8?<8C88G8@E <@%4D/8:4DDA>7AFE4E 4EE8@788D>4</a> <a title="September 2008 page 23" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=23"> SQL SERVER JOB-TRACKING SCRIPTS FEATURE #JobSch</a> <a title="September 2008 page 24" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=24"> FEATURE SQL SERVER JOB-TRACKING SCRIPTS LISTING</a> <a title="September 2008 page 25" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=25"> Turn Business Intelligence Into Business Advantag</a> <a title="September 2008 page 26" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=26"> "SQL Backup™ makes us Exceptional. Don't be the e</a> <a title="September 2008 page 27" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=27"> Discover the Benets of FILT E R E D IND E X E </a> <a title="September 2008 page 28" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=28"> REQUIRED FILTERED INDEXES AND STATISTICSREADING </a> <a title="September 2008 page 29" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=29"> FILTERED INDEXES AND STATISTICS Figure 4</a> <a title="September 2008 page 30" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=30"> SQL Server Magazine Congratulates HP 20</a> <a title="September 2008 page 31" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=31"> DataWarehouse Workloads and Use Cases Determin</a> <a title="September 2008 page 32" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=32"> FEATURE DATA WAREHOUSE WORKLOADS AND USE CASES </a> <a title="September 2008 page 33" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=33"> 'AH7?47D 2008 LAS VEGAS, NV #1>41</a> <a title="September 2008 page 34" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=34"> JOIN US! Connections is the HOTTEST show on the </a> <a title="September 2008 page 35" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=35"> IT’S ALL HERE NOVEMBER 10-13, 2008 • LAS VEGAS,</a> <a title="September 2008 page 36" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=36"> SQL SERVER • MICROSOF T DAY ,-(+ ,/"' ,0"-! </a> <a title="September 2008 page 37" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=37"> "@F:;EE7EE;A@I7R>>>AA=3F835FADEEG5:3E ;@5A?B3F;4;</a> <a title="September 2008 page 38" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=38"> SQL SERVER SESSIONS ,/ +(.)"' ,-,'&+ "' ,*%,+</a> <a title="September 2008 page 39" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=39"> SSWUG ,,0. ,-+-"' '0)(,"-"(' ())- ,F3DF;@93@7I<A</a> <a title="September 2008 page 40" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=40"> SHAREPOINT • MICROSO FT DAY '(-#.,-,)+,!-,&"+(</a> <a title="September 2008 page 41" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=41"> !0"' (%,,0(+$%(0, -("'()-!(+&,(%.-"(', ,((* 7B>AK</a> <a title="September 2008 page 42" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=42"> SHAREPOINT SESSIONS !+."%"' -!)+- ,!+)("'-+&0%</a> <a title="September 2008 page 43" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=43"> F7@F;E?AH768DA?3@3GF:AD;@9E;F7FA3EF39;@9E;F7 3@6F</a> <a title="September 2008 page 44" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=44"> MICROSOFT ASP.NET • M ICROSOFT DAY AttendMicros</a> <a title="September 2008 page 45" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=45"> VISUAL STUDIO & .NET • MICROSOFT DAY !(0-(+/"02</a> <a title="September 2008 page 46" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=46"> OPENFORCE SESSIONS Connectionsintroducesyoutoac</a> <a title="September 2008 page 47" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=47"> IT EVENT • OCT ‘08 (-(+ ,'+'",(&++"(-- ,'+'</a> <a title="September 2008 page 48" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=48"> PRE-CONFERENCE WORK NOVEMBER 9, 2008 </a> <a title="September 2008 page 49" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=49"> GE;@9%"'*FA@F;F;7E3@6@F;FK,*%I;F:(4<75F,7DH;57E</a> <a title="September 2008 page 50" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=50"> NOVEMBER 14, 2008 SQL SERVER </a> <a title="September 2008 page 51" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=51"> POST-CO 83;D>K8G@63?7@F3>5A@57BFE:3H7477@AH7D></a> <a title="September 2008 page 52" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=52"> CheckWebsiteforMicrosoft andadditionalspeakers. S</a> <a title="September 2008 page 53" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=53"> ANOTHER GREAT EVENT BROUGHT TO YO U BY DEVCONNE</a> <a title="September 2008 page 54" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=54"> HOTEL INFORMATION MANDALAY BAY RESORT </a> <a title="September 2008 page 55" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=55"> '& </a> <a title="September 2008 page 56" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=56"> CO-LOCATED WITH: 'AH7?47D 2008 LA</a> <a title="September 2008 page 57" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=57"> Desperately Seeking SAMPLES Sample databases </a> <a title="September 2008 page 58" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=58"> FEATURE SAMPLE DATABASES WHERE INTHE WORLD ARE P</a> <a title="September 2008 page 59" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=59"> production, and AdventureWorks is a sample databa</a> <a title="September 2008 page 60" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=60"> FEATURE SAMPLE DATABASES from sample databases </a> <a title="September 2008 page 61" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=61"> T-SQL 101: VIEWS </a> <a title="September 2008 page 62" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=62"> FEATURE T-SQL 101 LISTING 1: Code to Create th</a> <a title="September 2008 page 63" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=63"> T-SQL 101 FEATURE SELECT Movie,Genre, Stars</a> <a title="September 2008 page 64" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=64"> FEATURE T-SQL 101 Indexed Views vs. Regular View</a> <a title="September 2008 page 65" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=65"> Master SharePoint with 3Info-pa</a> <a title="September 2008 page 66" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=66"> </a> <a title="September 2008 page 67" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=67"> .INFRASTRUCTURE LOG _DAY 48: This is ridiculous</a> <a title="September 2008 page 68" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=68"> EXPERT SPEAKERS  IN-DEPTH SESSIONS  UNPARALLELE</a> <a title="September 2008 page 69" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=69"> Questions & Answers Get help from the pros Q: I </a> <a title="September 2008 page 70" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=70"> OntheScentto Your New </a> <a title="September 2008 page 71" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=71"> Database Encryption Solutions Protect your databa</a> <a title="September 2008 page 72" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=72"> BUYER'S DATABASE ENCRYPTION SOLUTIONSGUIDE Ke</a> <a title="September 2008 page 73" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=73"> DATABASE ENCRYPTION SOLUTIONS BUYER'S GUIDE leve</a> <a title="September 2008 page 74" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=74"> PRODUCT REVIEW DTS xChange This tool provides a</a> <a title="September 2008 page 75" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=75"> INDUSTRY NEWS Bytes from the Blog www.sqlmag.co</a> <a title="September 2008 page 76" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=76"> NEW PRODUCTS Editor's Tip Got a great ne</a> <a title="September 2008 page 77" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=77"> MARKETPLACE September 2008 47 Advertiser Inde</a> <a title="September 2008 page 78" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=78"> The ACKPage T-SQL Enhancements in SQL Server 200</a> <a title="September 2008 page 79" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=79"> Achieve Ultimate Microsoft® SQL Server® Per</a> <a title="September 2008 page 80" href="https://secure.viewer.zmags.com/publication/f428bf2e?page=80"> 24 x 7 Hands-Free SQL Server Index Defragmentatio</a>