---

[Focus]

---

Learning for Life
SQL Server trainer and consultant Morris Lewis recommends a variety of resources that SQL Server administrators and developers can use to improve their knowledge and advance their careers.
 — Morris Lewis


The Future of the DBA
What trends will affect your role in the SQL Server world? What areas of specialization will put you ahead of the pack? This advice from the experts can help you choose the right SQL Server career paths.
 — Brian Moran

---

[Features]

---

Log Shipping in SQL Server 2000, Part 2
Now that you've seen how you can easily set up, reconfigure, and monitor log shipping in SQL Server 2000, beef up your knowledge of role changes, role reversals, and where to place the monitor server.
 — Ron Talmage


Managing Your MSDE Database
Use SQL-DMO and other techniques to keep your application and users working effectively long after your MSDE installation is complete.
 — William Vaughn

---

[SQL Server Savvy]

---

Can 2 Linked Servers Execute a Query in Parallel?
I'm using distributed partitioned views to run a query on two servers. However, the two parts of the union execute serially rather than in parallel. Why?
 — Brian Moran


Identifying Duplicate .jpg Files
Can I compare the image value in one row with the image contents of another row to determine whether the contents are identical?
 — Brian Moran


Returning a Percentage of 2 Summed Values
I'm trying to use T-SQL to return the relative percentage of two summed values when I divide the values into each other. Why does my calculation behave as if it's doing integer math?
 — Brian Moran


Tracking Automatic Growth of Database Files
How can I see when my SQL Server 2000 database file grows and how much it grows each time?
 — Brian Moran


What is LPC?
What does the value LPC mean in the net_library column of my master..sysprocesses table?
 — Brian Moran

---

[Editorial]

---

The Java Hurdle
By providing a native JDBC driver for SQL Server, Microsoft hurdles the Java stumbling block and continues to push SQL Server into the enterprise.
 — Michael Otey

---

[SQL Seven]

---

More Registry Manipulations
Here are seven more undocumented extended stored procedures that can add power to T-SQL.
 — Michael Otey

---

[Inside SQL Server]

---

Take It from the TOP
Rewriting your queries to use TOP instead of SET ROWCOUNT can be a form of query tuning.
 — Kalen Delaney

---

[Mastering Analysis]

---

Time-Dynamic MDX
To write queries that always return the most recent information, you need an MDX formula that moves forward in time as you add new information to the database. Here are four ways to create this time-dynamic MDX.
 — Russ Whitney

---

[Solutions by Design]

---

Making History
Create a set of history tables in your database or build a separate history database without jeopardizing your database’s performance.
 — Michelle A. Poolet

---

[Answers from Microsoft]

---

Accessing Extended Properties in a Web-Based Application
Microsoft’s SQL Server development team provides code that retrieves extended properties in a Web-based SQL Server administration application.
 — Richard Waymire


Accounting for Transaction Log Growth
Microsoft’s SQL Server development team explains why a transaction log expands and offers remedies for the problem.
 — Richard Waymire


Determining the Maximum Number of Connections to SQL Server 2000
Microsoft’s SQL Server development team explains how to accommodate the most SQL Server connections on one node.
 — Richard Waymire


Using a CHECK Constraint to Enforce a Trigger’s Unique Value
Microsoft’s SQL Server development team tells a reader how to enforce a trigger’s unique value by using a custom CHECK constraint or, in SQL Server 2000, INSTEAD OF triggers.
 — Richard Waymire


Using Dynamic Snapshot for Merge Replication
Microsoft’s SQL Server development team explains why dynamic snapshot processes articles for replication multiple times.
 — Richard Waymire

---

[Exploring XML]

---

Getting Around an XML Bulk Load Bug That Truncates Data Without Notification
To prevent XML Bulk Load from truncating your data without notice, you can use SAX2 validation with XML Schema mapping schemas to ensure that only data of the correct type is loaded into your database.
 — Rich Rollman


Using the sql:max-depth Attribute for Schemas with Recursive Elements
SQL Server 2000 doesn't support recursive queries. However, by using the new sql:max-depth annotation, you can easily generate recursive hierarchies without the complexity of building a FOR XML EXPLICIT query.
 — Rich Rollman

---

[Letters]

---

Letters, January 2002
Readers write in about the implications of increasing SQL Server's programmability, using computed columns, and understanding transaction isolation levels.
 — Various Authors

---

[New Products]

---

New Products, January 2002
A collection of the latest SQL Server-related new and improved products.
 — Carolyn Mader , et al.