---

[Focus]

---

ASP.NET 2.0: Cache In on Performance Shortcuts
Take advantage of callback functions and enhanced caching options to boost your Web application’s performance at the client, Web server, and database tiers.
 — William Sheldon

---

[Features]

---

Delivering Analysis Services Data with Reporting Services
Learn how to use Reporting Services to give business users access to complex Analysis Services data--in a user-friendly format.
 — Craig Utley


Life Cycle Tools for the Data Dude
Get the inside story on Microsoft's new database development tool, Visual Studio Team Edition for Database Professionals (VSDB Pro), which its creators hope will bridge the gap between database and application developers.
 — Karen Forster

---

[SQL Server Savvy]

---

Check Out the New SQL Server 2005 Report Packs
Microsoft recently released SQL Server 2005 Report Packs, which provides 65 reports that are designed to help you author and generate reports for your environment in a timely manner.
 — Brian Moran


Duration and CPU Values
An anomaly in SQL Server 2005 Profiler's GUI can be confusing. Here's the scoop on how SQL Server 2005 displays duration and CPU values.
 — Brian Moran


SQL Server Profiler: 2005 vs. 2000
There's been a change; SQL Server Profiler running under SQL Server 2005 now captures duration values at a higher level of granularity.
 — Brian Moran


When Upgrading, Check Compatibility Level
When you upgrade to SQL Server 2005, remember to check to make sure the compatibility level has changed to a value of 90 during the upgrade process.
 — Brian Moran

---

[Editorial]

---

A Tale of Two Architectures
Both the AMD Opteron and the Intel EM64T processors are x64 compatible and capable of running 32-bit x86 and 64-bit x64 applications at full speed. However, you'll find significant differences between the processors and the system architectures they use.
 — Michael Otey

---

[Inside SQL Server]

---

Diving In to Object-Storage Metadata
Learn about new views in SQL Server 2005 that replace SQL Server 2000's sysindexes system table and give you access to storage-related metadata for database objects.
 — Kalen Delaney

---

[Solutions by Design]

---

Relational Luddites
Learn how a database consultant was able to help a DBA understand some of the inherent weaknesses of using a flat-file database, and move toward normalizing the data in a relational database.
 — Michelle A. Poolet

---

[T-SQL Black Belt]

---

Custom Aggregations: Specialized Solutions
In this final part of a four-part series about custom aggregations, we look at a class of solutions that relies on specialized solutions.
 — Itzik Ben-Gan

---

[New Products]

---

New Products, July 2006
Check out new and improved SQL Server–related products.
 — Blake Eno

---

[SELECT TOP(X)]

---

Query Editor Shortcuts
Keyboard shortcuts save you time and effort when you use Query Editor in SQL Server 2005. Check out these top 10 we've collected for easy reference—and create a few of your own, too.
 — Michael Otey

---

[Ask Microsoft]

---

Using msdb Backup Tables
Microsoft’s Gert Drapers explains techniques for getting valuable information from SQL Server’s msdb backup tables.
 — Microsoft's SQL Server Development Team

---

[Vendor Briefs]

---

Vendor Briefs, July 2006
Our editors share insights from their conversations with Insightix, MRC, Diskeeper, and Oracle.
 — Editors

---

[Review]

---

HP ProLiant DL 585
Check out the HP ProLiant DL585—the enterprise-class 4-way, 64-bit server that's setting new benchmarks in performance, thanks to its dual-core AMD Opteron configuration.
 — Michael Otey

---

[Market Watch]

---

SQL Server Backup and Recovery
Needs to maintain application availability, to stash copies of data in safe, remote locations, and to be able to readily recover data have given rise to new SQL Server 2005 features, as well as new backup and recovery strategies.
 — John Green