<br />
Michael Otey Editorial: NoSQL? No Way! P. 5<br />
October 2010<br />
|\<br />
r<br />
iiniiif 1/ ?? Haul<br />
newer /our CJutKHioiKi<br />
i!r and hlurt?<br />
p.ll<br />
s<br />
If<br />
Use<br />
Your!<br />
r0-:r,<br />
Exploring<br />
Databese<br />
rKfrroringi<br />
in SQL Server 2008*<br />
/<br />
yJilo^^jjaJyaj:<br />
k<br />
Smarter technology for a Smarter Planet:<br />
It's time to ask smarter questions.<br />
What exactly does a benchmark mean? For the last five years, IBM DB2?? on Power Systems'' has ranked<br />
first on three of the industry's leading performance benchmarks, longer than Oracle and Microsoft combined.1<br />
But shouldn't we be asking our IT to deliver more than just raw performance? What really matters isn't some<br />
abstract measure of performance, it's what companies actually do with it. For instance, Coca-Cola Bottling<br />
Company is using DB2 on Power to reduce licensing, maintenance and storage fees by<a title="October 2010 page 1" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=1"> Michael Otey Editorial: NoSQL? No Way! P. 5 Octo</a>
<a title="October 2010 page 2" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=2"> Smarter technology for a Smarter Planet: It's ti</a>
<a title="October 2010 page 3" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=3"> WWW.SQLMAG.COM Contents </a>
<a title="October 2010 page 4" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=4"> // // VISION SOLUTIONS WELCOMES DOUBLE-TAKE </a>
<a title="October 2010 page 5" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=5"> Contents </a>
<a title="October 2010 page 6" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=6"> Report generation is finally easy - and affordabl</a>
<a title="October 2010 page 7" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=7"> NoSQL? No Way! One trend gaining traction in web</a>
<a title="October 2010 page 8" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=8"> Ct{ Filling the gaping hole left by Microsoft's </a>
<a title="October 2010 page 9" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=9"> Execute a Stored Procedure Within a Query OPENR</a>
<a title="October 2010 page 10" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=10"> READER TO READER Example 2: A complex SELE</a>
<a title="October 2010 page 11" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=11"> Microsoft Network Monitor Capture, view, and anal</a>
<a title="October 2010 page 12" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=12"> TOOL TIME recommends you refrain from runnin</a>
<a title="October 2010 page 13" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=13"> Can I Restore My Enterprise Edition Database on A</a>
<a title="October 2010 page 14" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=14"> SQL SERVER QUESTIONS ANSWERED Determining How L</a>
<a title="October 2010 page 15" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=15"> with Resources from Left-Brain.com Left-Brain.co</a>
<a title="October 2010 page 16" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=16"> COVER STORY in SQL Server 2008 R</a>
<a title="October 2010 page 17" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=17"> DATABASE MIRRORING IN SQL SERVER 2008 R2 CO</a>
<a title="October 2010 page 18" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=18"> COVER STORY DATABASE MIRRORING IN SQL SERVER 2008</a>
<a title="October 2010 page 19" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=19"> DATABASE MIRRORING IN SQL SERVER 2008 R2 COV</a>
<a title="October 2010 page 20" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=20"> COVER STORY DATABASE MIRRORING IN SQL SERVER 2008</a>
<a title="October 2010 page 21" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=21"> Subscribe Now to the New r Dev Connections (f</a>
<a title="October 2010 page 22" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=22"> a 181 IHnffl QUESTIONS ANSWERED ??? STRATEGY DEF</a>
<a title="October 2010 page 23" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=23"> MARCH 27-30, 2011 ORLANDO, FL MANDALAY BAY RESO</a>
<a title="October 2010 page 24" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=24"> xchange 2010 Maestro rkshop ^^ DATES & LOCATION</a>
<a title="October 2010 page 25" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=25"> FEATURE Query Filters Based on Number of Rows and</a>
<a title="October 2010 page 26" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=26"> FEATURE QUERY FILTERS SELECT orderid, orderd</a>
<a title="October 2010 page 27" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=27"> Here you're guaranteed both to get the three orde</a>
<a title="October 2010 page 28" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=28"> FEATURE QUERY FILTERS TOP—even if SQL Server a</a>
<a title="October 2010 page 29" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=29"> FEATURE SQL Server Virtualization and Availabi</a>
<a title="October 2010 page 30" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=30"> FEATURE VIRTUALIZATION AND AVAILABILITY 2008-B</a>
<a title="October 2010 page 31" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=31"> VIRTUALIZATION AND AVAILABILITY FEATURE their </a>
<a title="October 2010 page 32" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=32"> No Budget for Travel? No Problem! Get the traini</a>
<a title="October 2010 page 33" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=33"> FEATURE Using Performance Profiler to Troublesh</a>
<a title="October 2010 page 34" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=34"> FEATURE PERFORMANCE PROFILER CREATING A SAMPLE A</a>
<a title="October 2010 page 35" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=35"> To get to where you can access this type o</a>
<a title="October 2010 page 36" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=36"> FEATURE PERFORMANCE PROFILER sample AdventureW</a>
<a title="October 2010 page 37" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=37"> up taking longer because of how many times the da</a>
<a title="October 2010 page 38" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=38"> WINDOWS IT PRO VIP is Educational???with FREE eL</a>
<a title="October 2010 page 39" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=39"> FEATURE Build a Cube to Perform Scenario-Based R</a>
<a title="October 2010 page 40" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=40"> FEATURE SCENARIO-BASED RISK ANALYSIS The o</a>
<a title="October 2010 page 41" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=41"> SCENARIO-BASED RISK ANALYSIS FEATURE on the da</a>
<a title="October 2010 page 42" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=42"> FEATURE SCENARIO-BASED RISK ANALYSIS TABLE 4: R</a>
<a title="October 2010 page 43" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=43"> SCENARIO-BASED RISK ANALYSIS FEATURE If</a>
<a title="October 2010 page 44" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=44"> with Resources from Left-Brain.com Left-Brain.co</a>
<a title="October 2010 page 45" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=45"> INDUSTRY BYTES SavvyAssistants Your guide to spon</a>
<a title="October 2010 page 46" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=46"> INDUSTRY BYTES Mark K</a>
<a title="October 2010 page 47" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=47"> INDUSTRY BYTES When NoSQL Works Better than SQL</a>
<a title="October 2010 page 48" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=48"> INDUSTRY BYTES Shei</a>
<a title="October 2010 page 49" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=49"> DATABASE ADMINISTRATION ActiveBatch Expands Jobs </a>
<a title="October 2010 page 50" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=50"> The ACKPage B Visual Studio 2010 Express Produ</a>
<a title="October 2010 page 51" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=51"> WHAT AREN'T YOU SEEING? SQL SENTRY CAN IDENTIFY </a>
<a title="October 2010 page 52" href="https://secure.viewer.zmags.com/publication/b0a5fd2e?page=52"> THIS DOCTOR MAKES HOUSE CALLS! QL doctor The C</a>