Microsoft SQL Server 2005: A Beginner''s Guide
Select Format
Select Condition 
Book Overview
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
Deploy and manage SQL Server 2005 with ease
Learn to use all the powerful features available in SQL Server 2005 from this straightforward, hands-on guide. Set up SQL Server 2005, automate system administration tasks, execute simple and complex database queries, and use the robust analysis, business intelligence, and reporting tools. Troubleshooting, data partitioning, replication, and query optimization are also covered. With SQL Server 2005: A Beginner's Guide, you'll be able to set up a secure, reliable, and productive data management platform in no time.
Essential Skills for Database Professionals
Install and customize SQL Server 2005Create, alter, and remove database objects with Transact-SQL statementsUse SQL Server as a native XML database systemTune your database system for optimal performanceUse the new SQL Server Management Studio tool for executing and analyzing ad hoc queriesRetrieve data from more than one source using join operations and SELECT statementsSecure your database using two different authentication modes--Windows and mixedRestore databases using transaction logs and backup and recovery methodsStreamline system administration tasks using the SQL Server Agent service toolAnalyze and manage information stored in a data warehouse with Microsoft Analysis ServicesFormat:Paperback
Language:English
ISBN:0072260939
ISBN13:9780072260939
Release Date:December 2005
Publisher:McGraw-Hill Companies
Length:704 Pages
Weight:2.70 lbs.
Dimensions:1.5" x 7.4" x 9.2"
Customer Reviews
5 ratings
Very comprehensive book
Published by Thriftbooks.com User , 18 years ago
What I like on this book is that it is very comprehensive. All components of SQL Server 2005 are described in it. The description of each component is clear. Besides a couple of sentences, I did not have any problems to understand the content of this book. I found some small typographical errors, but as a whole I think that this is a very gook book.
Excellent Book
Published by Thriftbooks.com User , 18 years ago
This book provides a solid introduction to SQL Server 2005. The coverage is comprehensive. (Very few books attempt to cover the relational database engine with Transact-SQL, database administration, performance tuning, Analysis Services and XML in one volume and this one does it successfully.) The writing is clear and I did not have any problems to understand all topics discussed in it. My IT department also used the book to learn how the implementation of stored procedures and UDFs can be done using C#. The coverage of this topic is not too deep, but the existing examples and the given description allowed us to implement several routines and to evaluate the use of CLR for our department. My opinion is that this book is not for complete beginners. But, if you have some knowledge of relational database systems and wants one book as a source, I can recommend it to you.
Five Star +!
Published by Thriftbooks.com User , 19 years ago
Mr. Petkovic has once again landed a successful effort on SQL Server to help those who are in most need. Chapters all include an excellent quiz section to quickly recap and test your comprehension. Great tool for those who plan to use it as a teaching guide! Our IT department and clients have found this feature very helpful. Once again great job, easy to read and understand!
Very usefull book
Published by Thriftbooks.com User , 19 years ago
This book is almost ideal material to introduce you to world of TSQL and SQL Server. It is not the last book that you will need - it dow not cover all aspects of SQL Server , but that is not expected frm title anyway. Author has a good sence of what topics are appropriate for the begineer. I would recomanded it not just to junior DBAs but also to C# and VB.NET developers that need to cover SQL Server development as well.
Beginner's Guide
Published by Thriftbooks.com User , 19 years ago
I am surprised that someone would give 1 * to this book. I personally do not use it, but I asked couple of developers to read previous and this version of this book before they start working on my projects. I disagree with one of the earlier reviewers about the comments that he made: - System Tables or System Catalogs - nothing has really changed. It just MS marketing BS. - sp for managing logins are still around - i see no harm in that. Especially when I have a legacy systems and ton of code that is using them. - User is complaining about lack of coverage of Resources db. Such system database does not exist - on SQL Server. - Covering of Mirroring is not ideal, but I would not even put it a book, since Microsoft has decided to not support it for at least 6 moths. My assumption is that MS will probably change it at the end. If this was a genuine reader of the book, I would question how he qualifies as a beginner if he is aware of details of Mirroring deployment. If you are starting to work with SQL Server, buy this book. You will not regret it. In my view this is just another example how some people are obusing
Copyright © 2025 Thriftbooks.com
Terms of Use | Privacy Policy | Do Not Sell/Share My Personal Information | Cookie Policy | Cookie Preferences | Accessibility Statement
ThriftBooks ® and the ThriftBooks ® logo are registered trademarks of Thrift Books Global, LLC
ThriftBooks ® and the ThriftBooks ® logo are registered trademarks of Thrift Books Global, LLC
