---

[Features]

---

Create a User-Defined Data Type
SQL Server 2005's user-defined data type (UDT) capability lets you create new multifield scalar data types, such as Latitude and Longitude, and treat them the same way you do built-in multifield scalar data types such as datetime.
 — Dan Sullivan


Developing CLR-Based Stored Procedures
See how Common Language Runtime (CLR) stored procedures work and how they fit into the larger scheme of a high-performance database system by walking through a CLR assembly project that captures and encrypts credit card information.
 — William Vaughn


Management Tools: No Secrets
In this interview with SQL Server Magazine, Microsoft’s Euan Garden looks at SQL Server 2005’s new and improved management tools, designed to make database-management functions more transparent, more robust, and easier to use.
 — Editors


Message Received
SQL Server Service Broker lets internal or external database-related processes send messages to and receive them from each other, providing a valuable way to implement database-oriented middleware and distributed database applications.
 — William Zack


What's New in DTS?
Microsoft has rewritten every aspect of Data Transformation Services (DTS) in SQL Server 2005, making it a true extraction, transformation, and loading (ETL) platform and improving performance. Take a whirlwind tour of some of the most important changes.
 — Kirk Haselden

---

[Editorial]

---

Let XML In
XML documents are crucial to many business applications, and to truly be an enterprise-level database platform, SQL Server must be able to not only store XML documents but to query them and combine XML data with relational data.
 — Michael Otey

---

[Inside SQL Server]

---

Inside SQL Server 2005 Security
Rest secure: Yukon addresses some security holes that previous releases left open. Look inside execution context, user-schema separation, and more.
 — Kalen Delaney

---

[T-SQL Black Belt]

---

Get in the Loop with CTEs
Get into the loop! Check out what you can do with Yukon’s new non-recursive and recursive Common Table Expressions.
 — Itzik Ben-Gan

---

[SELECT TOP(X)]

---

New Whidbey Features
Here are seven exciting new features you can look forward to in Visual Studio .NET’s upcoming release, code-named Whidbey.
 — Michael Otey

---

[Preparing for SQL Server 2005]

---

Off by Default
Summary of Yukon's primary security concepts.
 — Eric Brown