SQL Server Books - Page 4

MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442)

Darril Gibson

Amazon Price: $44.09 List Price: $69.99 Usually ships in 24 hours By: McGraw-Hill Osborne Media Amazon Marketplace: 28 new & used starting at $36.18

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Certification Central -> Publisher -> Osborne-McGraw-Hill
Subjects -> Computers & Internet -> Certification Central -> MS SQL Server
Subjects -> Computers & Internet -> Certification Central -> General

Customer Reviews:
Total reviews: 4 Average rating: 5.0 of 5

Editorial Review:

All-in-One is All You Need

Get complete coverage of all three Microsoft Certified IT Professional database developer exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference.

Get full details on all exam topics including how to:

• Install and configure SQL Server 2005
• Manage database design
• Use Transact-SQL and XML
• Work with functions, triggers, and CLR integration
• Optimize, monitor, and secure databases
• Create stored procedures
• Handle disaster recovery
• Work with Service Broker, Web Services, and MARS
• Use SQL Server Reporting Services and Notification Services
• Manage locks, deadlocks, and cursors
• Transfer data using Replication and SQL Server Integration Services

The CD-ROM features:

• Six full practice exams-two for each exam: 70-431, 70-441, & 70-442
• Scripts from the step-by-step exercises in the book
• Video training clips from the author
• Complete electronic book

Inside Microsoft SQL Server 2005: T-SQL Programming (Pro-Developer)

Itzik Ben-gan, Dejan Sarka, Roger Wolter

Amazon Price: $29.69 List Price: $44.99 Usually ships in 24 hours By: Microsoft Press Amazon Marketplace: 47 new & used starting at $18.25

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> General
Subjects -> Computers & Internet -> Databases -> SQL -> General AAS

Customer Reviews:
Total reviews: 16 Average rating: 4.0 of 5

Too clever by half 2 out of 5 stars.
10 of 11 people found this review helpful.

Please see review by C. Mialaret. S/he is spot on.

One gets the impression that the author may have been more focused on impressing you with his eruditeness, rather than writing a practical book with useful examples and clear explanations.

Affecianados of Kalen Delaney's 'Inside SQL Server 2000' will be disappointed.

Editorial Review:

This thorough, hands-on reference for database developers and administrators delivers expert guidance on sophisticated uses of Transact-SQL (T-SQL)—one of the most familiar and powerful programming languages for SQL Server. Written by a T-SQL guru, this guide focuses on language features and how they are interpreted and processed by the SQL Server execution engine. You’ll get in-depth coverage of the sophisticated uses of T-SQL, including triggers, user-defined functions, exception handling, and more. The book explains and compares solutions to database-development problems in both SQL Server 2000 and SQL Server 2005, discussing the new T-SQL programming features added to SQL Server 2005 in detail. Includes extensive code samples, table examples, and logic puzzles to help database developers and administrators understand the intricacies and help promote mastery of T-SQL.

MICROSOFT SQL SERVER 2008 A BEGINNER'S GUIDE 4/E

Dusan Petkovic

Amazon Price: $26.39 List Price: $39.99 Usually ships in 24 hours By: McGraw-Hill Osborne Media Amazon Marketplace: 11 new & used starting at $21.09

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> General
Subjects -> Computers & Internet -> Databases -> SQL -> General AAS

Customer Reviews:
Total reviews: 5 Average rating: 4.0 of 5

Editorial Review:

Get Started on Microsoft SQL Server 2008 in No Time

Learn to use all of the powerful features available in SQL Server 2008 quickly and easily. Microsoft SQL Server 2008: A Beginner's Guide explains the fundamentals of each topic alongside examples and tutorials that walk you through real-world database tasks. Install SQL Server 2008, construct high-performance databases, use powerful Transact-SQL statements, create stored procedures and triggers, and execute simple and complex database queries. Performance tuning, Database Engine security, Business Intelligence, and XML are also covered.     

