
Expert SQL Server 2005 Development
APress
Published on 16. May 2007
Book
Paperback/Softback
472 pages
978-1-59059-729-3 (ISBN)
Description
This book offers a unique perspective on database development issues. It first presents and explains advanced techniques then demonstrates their use in various business scenarios. The goal is expert mastery of both concepts and their application.
More details
Edition
1st ed.
Language
English
Place of publication
Berkeley
United States
Target group
Popular/general
Product notice
Paperback (trade)
Unsewn / adhesive bound
Illustrations
472 p.
Dimensions
Height: 233 mm
Width: 182 mm
Thickness: 23 mm
Weight
717 gr
ISBN-13
978-1-59059-729-3 (9781590597293)
DOI
10.1007/978-1-4302-0333-9
Schweitzer Classification
Other editions
Additional editions

Adam Machanic | Lara Rubbelke | Hugo Kornelis
Expert SQL Server 2005 Development
E-Book
10/2007
APress
€46.00
Available for download
Persons
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.
Content
Software Development Methodologies for the Database World.- Testing Database Routines.- Errors and Exceptions.- Privilege and Authorization.- Encryption.- SQLCLR: Architecture and Design Considerations.- Dynamic T-SQL.- Designing Systems for Application Concurrency.- Working with Spatial Data.- Working with Temporal Data.- Trees, Hierarchies, and Graphs.