---

[Focus]

---

SQL Server 2005 Management Tools
The release of SQL Server 2005 brings lots of changes in every aspect of the product. Join Kalen Delaney and Ron Talmage on an exploration of the new management tools.
 — Kalen Delaney , et al.

---

[Features]

---

Merge Replication in the Real World
If you're looking for an easy-to-use solution for your organization's high-availability and disaster-recovery needs, this real-world example can help you decide whether merge replication is a good choice for you.
 — Gary Zaika


Security in SSIS
SQL Server 2005 Integration Services (SSIS) still includes familiar security functions such as password encryption, but the approach has changed dramatically. Take a look at the new security features and learn how and when to use them.
 — Kirk Haselden


Tame Your Tables
Are your tables out of control? This method lets you flexibly add tables to your database application while keeping your database structure manageable.
 — Bálint Nagy , et al.

---

[SQL Server Savvy]

---

Check Out Microsoft's New-and-Improved SQL Server TechCenter
A few months ago, Microsoft launched a new-and-improved SQL Server TechCenter "designed to connect you with SQL Server-related resources from Microsoft and the broader SQL Server community."
 — Brian Moran


Granular Timing Statistics From Profiler
If you want Profiler to show timings between 0 and 10 ms, all you have to do is tell your boss that you want to install a non-supported extended stored procedure that's based on non-supported technology from Microsoft Research.
 — Brian Moran


Performing a Reverse DNS Lookup
You can use a simple technique that relies on xp_cmdshell to perform a reverse DNS lookup.
 — Brian Moran


Simulating Parallel Plans
Is there a way to simulate a parallel plan on a uni-processor server for testing and development purposes?
 — Brian Moran


Using Fields as Primary Keys
A quick query to find out whether two fields together are unique and if you can use the combination as a primary key.
 — Brian Moran

---

[Editorial]

---

SQL Server 2005: The BI Release
Despite the slew of new features in other areas of the product, SQL Server 2005 could easily be known as "the BI release."
 — Michael Otey

---

[Inside SQL Server]

---

Conditional Recompile
You can work around some of the drawbacks of conditionally recompiling stored procedures, but be careful when handling dynamic SQL.
 — Kalen Delaney

---

[T-SQL Black Belt]

---

Auditing Advice
Dealing with auditing issues can be tricky, and you need to apply logic to come up with solutions. T-SQL master Itzik Ben-Gan offers these tips for audit triggers.
 — Itzik Ben-Gan

---

[New Products]

---

New Products, August 2005
Check out new and improved SQL Server–related products.
 — Dawn Cyr

---

[SELECT TOP(X)]

---

T-SQL Temporary Table Tips
Temporary tables are a great T-SQL developer feature that lets you store and process intermediate results. Here are seven tips to help you manage the temporary tables your T-SQL procedures use.
 — Michael Otey

---

[Preparing for SQL Server 2005]

---

A Report Builder for Everyone
Report Builder is an end-user reporting tool that lets business users create Reporting Services reports without using Visual Studio. Learn how this tools works and how it can simplify your life.
 — Matt Nunn

---

[Hands On]

---

Fast Indexing and Returns Enable Data Mining
A reader highlights his favorite product: SQL Turbo
 — Dawn Cyr