The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
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.
By
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 William Vaughn
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 Michael Otey
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 Itzik Ben-Gan
Test your skills by devising solutions for three requests for information from the SQL Server 2005 sample AdventureWorks database.
By Kirk Haselden
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 Dan Sullivan
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.
Here are seven exciting new features you can look forward to in Visual Studio .NET’s upcoming release, code-named Whidbey.
By William Zack
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 Kalen Delaney
SQL Server 2005 gives you several new DDL statements for working with schemas and users.
By Eric Brown
Summary of Yukon's primary security concepts.
Get into the loop! Check out what you can do with Yukon’s new non-recursive and recursive Common Table Expressions.
Rest secure: Yukon addresses some security holes that previous releases left open. Look inside execution context, user-schema separation, and more.
advertisement