• Set up, configure, and maintain SQL Server 2008
• Build and manage database objects using Transact-SQL statements
• Create stored procedures and user-defined functions
• Optimize database performance, availability, and reliability
• Implement solid security using authentication, encryption, and authorization
• Automate tasks using SQL Server Agent
• Create reliable data backups and perform flawless system restores
• Use all-new SQL Server 2008 Business Intelligence, development, and administration tools
• Learn in detail the SQL Server XML technology (SQLXML)

Microsoft SQL Server 2008 For Dummies (For Dummies (Computer/Tech))

Mike Chapple

Amazon Price: $19.79 List Price: $29.99 Usually ships in 24 hours By: For Dummies Amazon Marketplace: 46 new & used starting at $14.93

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> General
Subjects -> Computers & Internet -> Databases -> SQL -> General AAS

Customer Reviews:
Total reviews: 1 Average rating: 4.0 of 5

Editorial Review:

If you’re a database administrator, you know Microsoft SQL Server 2008 is revolutionizing database development. Get up to speed on SQL Server 2008, impress your boss, and improve your company’s data management — read Microsoft SQL Server 2008 For Dummies!

SQL Server 2008 lets you build powerful databases and create database queries that give your organization the information it needs to excel. Microsoft SQL Server 2008 For Dummies helps you build the skills you need to set up, administer, and troubleshoot SQL Server 2008. You’ll be able to:

• Develop and maintain a SQL Server system
• Design databases with integrity and efficiency
• Turn data into information with SQL Server Reporting Services
• Organize query results, summarizing data with aggregate functions and formatting output
• Import large quantities of data with SSIS
• Keep your server running smoothly
• Protect data from prying eyes
• Develop and implement a disaster recovery plan
• Improve performance with database snapshots
• Automate SQL Server 2008 administration

Microsoft SQL Server 2008 For Dummies is a great first step toward becoming a SQL Server 2008 pro!

Inside Microsoft SQL Server(TM) 2005: The Storage Engine (Solid Quality Learning)

Kalen Delaney

Amazon Price: $31.49 List Price: $49.99 Usually ships in 24 hours By: Microsoft Press Amazon Marketplace: 45 new & used starting at $11.99

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Design
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> General

Customer Reviews:
Total reviews: 15 Average rating: 4.5 of 5

Technically advanced but sometimes incomprehensible 4 out of 5 stars.
5 of 5 people found this review helpful.

This book is perhaps the best book out there for understanding SQL 2005 architecture. I know of no other book which offers such advanced understanding of how SQL 2005 stores, retrives, and manages data.

Indeed, the author is a MS SQL MVP and has written with collaboration of those who have wrote the code for MS SQL 2005 at Microsoft.

The author's explaination, however, could be a lot better. For example, here is an exerpt on the author's explaination of IAM (Index Allocation Map):

"An IAM page contains a page header; an IAM page header, which contains eight page pointer slots; and a set of bits that map a range of extents on a file, which doesn't neccessarily have to be the same file that IAM page is in. The header has address of first extent in the range mapped by the IAM. The eight page pointer slots might contain pointers to pages belonging to the relevant object contained in mixed extents; only the first IAM for an object has values in these pointers."

Now, I have worked with databases for over a decade and have good understanding of Indexes and its structure, and I still did not understand what the author was talking about on some sentences.

Pros:
1)Explains data and index storage structures (Page, extents, B-Tree, Keys etc) and how they are managed in transactions (update, delete, insert) better than any book I know.
2)Relatively short book (400 pages) which does not waste words or sentences to make it a thicker book (common practice to write a thicker book for a higher price).

Cons:
1)Tries to combine MS SQL 101 topics (What is Master, MSDB, TEMP, and MODEL db?) with expert subject matter (What is IAM, Cluster Keys, RID, etc).
2)Writing is sometimes indecipherable.
3)Mostly not for the beginners (despite its rudimentrary coverage of the basics).

Editorial Review:

Understanding the internals of storage in SQL Server helps database developers and administrators to better create, maintain, and mine information from enterprise data. This practical, hands-on book focuses on the SQL Server 2005 Storage Engine and delves deep into the structures used for storing data, including files, tables, indexes, and data types. Topics also include security details, with coverage of the new SQL Server 2005 security model, and data protection through the backup and restore algorithms. With pragmatic advice, best practices, extensive code samples, and table examples, developers and database administrators will find the guidance they need to better understand how to build powerful, efficient databases.

