Inside Microsoft SQL Server 2005 or Building a PC for Dummies

Inside Microsoft SQL Server 2005: T-SQL Querying

Author: Itzik Ben Gan

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 advanced querying techniques and how queries are interpreted and processed by the SQL Server execution engine. You'll get in-depth coverage of the sophisticated uses of T-SQL, including the differences between logical and physical processing, nesting of queries, and much 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.

New interesting book: Better than Beauty or Nutrition Through the Life Cycle

Building a PC for Dummies: For Gaming, Multimedia, the Office or the Family, 5th Edition (Dummies Series)

Author: Mark L Chambers

• Shows tech hobbyists how to build the perfect PC, whether they want to create the ultimate gaming machine or combine new and recycled parts to construct an inexpensive computer for a child

• The do-it-yourself craze is sweeping through the tech community, and this guide is now significantly revised and updated to cover the wide array of new hardware and accessories available

• Step-by-step instructions and dozens of photos walk first-time computer builders through the entire process, from building the foundation, and adding a processor and RAM, to installing a video card, configuring a hard drive, hooking up CD and DVD drives, adding a modem, and troubleshooting problems

Booknews

Introduces the hardware components of a personal computer and how to assemble them at home. Individual chapters provide step-by-step instructions for installing the motherboard, RAM and CPU, monitor, hard drive, CD-ROM, sound card, modem, simple networking, ISDN, cable and DSL Internet connection, digital scanner, and SCSI devices. Annotation c. Book News, Inc., Portland, OR (booknews.com)

Table of Contents:

Introduction.

PART I: "Can I Really Do This?".

Chapter 1: What's in a Computer, Anyway?

Chapter 2: "What Type of PC Should I Build?".

PART II: Building Your PC.

Chapter 3: Building the Foundation: Your Case and Motherboard.

Chapter 4: A Bag of Chips: Adding RAM and Your CPU.

Chapter 5: The Three PC Senses: Your Ports, Mouse, and Keyboard.

Chapter 6: Images 'R Us: Adding Video and Your Monitor.

Chapter 7: Make Room! Your Hard Drive and Other Storage Devices.

PART III: Adding the Fun Stuff.

Chapter 8: Putting the Spin on CD-ROM and DVD.

Chapter 9: Let Your PC Rock!

Chapter 10: Modems and the Call of the Internet.

PART IV: Adding the Advanced Stuff.

Chapter 11: Attack of the SCSI Monster.

Chapter 12: So You Want to Add a LAN?

Chapter 13: Life in the Fast Lane -- with ISDN.

Chapter 14: Input and Output: Scanners, Cameras, Video Capture, and Printers.

Chapter 15: Other Power-User Play Toys.

PART V: The Part of Tens.

Chapter 16: Ten Reasons Not to Buy a Retail PC.

Chapter 17: Ten Tools and Tasks for a Power User's PC.

Chapter 18: Ten Important Assembly Tips.

Chapter 19: Ten Ways to Speed Up Your PC.

Chapter 20: Ten Things to Avoid Like the Plague.

PART VI: Appendixes.

Appendix A: Choosing Your Operating System.

Appendix B: Glossary.

Index.

Book Registration Information.