<br />
T-SQL Editors Compared p.39 | PIVOT on Steroids p.17<br />
A PENTON PUBLICATION<br />
The Smart Guide to Building World-Class Applications<br />
www.sqlmag.com ■ Events: www.sqlconnections.com<br />
January 2007<br />
p. 10<br />
15 Common Security<br />
Checks You Can<br />
Automate p. 15<br />
Auxiliary Table-of-<br />
Numbers Tricks p. 31<br />
Don't Be Afraid of<br />
DTS Migration p. 35<br />
Brian Moran:<br />
PTO Foundations<br />
for the Rest of Us<br />
p. 5T-SQL Editors Compared P39 PIVOT on Steroids P.i?<br />
-------------???--------------------)--------1-------<br />
A PENTON PUBLICATION<br />
The Smart Guide \fi Building World-Class Applications<br />
www.sqtmag.com ??? Events: www.sqlconnections.com<br />
January 2007<br />
mag f*\<br />
J:<br />
n e<br />
<br />
Number of silos in which your customer data resides.<br />
Coincidentally, also the numbe<a title=" January 2007 page 1" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=1"> T-SQL Editors Compared p.39 | PIVOT on Steroi</a>
<a title=" January 2007 page 2" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=2"> Number of silos in which your customer data resid</a>
<a title=" January 2007 page 3" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=3"> The Smart Guide to Building World-Class Applicati</a>
<a title=" January 2007 page 4" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=4"> Altova® XML Suite 2007 – The world’s leading XML </a>
<a title=" January 2007 page 5" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=5"> A PENTON PUBLICATION Windows Group Publish</a>
<a title=" January 2007 page 6" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=6"> Servers Storage Systems Management Services</a>
<a title=" January 2007 page 7" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=7"> PTO Foundations PTO for the Rest of Us A ne</a>
<a title=" January 2007 page 8" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=8"> fe ApexSQL A^A software SQL Tools ApexSQL Studio </a>
<a title=" January 2007 page 9" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=9"> Editor’s Note: Post you</a>
<a title=" January 2007 page 10" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=10"> Tool Time with Kevin Kline commenting out the li</a>
<a title=" January 2007 page 11" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=11"> March 25-28, 2007 Orlando, Florida Orlando World </a>
<a title=" January 2007 page 12" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=12"> Cover SQL Server Pros Keep On Inno</a>
<a title=" January 2007 page 13" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=13"> 2006 Innovators Microsoft recently acquired].”Di</a>
<a title=" January 2007 page 14" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=14"> 2006 Innovators permitted users, the validated j</a>
<a title=" January 2007 page 15" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=15"> 2006 Innovators vacancy information and store</a>
<a title=" January 2007 page 16" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=16"> 2006 Innovators Honorable Mention Ed</a>
<a title=" January 2007 page 17" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=17"> 2000/2005 Intermediate </a>
<a title=" January 2007 page 18" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=18"> Audit Automation LISTING 1 Portion of upChec</a>
<a title=" January 2007 page 19" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=19"> 2005 Advanced </a>
<a title=" January 2007 page 20" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=20"> T-SQL Black Belt The @on_rows parameter rep</a>
<a title=" January 2007 page 21" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=21"> The Logical Puzzle T-SQL Black Belt Solutio</a>
<a title=" January 2007 page 22" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=22"> T-SQL Black Belt @on_cols = N’ShipVia’, @ag</a>
<a title=" January 2007 page 23" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=23"> SQL Farms Database tools that SCALE SQL Farm Comb</a>
<a title=" January 2007 page 24" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=24"> What’s so hard about supporting he</a>
<a title=" January 2007 page 25" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=25"> Exploring2005 Novice </a>
<a title=" January 2007 page 26" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=26"> SQL If Minds l Bi Compel </a>
<a title=" January 2007 page 27" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=27"> All Intermediate </a>
<a title=" January 2007 page 28" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=28"> Inside SQL Server each bookmark (clustered index</a>
<a title=" January 2007 page 29" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=29"> Solutions All Intermediate </a>
<a title=" January 2007 page 30" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=30"> Solutions by Design FIG</a>
<a title=" January 2007 page 31" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=31"> Solutions by Design can also be a customer.The b</a>
<a title=" January 2007 page 32" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=32"> Cross-Plattan Data Roadshow Solutions for Oracle </a>
<a title=" January 2007 page 33" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=33"> 2005 Intermediate </a>
<a title=" January 2007 page 34" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=34"> Table-of-Numbers Tricks The function should r</a>
<a title=" January 2007 page 35" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=35"> Table-of-Numbers Tricks member (e.g., spooling a</a>
<a title=" January 2007 page 36" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=36"> f~S p]0ulDi r^r ishboards for ting Services are h</a>
<a title=" January 2007 page 37" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=37"> Intermediate 2005/2000 </a>
<a title=" January 2007 page 38" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=38"> DTS-to-SSIS Migration There’s a light at the end</a>
<a title=" January 2007 page 39" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=39"> DTS-to-SSIS Migration adv</a>
<a title=" January 2007 page 40" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=40"> DTS-to-SSIS Migration DTS while providing bet</a>
<a title=" January 2007 page 41" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=41"> Comparative Review by Michael K. Campbell </a>
<a title=" January 2007 page 42" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=42"> Comparative Review FIGU</a>
<a title=" January 2007 page 43" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=43"> Comparative Review FIGUR</a>
<a title=" January 2007 page 44" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=44"> any SQL statement you execute—a feature I found a</a>
<a title=" January 2007 page 45" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=45"> Got a great new product? Send </a>
<a title=" January 2007 page 46" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=46"> New Products through visual data models. ER/S</a>
<a title=" January 2007 page 47" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=47"> Industry Insights from the SQL Server industry </a>
<a title=" January 2007 page 48" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=48"> January 2007 MarketPlace www.sqlmag.com 46 </a>
<a title=" January 2007 page 49" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=49"> www.sqlmag.com MarketPlace January 2007 4</a>
<a title=" January 2007 page 50" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=50"> SELECT TOP(X) Michael Otey SQL Server Log F</a>
<a title=" January 2007 page 51" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=51"> SPEED </a>
<a title=" January 2007 page 52" href="https://secure.viewer.zmags.com/publication/dc8ed6ab?page=52"> Choosing SQL BackupPro is such a no-brainer it ma</a>