Describe your new book. Oddfellow's Orphanage is a series of stories/vignettes that tell the tale of the newest arrival to a curious orphanage, a...
Continue »
Learn more-advanced skills to design, build, test, deploy, and maintain SQL Server databases—one step at a time. Ideal for developers who understand database essentials, this learn-by-doing tutorial offers practical guidance, code samples, and a collection of techniques to help you solve real-world business problems.
Discover how to:
Manage data access with server logins and user and server roles
Implement a disaster recovery strategy
Use aggregate functions to compute totals and complex statistical values
Optimize query performance by managing IO statistics and designing indexes
Work with remote data sources—including third-party databases
Provide remote access through the Internet or a middle-tier service interface
Manage transactions, implement error handlers, and define isolation levels
Go further and work with SQL Server Reporting Services and Notification Services
Includes a CD featuring:
All practice exercises
Code samples
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Synopsis:
A skill-building, learn-by-doing tutorial to help developers and database administrators with basic product knowledge begin to master SQL Server 2005. SQL Server 2005 is Microsoft's next-generation data management and analysis solution that delivers increased security, scalability, and availability to enterprise data and analytical applications while making them easier to create, deploy, and manage. This book shows readers with fundamental SQL Server skills, as well as new-to-topic but experienced database developers, techniques to design, build, test, deploy, and maintain better SQL Server databases. The format is a hands-on, sequential, developer's companion, providing beyond-the-basics guidance. This book is not a feature-driven reference manual, but a highly practical learning experience demonstrating how to build database solutions to solve business problems. SQL Server 2005 is Microsoft's next-generation data management and analysis solution that delivers increased security, scalability, and availability to enterprise data and analytical applications while making them easier to create, deploy, and manage. Featuring key advances in enterprise data management, developer productivity, and business intelligence, SQL Server 2005 is part of the Windows Server System — a comprehensive and integrated server infrastructure that simplifies the development, deployment and operations of a flexible business solution. The market leader in speed, reliability, and security, this new version of SQL Server will excite the existing customer base and widen the development community.
Synopsis:
Learn more-advanced skills to design, build, test, deploy, and maintain SQL Server databases—one step at a time. Ideal for developers who understand database essentials, this learn-by-doing tutorial offers practical guidance, code samples, and a collection of techniques to help you solve real-world business problems.
Discover how to: Manage data access with server logins and user and server roles Implement a disaster recovery strategy Use aggregate functions to compute totals and complex statistical values Optimize query performance by managing IO statistics and designing indexes
Work with remote data sources—including third-party databases Provide remote access through the Internet or a middle-tier service interface Manage transactions, implement error handlers, and define isolation levels Go further and work with SQL Server Reporting Services and Notification Services
Includes a CD featuring: All practice exercises Code samples
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Microsoft SQL Server (TM) 2005: Applied Techniquies Step by Step (Pro-Step by Step Developer)
Sale Trade Paper
Solid Quality Learning
0 stars -
0 reviews
$12.00
In Stock
Product details
368 pages
Microsoft Press -
English9780735623163
Reviews:
"Synopsis"
by Ingram,
A skill-building, learn-by-doing tutorial to help developers and database administrators with basic product knowledge begin to master SQL Server 2005. SQL Server 2005 is Microsoft's next-generation data management and analysis solution that delivers increased security, scalability, and availability to enterprise data and analytical applications while making them easier to create, deploy, and manage. This book shows readers with fundamental SQL Server skills, as well as new-to-topic but experienced database developers, techniques to design, build, test, deploy, and maintain better SQL Server databases. The format is a hands-on, sequential, developer's companion, providing beyond-the-basics guidance. This book is not a feature-driven reference manual, but a highly practical learning experience demonstrating how to build database solutions to solve business problems. SQL Server 2005 is Microsoft's next-generation data management and analysis solution that delivers increased security, scalability, and availability to enterprise data and analytical applications while making them easier to create, deploy, and manage. Featuring key advances in enterprise data management, developer productivity, and business intelligence, SQL Server 2005 is part of the Windows Server System — a comprehensive and integrated server infrastructure that simplifies the development, deployment and operations of a flexible business solution. The market leader in speed, reliability, and security, this new version of SQL Server will excite the existing customer base and widen the development community.
"Synopsis"
by Ingram,
Learn more-advanced skills to design, build, test, deploy, and maintain SQL Server databases—one step at a time. Ideal for developers who understand database essentials, this learn-by-doing tutorial offers practical guidance, code samples, and a collection of techniques to help you solve real-world business problems.
Discover how to: Manage data access with server logins and user and server roles Implement a disaster recovery strategy Use aggregate functions to compute totals and complex statistical values Optimize query performance by managing IO statistics and designing indexes
Work with remote data sources—including third-party databases Provide remote access through the Internet or a middle-tier service interface Manage transactions, implement error handlers, and define isolation levels Go further and work with SQL Server Reporting Services and Notification Services
Includes a CD featuring: All practice exercises Code samples
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and eBooks — here at Powells.com.