SQL Server Magazine May 2004

    Options
SQL Server 2005
From CLR integration and T-SQL enhancements to new management tools, messaging middleware, security improvements, and a rewritten DTS, this issue takes you inside the upcoming release of SQL Server 2005 so that you can plan for a smooth migration. 		  • Subscribe
• Renew
• Master CD
• Change Mailing Address
• Customer Service
• Back Issues
• Article Reprints
• Group Discounts

Browse Archived Articles By: Issue | Author | Subject | Department |


[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.
By 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.
By 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.
By 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.
By 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.
By 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.
By 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.
By 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.
By 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.
By Michael Otey 



[Preparing for SQL Server 2005]

Off by Default

Summary of Yukon's primary security concepts.
By Eric Brown