<br />
Performance Advisor for SQL Server 5.5 p. 35<br />
7<br />
VOI<br />
June 201 I<br />
The Smart Guide to Building World-Class Applications<br />
i b z J n<br />
Investigate Backup and<br />
Restore Options P. 12<br />
Checkpoints<br />
in SQL Server<br />
Integration<br />
Services<br />
n 71<br />
SSIS<br />
ader<br />
ages p. 7<br />
>Kimberly Tripp and Paul Randal<br />
SQL Server Q&A p. 10<br />
Sequences in<br />
SQL Server Denali,<br />
Part 2 p. 17<br />
Reduce Overhead<br />
with Minimal Logging p. 29<br />
Extend T-SQL Functionality<br />
- with CLRp.3l<br />
>7 Best Practices<br />
SQL ServiF on Hyper-V p. 40<br />
Let's talk optimizing applications,<br />
not just servers.<br />
Windows Server is changing<br />
the conversation.<br />
Windows Server Hyper-V and System Center let you manaqe your Scan our ta9<br />
. , . . xt \ ??? <a title="June 2011 page 1" href="https://secure.viewer.zmags.com/publication/e94d9378?page=1"> Performance Advisor for SQL Server 5.5 p. 35 7 </a>
<a title="June 2011 page 2" href="https://secure.viewer.zmags.com/publication/e94d9378?page=2"> Let's talk optimizing applications, not just ser</a>
<a title="June 2011 page 3" href="https://secure.viewer.zmags.com/publication/e94d9378?page=3"> WWW.SQLMAG.COM Contents </a>
<a title="June 2011 page 4" href="https://secure.viewer.zmags.com/publication/e94d9378?page=4"> integrate Data Quality Into Your SSIS Workflow </a>
<a title="June 2011 page 5" href="https://secure.viewer.zmags.com/publication/e94d9378?page=5"> Contents </a>
<a title="June 2011 page 6" href="https://secure.viewer.zmags.com/publication/e94d9378?page=6"> I jam m Create cutting edge reports with t</a>
<a title="June 2011 page 7" href="https://secure.viewer.zmags.com/publication/e94d9378?page=7"> Microsoft's Push Toward IT Automation At this </a>
<a title="June 2011 page 8" href="https://secure.viewer.zmags.com/publication/e94d9378?page=8"> SQLServer O raro Microsoft* Visual Studio </a>
<a title="June 2011 page 9" href="https://secure.viewer.zmags.com/publication/e94d9378?page=9"> A Simple But Effective Way to Tell Whether a File</a>
<a title="June 2011 page 10" href="https://secure.viewer.zmags.com/publication/e94d9378?page=10"> READER TO READER LISTING 1: The New ScriptMain C</a>
<a title="June 2011 page 11" href="https://secure.viewer.zmags.com/publication/e94d9378?page=11"> 1,000 Oracle/Sun clients recently upgraded. To</a>
<a title="June 2011 page 12" href="https://secure.viewer.zmags.com/publication/e94d9378?page=12"> SQL SERVER QUESTIONS ANSWERED Paul </a>
<a title="June 2011 page 13" href="https://secure.viewer.zmags.com/publication/e94d9378?page=13"> SQL SERVER QUESTIONS ANSWERED business had reform</a>
<a title="June 2011 page 14" href="https://secure.viewer.zmags.com/publication/e94d9378?page=14"> COVER STORY Advanced BACKUP and RESTORE Opti</a>
<a title="June 2011 page 15" href="https://secure.viewer.zmags.com/publication/e94d9378?page=15"> RESTORE command with both the CHECKSUM and VERIF</a>
<a title="June 2011 page 16" href="https://secure.viewer.zmags.com/publication/e94d9378?page=16"> COVER STORY BACKUP AND RESTORE the MAXTRANSFER</a>
<a title="June 2011 page 17" href="https://secure.viewer.zmags.com/publication/e94d9378?page=17"> log.” This restore operation uses both the STOPAT</a>
<a title="June 2011 page 18" href="https://secure.viewer.zmags.com/publication/e94d9378?page=18"> Paul Thurrott... ??? ... he's not in Microsoft</a>
<a title="June 2011 page 19" href="https://secure.viewer.zmags.com/publication/e94d9378?page=19"> FEATURE Sequences, Part 2 More flexible than IDE</a>
<a title="June 2011 page 20" href="https://secure.viewer.zmags.com/publication/e94d9378?page=20"> FEATURE SEQUENCES, PART 2 time window is very </a>
<a title="June 2011 page 21" href="https://secure.viewer.zmags.com/publication/e94d9378?page=21"> / J j Compare a synchroniz SQL Server scher</a>
<a title="June 2011 page 22" href="https://secure.viewer.zmags.com/publication/e94d9378?page=22"> FEATURE SEQUENCES, PART 2 LISTING 1: Code to Cr</a>
<a title="June 2011 page 23" href="https://secure.viewer.zmags.com/publication/e94d9378?page=23"> without generating the sequence values—to give yo</a>
<a title="June 2011 page 24" href="https://secure.viewer.zmags.com/publication/e94d9378?page=24"> FEATURE SEQUENCES, PART 2 RELATED ARTICLES For m</a>
<a title="June 2011 page 25" href="https://secure.viewer.zmags.com/publication/e94d9378?page=25"> FEATURE Use Checkpoints to Restart Failed S</a>
<a title="June 2011 page 26" href="https://secure.viewer.zmags.com/publication/e94d9378?page=26"> FEATURE SSIS CHECKPOINTS the problem that prev</a>
<a title="June 2011 page 27" href="https://secure.viewer.zmags.com/publication/e94d9378?page=27"> Now fix the package by changing the Flag vari</a>
<a title="June 2011 page 28" href="https://secure.viewer.zmags.com/publication/e94d9378?page=28"> FEATURE SSIS CHECKPOINTS becau</a>
<a title="June 2011 page 29" href="https://secure.viewer.zmags.com/publication/e94d9378?page=29"> Figure 7 Results when using checkpoints inside a </a>
<a title="June 2011 page 30" href="https://secure.viewer.zmags.com/publication/e94d9378?page=30"> THE CONVERSATION BEGINS HERE Microsoft Visual S</a>
<a title="June 2011 page 31" href="https://secure.viewer.zmags.com/publication/e94d9378?page=31"> FEATURE Demystifying Minimal Logging Perform</a>
<a title="June 2011 page 32" href="https://secure.viewer.zmags.com/publication/e94d9378?page=32"> FEATURE MINIMAL LOGGING TABLE 1: Comparing Mini</a>
<a title="June 2011 page 33" href="https://secure.viewer.zmags.com/publication/e94d9378?page=33"> File Operations Made Easy Use CLR to extend T-SQL</a>
<a title="June 2011 page 34" href="https://secure.viewer.zmags.com/publication/e94d9378?page=34"> FEATURE FILE OPERATIONS DeleteFile. When yo</a>
<a title="June 2011 page 35" href="https://secure.viewer.zmags.com/publication/e94d9378?page=35"> which isn't easily interpreted. To make sense of </a>
<a title="June 2011 page 36" href="https://secure.viewer.zmags.com/publication/e94d9378?page=36"> FEATURE FILE OPERATIONS LISTING 6: CreateFileCl</a>
<a title="June 2011 page 37" href="https://secure.viewer.zmags.com/publication/e94d9378?page=37"> Performance Advisor for SQL Server 5.5 Given how</a>
<a title="June 2011 page 38" href="https://secure.viewer.zmags.com/publication/e94d9378?page=38"> </a>
<a title="June 2011 page 39" href="https://secure.viewer.zmags.com/publication/e94d9378?page=39"> Users Want Mobile BI Platforms Blair Gre</a>
<a title="June 2011 page 40" href="https://secure.viewer.zmags.com/publication/e94d9378?page=40"> NEW PRODUCTS Editor's Tip Got a </a>
<a title="June 2011 page 41" href="https://secure.viewer.zmags.com/publication/e94d9378?page=41"> No Budget for Travel? No Problem! Get the traini</a>
<a title="June 2011 page 42" href="https://secure.viewer.zmags.com/publication/e94d9378?page=42"> The ACKPage B 7 Best Practices for Running SQL</a>
<a title="June 2011 page 43" href="https://secure.viewer.zmags.com/publication/e94d9378?page=43"> Sentry Performance Advisor for SQL Server Best</a>
<a title="June 2011 page 44" href="https://secure.viewer.zmags.com/publication/e94d9378?page=44"> SQL doctor point, click, cure. SCHEDULE REGULAR</a>