If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> PRODUCT REVIEWS: Red Gate’s SQL Compare p. 42 | DBNitro’s SQL Nitro p. 43<br /> October 2008<br /> p. 16<br /> ITZIK BEN-GAN<br /> QUERY<br /> Temporal Data p. 21<br /> AUTOMATE<br /> Error Log Checking p. 25<br /> DATA LOGGING<br /> MANAGE, MONITOR,<br /> &TROUBLESHOOT Packages p. 31<br /> GENERATE Server-SideTraces p. 35<br /> T-SQL 101<br /> Aggregate, Rowset, & Scalar FUNCTIONS p. 37<br /> TOOL TIME<br /> MANAGE Remote Connections p. 14<br /> A PENTON PUBLICATIONPRODUCT REVIEWS: Red Gate's SQL Compare P. 42 DBNitro's SQL Nitro P. 43<br /> The Smart Guide to Building World-Class Applications<br /> www.sqlmag.com Events: www.sqlconnections.com<br /> ERVER<br /> i n<br /> October 2008<br /> Multi-<br /> ai<br /> ??WHfl??l<br /> Dimensional<br /> ITZIK BEN-GAN<br /> QUERY<br /> Temporal Data p. 2<br /> AUTOMATE<br /> Error Log Checking p. 25<br /> DATA LOGGING<br /> MANAGE, MONITOR,<br /> &TROUBLESHOOT Packages p. 3<br /> GENER<a title="October 2008 page 1" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=1"> PRODUCT REVIEWS: Red Gate’s SQL Compare p. 42 |</a> <a title="October 2008 page 2" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=2"> “30% INCREASE IN SPEED AND PERFORMANCE.” – Da</a> <a title="October 2008 page 3" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=3"> Every month, 23 million people use CareerBuilder.</a> <a title="October 2008 page 4" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=4"> EMBARCADERO TECHNOLOGIES* You have one hour to r</a> <a title="October 2008 page 5" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=5"> WWW.SQLMAG.COM Contents </a> <a title="October 2008 page 6" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=6"> Change Management Backup and Recovery </a> <a title="October 2008 page 7" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=7"> Contents </a> <a title="October 2008 page 8" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=8"> Discover database independence Experience</a> <a title="October 2008 page 9" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=9"> SQL Server 2008:Which Edition Is Right forYou? L</a> <a title="October 2008 page 10" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=10"> READER TO READER Shaunt Khaldti</a> <a title="October 2008 page 11" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=11"> YOU CHOOSE. GET TO WHERE YOU WANT TO BE — </a> <a title="October 2008 page 12" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=12"> READER TO READER Eli Leiba FindWeak Database Pa</a> <a title="October 2008 page 13" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=13"> Turn Business Intelligence Into Business Advantag</a> <a title="October 2008 page 14" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=14"> "SQL Backup™ makes us Exceptional. Don't be the e</a> <a title="October 2008 page 15" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=15"> COMMUNITY DIALOG Sqlmag.com Community Dial</a> <a title="October 2008 page 16" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=16"> TOOL TIME Kevin Kline (ke</a> <a title="October 2008 page 17" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=17"> A S P S PASS Community Summit 2008 November 1</a> <a title="October 2008 page 18" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=18"> COVER STORY William Sheldon (bsheldon</a> <a title="October 2008 page 19" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=19"> COVER STORY Create and use multidimensional que</a> <a title="October 2008 page 20" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=20"> COVER STORY ADOMD.NET MDX QU</a> <a title="October 2008 page 21" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=21"> DataGridView1.DataSource = ds.Tables(0) At</a> <a title="October 2008 page 22" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=22"> COVER STORY ADOMD.NET </a> <a title="October 2008 page 23" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=23"> 'AH7?47D 2008 LAS VEGAS, NV #1>41</a> <a title="October 2008 page 24" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=24"> JOIN US! Connections is the HOTTEST show on the </a> <a title="October 2008 page 25" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=25"> IT’S ALL HERE NOVEMBER 10-13, 2008 • LAS VEGAS,</a> <a title="October 2008 page 26" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=26"> SQL SERVER • MICROSOF T DAY *,''&)+&)*'+ #+ % </a> <a title="October 2008 page 27" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=27"> "@F:;EE7EE;A@I7R>>>AA=3F835FADEEG5:3E ;@5A?B3F;4;</a> <a title="October 2008 page 28" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=28"> SQL SERVER SESSIONS *-)&,' %*+*%$) % *(#*)-) *</a> <a title="October 2008 page 29" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=29"> SSWUG **.,*+)+ %%.'&* + &% ())- ,F3DF;@93@7I<A45</a> <a title="October 2008 page 30" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=30"> SHAREPOINT • MICROSO FT DAY # +,'0&,)*)'& %+.*</a> <a title="October 2008 page 31" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=31"> . %&#**.&)"#&.* +& %&'+&)$*&#,+ &%* ,((* 7B>AK;@9</a> <a title="October 2008 page 32" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=32"> SHAREPOINT SESSIONS ), # %+')+ *)'& %+)$.#"+)&</a> <a title="October 2008 page 33" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=33"> F7@F;E?AH768DA?3@3GF:AD;@9E;F7FA3EF39;@9E;F7 3@6F</a> <a title="October 2008 page 34" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=34"> MICROSOFT ASP.NET • M ICROSOFT DAY AttendMicros</a> <a title="October 2008 page 35" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=35"> VISUAL STUDIO & .NET • MICROSOFT DAY &.+&)- .0&</a> <a title="October 2008 page 36" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=36"> OPENFORCE SESSIONS Connectionsintroducesyoutoac</a> <a title="October 2008 page 37" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=37"> IT EVENT • OCT ‘08 &+&) *%)% *&$)) &++ *%)%</a> <a title="October 2008 page 38" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=38"> PRE-CONFERENCE WORK NOVEMBER 9, 2008 </a> <a title="October 2008 page 39" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=39"> GE;@9%"'*FA@F;F;7E3@6@F;FK,*%I;F:(4<75F,7DH;57E</a> <a title="October 2008 page 40" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=40"> NOVEMBER 14, 2008 SQL SERVER </a> <a title="October 2008 page 41" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=41"> POST-CO 83;D>K8G@63?7@F3>5A@57BFE:3H7477@AH7D></a> <a title="October 2008 page 42" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=42"> CheckWebsiteforMicrosoft andadditionalspeakers. S</a> <a title="October 2008 page 43" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=43"> ANOTHER GREAT EVENT BROUGHT TO YO U BY DEVCONNE</a> <a title="October 2008 page 44" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=44"> HOTEL INFORMATION MANDALAY BAY RESORT </a> <a title="October 2008 page 45" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=45"> '& </a> <a title="October 2008 page 46" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=46"> CO-LOCATED WITH: 'AH7?47D 2008 LA</a> <a title="October 2008 page 47" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=47"> QuTerey mporal DATA Work around SQL Server’s inc</a> <a title="October 2008 page 48" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=48"> FEATURE TEMPORAL DATA TABLE 1: Desired Results</a> <a title="October 2008 page 49" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=49"> TABLE 4: Solution 1, Output of Query Dening Inte</a> <a title="October 2008 page 50" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=50"> Celebrate th</a> <a title="October 2008 page 51" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=51"> AuSAQtLuoAtmuotmaotmaetaete SERVER Error Lo</a> <a title="October 2008 page 52" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=52"> FEATURE </a> <a title="October 2008 page 53" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=53"> @HasWritePermissionOnClient is a bit value t</a> <a title="October 2008 page 54" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=54"> GIANTLEAPS. SMALL FOOTPRINTS. With the world’s da</a> <a title="October 2008 page 55" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=55"> </a> <a title="October 2008 page 56" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=56"> FEATURE ERROR LOG CHECKING </a> <a title="October 2008 page 57" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=57"> SSIS LOGGING and DATA AUDITING Set up a</a> <a title="October 2008 page 58" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=58"> FEATURE SSIS LOGGING AND DATA AUDITING </a> <a title="October 2008 page 59" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=59"> SSIS LOGGING AND DATA AUDITING FEATURE </a> <a title="October 2008 page 60" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=60"> FEATURE SSIS LOGGING AND DATA AUDITING that in</a> <a title="October 2008 page 61" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=61"> FEATURE Generating Server-SideTraces See how e</a> <a title="October 2008 page 62" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=62"> FEATURE SERVER-SIDE TRACES LISTING 4: The sp_t</a> <a title="October 2008 page 63" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=63"> FEATURE T-SQL 101: Built-In Functions In Lesso</a> <a title="October 2008 page 64" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=64"> FEATURE T-SQL 101 DATENAME. Now let’s say y</a> <a title="October 2008 page 65" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=65"> T-SQL 101 FEATURE integer_exp is an integer</a> <a title="October 2008 page 66" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=66"> FEATURE T-SQL 101 </a> <a title="October 2008 page 67" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=67"> SharpenYour Basic SQL Server Skills 7 guidelines </a> <a title="October 2008 page 68" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=68"> PRODUCT REVIEW SQL Compare 6.2 </a> <a title="October 2008 page 69" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=69"> SQL Nitro 2.0 DBpeNrfiotrom’saSnQceLoNf iytorour</a> <a title="October 2008 page 70" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=70"> BI•lateral bē-ī la-t(ə-)rəl (adj.): of or relatin</a> <a title="October 2008 page 71" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=71"> BUSINESS PERFORMANCE Smart Financial Performance </a> <a title="October 2008 page 72" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=72"> INDUSTRY NEWS Bytes from the Blog www.sqlmag.co</a> <a title="October 2008 page 73" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=73"> Connecting readers with the products and ser</a> <a title="October 2008 page 74" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=74"> The Michael Otey (motey@sqlmag.com</a> <a title="October 2008 page 75" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=75"> The New StandardinMonitoring and Performance </a> <a title="October 2008 page 76" href="https://secure.viewer.zmags.com/publication/a1fb9eee?page=76"> OVER 10,000 “Our auditors visit quarterly and hav</a>