Microsoft SQL Server 2008 for Dummies

This book make you familiar with SQL Server 2008, You’ll find that it’s an excellent starting point for anyone beginning to use SQL Server and offers a great foundation for your Database career. Some of the common and important issues this book cover are:

 Choosing the appropriate edition of SQL Server for your needs

 Orienting yourself to the SQL Server database management tools

 Installing and configuring your first SQL Server 2008 database server

 Designing your first database

 Creating databases and tables in SQL Server 2008

 Imposing constraints on database tables and creating inter-table

Relationships

 Retrieving data from your database with simple and advanced Transact-

SQL queries

 Creating basic reports with SQL Server Reporting Services

 Inserting data into your database via manual or bulk insertion

 Using stored procedures, functions and triggers to automate database

Tasks

 Keeping your database server running smoothly with indexes and partitions

 Limiting resource consumption with SQL Server 2008’s new Resource

Governor

 Automating database administration with SQL Server Agent and

Maintenance Plans

 Troubleshooting and tuning SQL Server databases

 Protecting your database with security controls, backups, and transactions

 Creating high-availability database solutions for critical IT environments

 Using the Declarative Management Framework to create policies covering

multiple SQL Server installations

table of content: 

Part I: Welcome to SQL Server 2008

Chapter 1: Introducing SQL Server 2008

Chapter 2: Building Your SQL Server

Chapter 3: Working with SQL Server Tools

Part II: Building SQL Server 2008 Databases

Chapter 4: Planning Your Database

Chapter 5: Creating Databases and Tables

Chapter 6: Imposing Constraints and Relationships

Part III: Retrieving Data from Databases

Chapter 7: Constructing Simple Database Queries

Chapter 8: Joins and Other Advanced Queries

Chapter 9: Turning Data into Information with SQL Server

Reporting Services

Part IV: Inserting and Manipulating Your Data

Chapter 10: Inserting, Updating, and Deleting Data

Chapter 11: Saving Time with Functions, Stored Procedures, and Triggers

Part V: SQL Server Administration

Chapter 12: Keeping Your SQL Server Running Smoothly

Chapter 13: Automating SQL Server 2008 Administration

Chapter 14: Troubleshooting SQL Server 2008 Problems

Chapter 15: Replicating Data across Multiple Servers

Part VI: Protecting Your Data

Chapter 16: Protecting Your Data from Prying Eyes

Chapter 17: Preserving the Integrity of Your Transactions

Chapter 18: Preparing for Disaster

Chapter 19: Staying Alive: High Availability in SQL Server 2008

Chapter 20: Implementing Policy-Based Management with the Declarative

Management Framework

Part VII: The Part of Tens

Chapter 21: Ten Ways to Keep Your SQL Server 2008 Databases Humming

Chapter 22: Ten Database Design Tips

Download Here