---

[Focus]

---

Publishing SQL Server in Active Directory
By adding SQL Server to Active Directory, you can help clients locate databases quickly, easily, and securely. AD's Service Publication and lookup let you keep server and database information up-to-date in a dynamic environment--or several of them.
 — Chad Miller

---

[Features]

---

Financial Reporting with Analysis Services
Analysis Services lets you create financial reports, but not always in the format your users need. Fortunately, you can learn from other developers. Here’s how one OLAP development team created detailed financial reports for a large banking group.
 — Yoram Levin


Inside Database Maintenance Plans
The Database Maintenance Plan Wizard makes creating maintenance plans easy, but making less-optimal (or erroneous) choices is also easy. Follow these guidelines and avoid these gotchas when creating maintenance plans.
 — Roman Rehak


Uncovering ADO.NET's Secret Identity
ADO.NET is great for developing scalable Web applications, but it can be harder to use for development tasks such as retrieving IDENTITY column values. Try these two technniques for revealing your SQL Server's secret IDENTITY column values.
 — Michael Otey

---

[SQL Server Savvy]

---

Changing Column Positions
Is there a way to change the ordinal position of a column in a table without recreating the table?
 — Brian Moran


Collation Changes in SQL Server
SQL Server 7.0 doesn't provide a mechanism for changing collations on the fly. To change the collation of an existing database you'll need to rebuild the master database or reinstall SQL Server.
 — Brian Moran


Installing SQL Server 2000 on Windows Server 2003
Windows Server 2003 doesn't support SQL Server 2000 Service Pack 2 (SP2) and earlier, but you can install those releases.
 — Brian Moran


SQL Server 2000 and Windows Server 2003 Web Edition
Windows Server 2003's Web Edition doesn't support SQL Server 2003 Standard and Enterprise Editions. You need to upgrade to Standard or Enterprise editions of Windows Server 2003 or run your database on another server.
 — Brian Moran


View Procedures in Enterprise Manager
If you accidentally delete a system stored procedure, how can you get Enterprise Manager to list the object as a system procedure after you add it back into the master database?
 — Brian Moran

---

[Editorial]

---

The Java Connection
The availability of multiple JDBC drivers helps SQL Server compete head-to-head with Oracle and DB2 as an enterprise database for Java applications.
 — Michael Otey

---

[Inside SQL Server]

---

Object Ownership and Security
Yukon is bringing some important changes in security, including user/schema separation. But before you can take advantage of those changes, you need to understand how SQL Server deals with object ownership now.
 — Kalen Delaney

---

[T-SQL Black Belt]

---

UDF Back Doors
Come around the back for a peek into the hidden workings of some undocumented UDF features.
 — Itzik Ben-Gan

---

[SELECT TOP(X)]

---

Best Practices Analyzer
Microsoft’s new tool, the SQL Server 2000 Best Practices Analyzer, will help you keep your systems running at their peak by checking for the implementation of common best practices.
 — Michael Otey

---

[Lessons from the Field]

---

Bulk Loading Data into SQL Server 2000
The SQL Server Development Customer Advisory Team helps customers to implement high-volume data loading. In this month’s column, the team shares data-loading basics and information that will help you optimize your SQL Server bulk-load performance.
 — Microsoft's SQL Server Development Team

---

[Preparing for SQL Server 2005]

---

Scoping Out Service Broker
To handle the needs of highly scalable business applications, Yukon’s SQL Server Service Broker lets internal and external processes send and receive reliable, asynchronous messages through extensions to T-SQL DML.
 — Eric Brown