Hands-On Microsoft SQL Server 2005 Integration Services

Ashwani Nanda

Amazon Price: $31.49 List Price: $49.99 Usually ships in 24 hours By: McGraw-Hill Osborne Media Amazon Marketplace: 44 new & used starting at $22.14

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Certification Central -> Publisher -> Osborne-McGraw-Hill
Subjects -> Computers & Internet -> Certification Central -> MS SQL Server
Subjects -> Computers & Internet -> Certification Central -> General

Customer Reviews:
Total reviews: 8 Average rating: 4.0 of 5

Great Book to learn SSIS Quickly 5 out of 5 stars.
3 of 3 people found this review helpful.

Hi All,

I bought this book because i need to implement my project in SSIS.This book is good for on Job reference , for Beginners and For who has exposure to DTS 2000.I learned and implemented my projected with no time.I recommend this book for those who want to Know about SSIS Quickly.

Thanks,
Madhu

Good starter book 2 out of 5 stars.
2 of 2 people found this review helpful.

This book helped me get started with SSIS...figure out some basic stuff. But it left me hanging on the details, best practices, integration with applications, etc. It basically walks you through building a bunch of thin-functionality examples of the various components.

If the book re-described itself as a getting-started book, I'd give it high praise and more stars...but the phrases "in depth", "learn to maximize", "extensive", etc, should have been omitted from the book description.

Editorial Review:

In-depth coverage of Microsoft�s powerful. new data integration tool

.

Learn to maximize the features of. SQL Server 2005 Integration Services from this essential. guide. Hands-On Microsoft SQL Server 2005 Integration. Services makes learning SSIS easy through the. use of extensive real-world exercises structured. around every component within the tool. You will. learn to collect corporate data from various sources. and transform that data for analysis, mining, and. reporting.

.

Microsoft® SQL Server(TM) 2005 Integration Services Step by Step

Paul Turley, Joe Kasprzak, Scott Cameron, Satoshi Iizuka, Pablo Guzman, Hitachi Consulting

Amazon Price: $29.69 List Price: $44.99 Usually ships in 24 hours By: Microsoft Press - Model: 9780735624054 Amazon Marketplace: 55 new & used starting at $19.23

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> Relational Databases
Subjects -> Computers & Internet -> Databases -> SQL -> General

Customer Reviews:
Total reviews: 8 Average rating: 3.0 of 5

A great SQL Server Integration Services book for beginners 5 out of 5 stars.
3 of 3 people found this review helpful.

I have a project to create a data warehouse, ETL the data and report from the new data warehouse. I have no SQL server 2005 experience at all. But after I read this book and follow the book step by step. I was able to create my DW ETL data to corresponding DIM and Fact tables and created my reports from my DW correctly without any problem. This book has very clear concepts and very practical steps. If you like to learn-by-doing on SSIS. This is the book does it all.

Editorial Review:

Get hands-on, practical guidance for using Microsoft SQL Server Integration Services, the next generation data integration platform from Microsoft. Integration Services is a powerful tool for business intelligence, so understanding the essentials--how to develop and deploy SSIS packages, as well as how to apply these skills to data warehousing solutions--is critical to harnessing the full benefits of SQL Server. This step-by-step tutorial teaches you all the essentials for getting started, including data transformation, scripting, security, and best practices for developing enterprise-class data integration applications. With STEP BY STEP, you work at your own pace through hands-on, learn-by-doing exercises. Whether you're a beginning programmer or new to this version of the technology, you'll understand the fundamental techniques for using SQL Server 2005 Integration Services. A companion CD includes data sets and sample code.

Microsoft SQL Server(TM) 2005 Administrator's Pocket Consultant (Pro-Administrator's Pocket Consultant)

William R. Stanek

Amazon Price: $19.79 List Price: $29.99 Usually ships in 24 hours By: Microsoft Press Amazon Marketplace: 47 new & used starting at $8.70

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> General
Subjects -> Computers & Internet -> Databases -> SQL -> General AAS

