If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> Database-Monitoring Products Compared p.38 | VS Team Data p.48<br /> A PENTON PUBLICATION<br /> The Smart Guide to Building World-Class Applications<br /> www.sqlmag.com ■ Events: www.sqlconnections.com<br /> April 2007<br /> p. 12<br /> Move Your Cubes:<br /> Analysis Services 2000 to 2005<br /> p. 33<br /> BLOBs and CLOBs:<br /> Don't Be Afraid<br /> p. 17<br /> Excel 2007:<br /> Power to the PivotTables<br /> p. 25<br /> Reader to Reader:<br /> Pinpoint Problematic<br /> Processes<br /> p. 9<br /> Kalen Delaney:<br /> Query Tuning<br /> p. 29Database-Monitoring Products Compared<br /> US Team Data<br /> el 2007:<br /> Power to the PivotTables<br /> Reader to Reader:<br /> Pinpoint Problematic<br /> Processes<br /> 1%<br /> Number of extra outdoor hours you gained<br /> thi<a title="April 2007 page 1" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=1"> Database-Monitoring Products Compared p.38 | VS T</a> <a title="April 2007 page 2" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=2"> 1% </a> <a title="April 2007 page 3" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=3"> www.sqlmag.com April 2007 The Smart Guide to Bu</a> <a title="April 2007 page 4" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=4"> November 5-8, 2007 Las Vegas, Nevada Mandalay Ba</a> <a title="April 2007 page 5" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=5"> A PENTON PUBLICATION Windows Group Publish</a> <a title="April 2007 page 6" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=6"> Altova® MissionKit™ 2007 – Intelligent tools for </a> <a title="April 2007 page 7" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=7"> Letters to the Editor Aspec s Da abase Des gn o</a> <a title="April 2007 page 8" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=8"> Tool Timewith Kevin Kline Editor's Note: Post y</a> <a title="April 2007 page 9" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=9"> Servers Storage Systems Management Services</a> <a title="April 2007 page 10" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=10"> Reader Challenge 2005/2000 Intermediate Change</a> <a title="April 2007 page 11" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=11"> Reader to Reader A Quick and Easy Way to View </a> <a title="April 2007 page 12" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=12"> Reader to Reader integer that represents the s</a> <a title="April 2007 page 13" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=13"> Ordering the SQL Master CD is like pocketing a te</a> <a title="April 2007 page 14" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=14"> Cover Story 2005 Intermediate 10 Layer on</a> <a title="April 2007 page 15" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=15"> The first step is to carefully prepare the s</a> <a title="April 2007 page 16" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=16"> SQL Server 2005 Security 3 Limit Access </a> <a title="April 2007 page 17" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=17"> SQL Server 2005 Security that you don't need. (R</a> <a title="April 2007 page 18" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=18"> SQL Server 2005 Security configured SQL Server </a> <a title="April 2007 page 19" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=19"> 2005 Intermediate </a> <a title="April 2007 page 20" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=20"> BLOBs and CLOBs The New Kids on the Block SQL</a> <a title="April 2007 page 21" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=21"> BLOBs and CLOBs LISTING 2 The Decompression Func</a> <a title="April 2007 page 22" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=22"> Recognizing everyday IT Pros for a JOB WELL DONE</a> <a title="April 2007 page 23" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=23"> 2005 Advanced </a> <a title="April 2007 page 24" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=24"> T-SQL Black Belt SELECT DATEADD(day, DATEDIFF(</a> <a title="April 2007 page 25" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=25"> The Logical Puzzle 0 /* Base Date */, GETDAT</a> <a title="April 2007 page 26" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=26"> T-SQL Black Belt in functions that perform such </a> <a title="April 2007 page 27" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=27"> 2005 Novice/ Intermediate </a> <a title="April 2007 page 28" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=28"> Excel PivotTables with “native” Excel functio</a> <a title="April 2007 page 29" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=29"> then click New Source. Select Microsoft SQL Serve</a> <a title="April 2007 page 30" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=30"> Excel PivotTables you've defined other Excel cal</a> <a title="April 2007 page 31" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=31"> 2005 Intermediate </a> <a title="April 2007 page 32" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=32"> Inside SQL Server The missing-indexes feature</a> <a title="April 2007 page 33" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=33"> Inside SQL Server which is available in SQL Ser</a> <a title="April 2007 page 34" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=34"> Get MORE out of SQL Reporting Services with Dunda</a> <a title="April 2007 page 35" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=35"> 2005 Intermediate </a> <a title="April 2007 page 36" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=36"> LISTING A XMLA Script That Creates Calculated</a> <a title="April 2007 page 37" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=37"> Moving Cubes Wizard (right-click the instance n</a> <a title="April 2007 page 38" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=38"> Moving Cubes might fi</a> <a title="April 2007 page 39" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=39"> Moving Cubes TABLE 1 Desired Effects of a FoodMar</a> <a title="April 2007 page 40" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=40"> Comparative Review by John Green SQL Serv</a> <a title="April 2007 page 41" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=41"> Comparative Review FIGURE 1 </a> <a title="April 2007 page 42" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=42"> Comparative Review The drill-down tools are</a> <a title="April 2007 page 43" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=43"> Comparative Review FIGURE 2 Color and </a> <a title="April 2007 page 44" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=44"> If you work with Windows + Linux or UNIX, you're </a> <a title="April 2007 page 45" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=45"> Got a great new product? Send </a> <a title="April 2007 page 46" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=46"> New Products TECHNICAL RESOURCE Implement, Main</a> <a title="April 2007 page 47" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=47"> Insights from the SQL Server industry </a> <a title="April 2007 page 48" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=48"> Connecting readers with the products and ser</a> <a title="April 2007 page 49" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=49"> There's Just No Comparison to Staging to Product</a> <a title="April 2007 page 50" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=50"> SELECT TOP(X) by Michael Otey Size Up Team D</a> <a title="April 2007 page 51" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=51"> SQL Farms Database tools that SCALE SQL Farm Co</a> <a title="April 2007 page 52" href="https://secure.viewer.zmags.com/publication/ed6e8cea?page=52"> Real Life SQL Server Superhero “ We</a>