If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> Michael Otey's Editorial: Will the Cloud Kill Virtualization? p. 4<br /> A PENTON PUBLICATION<br /> December 2010<br /> The Smart Guide to Building World-Class Applications<br /> Our Favorites and Yours Recognized in the<br /> Editors' Best and Community Choice Awards p. 16<br /> >Itzik Ben-Gan<br /> Exploring the Missing Row Value<br /> Constructor Functionality p. 25<br /> >Part 2:<br /> The Smart DBA's Guide to<br /> SQL Server Disaster Recovery p. 31<br /> Using Table-Valued Parameters to<br /> Multiple Rows p. 37<br /> Securing Credit Card Data<br /> in SQL Server 2008 p. 41<br /> UpdateMichael Otey's Editorial: Will the Cloud Kill Visualization? p. 4<br /> December 2010<br /> The Smart Guide to Building World-Class Applications<br /> Our Favorites and Yours Recognized in the<br /> Editors' Best and Community Choice Awards P. u<br /> H[y?l!liMlarE.iiM<br /> Exploring the Missing Row Value<br /> C<a title="December 2010 page 1" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=1"> Michael Otey's Editorial: Will the Cloud Kill Vir</a> <a title="December 2010 page 2" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=2"> marter technology for a Smarter PI What 99.9% sy</a> <a title="December 2010 page 3" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=3"> WWW.SQLMAG.COM Contents </a> <a title="December 2010 page 4" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=4"> Those who can envision a plausible future that's</a> <a title="December 2010 page 5" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=5"> Contents </a> <a title="December 2010 page 6" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=6"> EDITORIAL Michael Otey (motey@sql</a> <a title="December 2010 page 7" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=7"> Shipley p.scou- ENHANCED SECURITY FOR MICROSOF</a> <a title="December 2010 page 8" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=8"> SQLServer March 27-30, 2011 JOIN US! ORLANDO, </a> <a title="December 2010 page 9" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=9"> READER TO READER </a> <a title="December 2010 page 10" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=10"> READER TO READER existing backup files, specify</a> <a title="December 2010 page 11" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=11"> TOOL TIME SQL Server 2008 Spatial Tools Two e</a> <a title="December 2010 page 12" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=12"> SQL Server Magazine Congratulates Confio nite8 </a> <a title="December 2010 page 13" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=13"> Turn Up the Heat on SQL Server Performance i Sj</a> <a title="December 2010 page 14" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=14"> Subscribe Now to the New r Dev Connections Re</a> <a title="December 2010 page 15" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=15"> The Cause of Fragmentation from Using Snapshot Is</a> <a title="December 2010 page 16" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=16"> SQL SERVER QUESTIONS ANSWERED The default fi</a> <a title="December 2010 page 17" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=17"> CREATE NONCLUSTERED INDEX NC2 ON T1 (col5, </a> <a title="December 2010 page 18" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=18"> COVER STORY SQL Server Magazine </a> <a title="December 2010 page 19" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=19"> COVER STORY The polls have closed! </a> <a title="December 2010 page 20" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=20"> COVER STORY EDITORS' BEST AND COMMUNITY CHOI</a> <a title="December 2010 page 21" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=21"> DISCOVER WINDOWS IT PRO VIP Windows IT Pro VIP i</a> <a title="December 2010 page 22" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=22"> COVER STORY EDITORS' BEST AND COMMUNITY CHOI</a> <a title="December 2010 page 23" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=23"> EDITORS' BEST AND COMMUNITY CHOICE AWARDS COVER S</a> <a title="December 2010 page 24" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=24"> COVER STORY EDITORS' BEST AND COMMUNITY CHOI</a> <a title="December 2010 page 25" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=25"> SQL Server Magazine Congratulates i SQL Server M</a> <a title="December 2010 page 26" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=26"> with Resources from Left-Brain.com Left-Brain.co</a> <a title="December 2010 page 27" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=27"> FEATURE Row Value Constructor readable, and ea</a> <a title="December 2010 page 28" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=28"> FEATURE ROW VALUE CONSTRUCTOR LISTING 1: Code t</a> <a title="December 2010 page 29" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=29"> ROW VALUE CONSTRUCTOR FEATURE Fi</a> <a title="December 2010 page 30" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=30"> FEATURE ROW VALUE CONSTRUCTOR Greater than or </a> <a title="December 2010 page 31" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=31"> proposed MAX of a row value constructor is simila</a> <a title="December 2010 page 32" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=32"> # PROUD TO ANNOUNCE: Recipient of the Eloqua M</a> <a title="December 2010 page 33" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=33"> The Smart DBA's Guide to SQL Server Disaster Rec</a> <a title="December 2010 page 34" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=34"> FEATURE SQL SERVER DISASTER RECOVERY consuming</a> <a title="December 2010 page 35" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=35"> SQL SERVER DISASTER RECOVERY FEATURE are the k</a> <a title="December 2010 page 36" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=36"> FEATURE SQL SERVER DISASTER RECOVERY BASELINE CH</a> <a title="December 2010 page 37" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=37"> roducing the new Microsoft Certified Master: SQL </a> <a title="December 2010 page 38" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=38"> Join the SharePoint Expert Community SharePointP</a> <a title="December 2010 page 39" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=39"> FEATURE Table-Valued Parameters Update </a> <a title="December 2010 page 40" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=40"> FEATURE USING TABLE-VALUED PARAMETERS LISTING 2</a> <a title="December 2010 page 41" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=41"> USING TABLE-VALUED PARAMETERS FEATURE file, as</a> <a title="December 2010 page 42" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=42"> with Resources from Left-Brain.com Left-Brain.</a> <a title="December 2010 page 43" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=43"> FEATURE Credit Card Data Take advantage</a> <a title="December 2010 page 44" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=44"> FEATURE SECURING CREDIT CARD DATA 12. Main</a> <a title="December 2010 page 45" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=45"> 3 events, 1 location - choose from sessions on </a> <a title="December 2010 page 46" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=46"> FEATURE SECURING CREDIT CARD DATA Additionally</a> <a title="December 2010 page 47" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=47"> Develop Secure Applications This one seems obviou</a> <a title="December 2010 page 48" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=48"> FEATURE SECURING CREDIT CARD DATA ยท 8.5.1: Cont</a> <a title="December 2010 page 49" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=49"> Performance monitoring and tuning doesn't have </a> <a title="December 2010 page 50" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=50"> The ACKPage B 5 FAQs on SQL Server 2008 R2 Para</a> <a title="December 2010 page 51" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=51"> 'S SLOWING YOU DOWN? IT MIGHT BE MORE OBVIOUS TH</a> <a title="December 2010 page 52" href="https://secure.viewer.zmags.com/publication/84b8fceb?page=52"> THIS DOCTOR MAKES HOUSE CALLS! SQL 9 9 ctor </a>