SQL Server 2005 is a landmark release of Microsoft's powerful relational database management system for the Windows platform, and one that will change the way you architect your data systems and develop your data-driven applications. Pro SQL Server 2005 takes a deep look at the full range of SQL Server enhancements, and includes meaningful and relevant examples showing how these new features work and how you can build applications effectively.This book provides a critical examination of all of the major new functionality in SQL Server 2005, covering topics that are essential for DBAs and developers alike, including:
T-SQL programming
CLR integration and assembly programming
Using SQL Server Integration Services for data extraction, transformation, and loading
The new native XML datatype and how to use it
Security enhancements and Service Broker
SQL Server 2005 is a vast new release and each author provides practical, in-depth coverage of the core topics in their specialist areas ·always illustrated with realistic examples. As a result, you'll be able to work on your own SQL Server 2005 solutions quickly and painlessly. Ultimately, this book provides you with a starting point, a roadmap, and then the tools and knowledge to exploit this powerful new database to its fullest extent. So, sit back, fire up your computer and your brain and get ready to learn SQL Server 2005.
Author Information
Louis Davidson
Louis Davidson has been in the information technology industry for ten years, as a corporate database developer and architect. Currently, he is serving as a Database Administrator for Compass Technology Management, supporting the Christian Broadcasting Network and NorthStar Studios in Nashville, TN. Louis' primary areas of expertise are in database architecture and coding in Transact-SQL, and he is currently writing Pro SQL Server 2005 Database Design and Optimization.
Robin Dewson
Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website as well as maintaining his own site at www.fat-belly.com.
Adam Machanic
Adam Machanic is a database-focused software engineer, writer, and speaker based in Boston, Massachusetts. He has implemented SQL Server for a variety of high-availability OLTP and large-scale data warehouse applications, and also specializes in .NET data access layer performance optimization. He is a Microsoft Most Valuable Professional (MVP) for SQL Server and a Microsoft Certified Professional.
Jan D. Narkiewicz
Jan D. Narkiewicz is chief technical officer of Software Pronto, Inc. His areas of expertise include Microsoft technologies, Oracle, and DB2. Jan also write books for Apress and serves as academic coordinator for U.C. Berkeley Extension? .NET/Windows program. His clients include E*Trade, Visa, eBay, and Oracle.
Thomas Rizzo
Tom Rizzo, the lead author, is a director in the SQL Server group at Microsoft. Being an eleven year veteran at Microsoft, Tom has worked on a number of the different Microsoft server technologies such as BizTalk, SharePoint and Exchange Server before joining the SQL Server group. Tom is a published author on topics ranging from SQL Server to developing collaborative applications using Microsoft? collaboration servers.
Joseph Sack
Joseph Sack is a database administration and developer based in Minneapolis, Minnesota. Since 1997, he has been developing and supporting SQL Server environments for clients in financial services, IT consulting, manufacturing, and the real estate industry. Joseph received his bachelor's degree in psychology from the University of Minnesota. He is the author of ?QL Server 2000 Fast Answers for DBAs and Developers· the co-author of ?eginning SQL Server 2000 DBA: From Novice to Professional·and is a Microsoft Certified Database Administrator (MCDBA).
Julian Skinner
Julian Skinner studied Germanic etymology to PhD level before becoming a technical editor, first at Wrox Press, then at Apress. Recently he has focusing on development and writing in Microsoft technologies and, in particular, on C# and the .NET Framework. He is co-author of Professional ADO.NET, Professional ASP Data Access, and A Programmer's Guide to SQL.
Rob Walters
Rob Walters is a program manager in the SQL Server group of Microsoft. He has seven years of experience in software development and relational databases.