Customer Reviews:
Total reviews: 19 Average rating: 4.5 of 5

EXCELLENT BOOK FOR ADMINISTRATORS AND DEVELOPERS 5 out of 5 stars.
19 of 20 people found this review helpful.

Sometimes when I read reviews people have written I wonder if they've actually read the book or simply thumbed through it in a bookstore or did a search of the pages. This is an excellent book and I've found it to be extremely helpful in setting up and configuring SQL Server 2005. This book isn't meant to be an allinone monster book, its a concise, focused book covering the core of SQL Server 2005, particularly for administrators but also extremely helpful for developers who are setting up sql boxes too. If you are developing databases for SQL Server 2005 you'll need a focused development book too especially if you are doing datawarehousing or datamart work or reporting services.

I got more out of this book's 548 pages than books nearly twice as big. The book has T-SQL examples throughout and I've used them for administration. The book has excellent coverage of SQL security, nearly 100 pages of security information covered in Chapter 3 "Managing Security, Access, and Network Configuration" and in Chapter 8 "Managing SQL Server 2005 Security". Excellent coverage of log shipping and database mirroring. The book covers schemas for administration perspectives but not in a database development perspective.

I used this book to gain a solid understanding of SQL Server 2005 setup, configuration and management. I refer to it all the time.

This is a great book for your everyday needs and I use it all the time. Highly recommended.

Editorial Review:

Here’s the utterly practical, pocket-sized reference for IT professionals who need to administer, optimize, and maintain Microsoft SQL Server 2005 in their organization. This unique guide provides essential details for using Microsoft SQL Server 2005 to help protect and manage your company’s data—whether automating tasks; creating indexes and views; performing backups and recovery; replicating transactions; tuning performance; managing server activity; importing and exporting data; or performing other key tasks. Featuring quick-reference tables, lists, and step-by-step instructions, this handy, one-stop guide provides fast, accurate answers on the spot—whether you’re at your desk or in the field!

Microsoft® SQL Server® 2008 Internals (Pro - Developer)

Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Adam Machanic

Amazon Price: $37.79 List Price: $59.99 Not yet published By: Microsoft Press

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> General
Subjects -> Computers & Internet -> Databases -> SQL -> General AAS

Editorial Review:

Explore the definitive guide to the internals and architecture of the Microsoft SQL Server 2008 relational database engine. The author an expert on SQL Server internals offers the guidance developers and database administrators need to understand how SQL Server internal structures affect application development and functionality. Get the practical guidance needed to understand and maximize the SQL Server architecture, including information about logging and recovery, indexes, tables, transactions and locking, and security. This complete reference offers numerous code samples, table examples, and practical advice.

Microsoft® SQL Server(TM) 2005 Reporting Services Step by Step (Step by Step (Microsoft))

Stacia Misner, Hitachi Consulting

Amazon Price: $29.69 List Price: $44.99 Usually ships in 24 hours By: Microsoft Press Amazon Marketplace: 60 new & used starting at $16.84

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> Relational Databases
Subjects -> Computers & Internet -> Databases -> SQL -> General

Customer Reviews:
Total reviews: 8 Average rating: 3.0 of 5

Editorial Review:

Your hands-on guide to learning Microsoft SQL Server Reporting Services, Microsoft’s customizable reporting solution for business data analysis. Reporting Services is a powerful tool for business intelligence, so an understanding of the essentials—how to architect a report, as well as how to install and program Reporting Services—is key to harnessing the full benefits of SQL Server. This step-by-step tutorial shows you how to get started, how to use the report project wizard, how to think about and access data, and how to build queries. It also walks you through the creation of charts and visual layouts to enable maximum visual understanding of the data analysis. Interactivity features (enhanced in SQL Server 2005) and security are also covered in detail. With STEP BY STEP, you work at your own pace through hands-on, learn-by-doing exercises. Whether you’re a beginning programmer or new to this version of the technology, you’ll understand the fundamental techniques for using Reporting Services. A companion CD includes data sets and sample code.