Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

Pro SQL Server 2005

Pro SQL Server 2005

5.0 1
by Robin Dewson, Adam Machanic, Jan D. Narkiewicz, Thomas Rizzo, Joseph Sack

SQL Server 2005 is a dramatically expanded and enhanced version of SQL Server 2000 that not only makes SQL Server a true enterprise-level RDBMS, but also changes how SQL Server professionals design databases and develop database applications.

Pro SQL Server 2005 provides in-depth coverage of new SQL Server features and enhancements. It focuses on what


SQL Server 2005 is a dramatically expanded and enhanced version of SQL Server 2000 that not only makes SQL Server a true enterprise-level RDBMS, but also changes how SQL Server professionals design databases and develop database applications.

Pro SQL Server 2005 provides in-depth coverage of new SQL Server features and enhancements. It focuses on what experienced SQL Server database administrators, developers, and business intelligence practitioners need to know to get up to speed with SQL Server 2005 as quickly as possible. It carefully presents each new feature and precisely illustrates the feature with examples that show you how to use it effectively.

The authors provide practical, in-depth coverage of the core topics that they specialize inall supported by realistic examples, so you’ll be able to design and implement your own SQL Server 2005 solutions quickly and painlessly. This book is a roadmap for exploring and exploiting SQL Server 2005. So fasten your seatbelts, start your computers, and race to mastery of SQL Server 2005!

Editorial Reviews

The Barnes & Noble Review
If you’ve built or managed SQL Server applications before, here’s your fastest route to SQL Server 2005 mastery. Apress’s team of SQL Server experts cover every significant enhancement that’s relevant to application developers, designers, and administrators, from its improved management tools to its built-in .NET common language runtime.

DBAs will especially appreciate the authors’ coverage of new T-SQL commands that’ll simplify their lives: notably DDL triggers for auditing database object changes, as well as new metadata views (goodbye system tables, and good riddance). Meanwhile, developers will simply devour the authors’ coverage of .NET integration, programming with assemblies, and XML support.

That’s not all: This book contains thorough introductions to SQL Server 2005’s souped-up reporting, analysis, and integration services; new ways to streamline and automate monitoring; and a full chapter on security, from permissions to encryption. Bill Camarda, from the December 2005 Read Only

Product Details

Publication date:
Pro Series
Edition description:
1st Corrected ed. 2006. Corr. 3rd printing 2005
Product dimensions:
7.00(w) x 9.25(h) x 1.47(d)

Related Subjects

Meet the Author

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 Fat-Belly.com.

Adam Machanic is an independent database software consultant, writer, and speaker based in Boston. He has implemented SQL Server solutions for a variety of high-availability online transaction processing and large-scale data warehouse applications, and also specializes in .NET data access layer performance optimization. Adam has written for SQL Server Professional and TechNet magazines, serves as the SQL Server 2005 Expert for SearchSQLServer.com, and has contributed to several books on SQL Server, including Pro SQL Server 2005 (Apress, 2005). He regularly speaks at user groups, community events, and conferences on a variety of SQL Server and .NET-related topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server and a Microsoft Certified IT Professional (MCITP).

When not sitting at the keyboard pounding out code or code-related prose, Adam tries to spend a bit of time with his wife, Kate, and daughter, Aura, both of whom seem to believe that there is more to life than SQL.

Adam blogs at http://www.sqlblog.com, and can be contacted directly at amachanic@datamanipulation.net.

Jan D. Narkiewicz is chief technical officer of Software Pronto, Inc. His areas of expertise include Microsoft technologies, Oracle, and DB2. Jan also writes books for Apress and serves as academic coordinator for the University of California, Berkeley Extension's .NET/Windows program. His clients include E*TRADE, Visa, eBay, and Oracle.

Tom Rizzo is a director in the SQL Server group at Microsoft. Being an 11-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's collaboration servers.

Joseph Sack is a Principal Consultant with SQLskills. He has worked as a SQL Server professional since 1997 and has supported and developed for SQL Server environments in financial services, IT consulting, manufacturing, retail, and the real estate industry. Prior to joining SQLskills, he worked at Microsoft as a Premier Field Engineer supporting very large enterprise customer environments. He was responsible for providing deep SQL Server advisory services, training, troubleshooting, and ongoing solutions guidance. His areas of expertise include performance tuning, scalability, T-SQL development, and high-availability. In 2006 Joe earned the Microsoft Certified Master: SQL Server 2005 certification; and in 2008, he earned the Microsoft Certified Master: SQL Server 2008 certification. In 2009 he took over responsibility for the SQL Server Microsoft Certified Master program and held that post until 2011. He is the author of a few books and white papers, including most recently, SQL Server 2008 Transact-SQL Recipes (Apress, 2008). Joe's blog is at www.SQLskills.com/blogs/joe, and he can be reached at joe@SQLskills.com.

Rob Walters is a data platform technology specialist for Microsoft. His extensive experience with Microsoft SQL Server began over 10 years ago when he worked as a consultant for Microsoft Consulting Services in Denver, Colorado. Shortly after the dot-com bubble burst, Walters returned to Microsoft s headquarters and worked as a program manager in the SQL Server product unit. There, he owned various features within SQL Server including SQL Server Agent, various management features, and the security for the database engine. Walters has co-authored three patents for technologies used within SQL Server.

Walters has also co-authored Programming Microsoft SQL Server 2005 by Microsoft Press, and Pro SQL Server 2005, Accelerated SQL Server 2008, and Beginning SQL Server 2008 Database Administration by Apress. He holds a bachelor's of science degree in electrical engineering from Michigan State University and a master's degree in business administration from Seattle University. When not at work, he is very active in his community as an on-call firefighter.

Julian Skinner has been developing applications for over a decade. He has used a variety of Microsoft development technologies to create applications for both commercial and government entities on the Microsoft .NET platform. During his time as both a software developer and an IT consultant, he has been a part of all aspects of the SDLC, ranging from technical requirements gathering to deployment in large-scale environments. He has designed databases, implemented business logic components, and designed user interfaces for both Windows and web applications.

Louis Davidson has been in the IT industry for more than 15 years as a corporate database developer and architect. He has spent the majority of his career working with Microsoft SQL Server, beginning from the early days of version 1.0. He has a bachelor s degree from the University of Tennessee at Chattanooga in computer science, with a minor in mathematics. Louis is the data architect for Compass Technology (Compass.net) in Chesapeake, Virginia, leading database development on their suite of nonprofit oriented CRM products, built on the Microsoft CRM platform and SQL Server technologies.

Customer Reviews

Average Review:

Post to your social network


Most Helpful Customer Reviews

See all customer reviews

Pro SQL Server 2005 5 out of 5 based on 0 ratings. 1 reviews.
Guest More than 1 year ago
This is one of my favourite introduction books on SQL Server 2005, ideal if you are new or converting from a previous version. Useful to both DBAs and Programmers, it is readable from cover to cover.