book

Microsoft® SQL Server® 2008 For Dummies®

Name: Microsoft® SQL Server® 2008 For Dummies®
Author: Mike Chapple
ISBN: 9780470224656

by Mike Chapple

September 2008

Beginner

408 pages

7h 35m

English

For Dummies

Read now

Unlock full access

Copyright
About the Author
Author's Acknowledgments
Introduction
About This BookConventions Used in This BookWhat You Are Not to ReadFoolish AssumptionsHow This Book Is OrganizedIcons Used in This BookWhere to Go from Here
I. Welcome to SQL Server 2008
1. Introducing SQL Server 2008
1.1. Starting Off on the Right Foot1.1.1. Examining SQL Server editions1.1.2. Checking system requirements1.2. Understanding the Basic Components of SQL Server1.2.1. SQL and Transact-SQL1.2.2. SQL Server components1.3. Implementing Databases with SQL Server 20081.3.1. Setting up your server1.3.2. Stocking it with databases1.3.3. Accessing and updating your data1.3.4. Managing and protecting what you've built1.4. What's New in SQL Server 20081.4.1. Declarative Management Framework1.4.2. Encryption and Auditing1.4.3. Resource conservation1.4.4. Date/Time Data Types
2. Building Your SQL Server
2.1. Installing SQL Server 20082.1.1. Choosing between default and named instances2.1.2. Selecting an authentication mode2.1.3. Choosing service accounts2.1.4. Selecting the collation2.1.5. Performing the installation2.2. Upgrading an Existing SQL Server Installation2.2.1. Preparing for an upgrade with Upgrade Advisor2.2.2. Upgrading Your Installation2.3. Configuring Database Mail2.4. Using SQL Server's Built-In Databases2.4.1. Master database2.4.2. The msdb database2.4.3. The model database2.4.4. The tempdb database
3. Working with SQL Server Tools
3.1. Using SQL Server Configuration Manager3.1.1. Launching SQL Server Configuration Manager3.1.2. Starting and stopping services3.1.3. Changing service accounts3.1.4. Changing service start modes3.1.5. Modifying networking settings3.2. Managing Your Server with SQL Server Management Studio3.2.1. Starting SSMS and connecting to an instance3.2.2. Exploring the SSMS Interface3.2.3. Issuing Transact-SQL queries3.3. Working from the Command Line
II. Building SQL Server 2008 Databases
4. Planning Your Database
4.1. Introducing Database Design Concepts4.2. Understanding the Elements of a Database4.2.1. Database servers4.3. Organizing a Database4.3.1. Defining your database objectives4.3.2. Grouping data into tables4.3.3. Selecting primary keys4.3.4. Linking related tables4.4. Diagramming Your Database4.5. Staying Fit and Trim with Normalization4.5.1. First normal form4.5.2. Second and third normal forms4.6. Choosing Data Types for Your Tables4.6.1. Numeric data types4.6.2. Date and time data types4.6.3. Character string data types4.6.4. Binary data types4.6.5. Other data types4.7. Working with NULL Values

5. Creating Databases and Tables
5.1. Creating a Database5.1.1. Altering database properties5.1.2. Deleting or renaming a database5.2. Specifying Files and Filegroups5.2.1. SQL Server files5.2.2. Using filegroups5.3. Creating a Table5.3.1. Getting started5.3.2. Adding columns5.3.3. Selecting a primary key5.3.4. Modifying tables5.3.5. Deleting tables
6. Imposing Constraints and Relationships
6.1. Introducing Constraints6.2. Controlling Database Contents Using Constraints6.2.1. Filling in empty values with DEFAULT constraints6.3. Enforcing Database Integrity6.3.1. Enforcing uniqueness6.3.2. Enforcing referential integrity with FOREIGN KEY constraints
III. Retrieving Data from Databases
7. Constructing Simple Database Queries
7.1. Retrieving Data with SELECT Statements7.1.1. The SELECT...FROM clause7.1.2. The WHERE clause7.2. Organizing Query Results7.2.1. Sorting output7.2.2. Summarizing data with aggregate functions7.2.3. Grouping results7.2.4. Renaming columns in your output
8. Joins and Other Advanced Queries
8.1. Joining Data from Multiple Tables8.1.1. Matching records with INNER JOINs8.1.2. Including nonmatching records with OUTER JOINs8.1.3. Joining a table with itself8.2. Taking SELECT to the Next Level8.2.1. Computing values8.2.2. Managing complexity with subqueries8.2.3. Dealing with different cases8.3. Using Database Views8.3.1. Creating a view8.3.2. Modifying a view8.3.3. Deleting a view
9. Turning Data into Information with SQL Server Reporting Services
9.1. Setting up SQL Server Reporting Services9.2. Creating an SSRS Report with Report Builder9.2.1. Installing and starting Report Builder 2.09.2.2. Choosing a data source and data set9.2.3. Laying out the report9.2.4. Publishing the report9.3. Working with Deployed (Published) Reports9.3.1. Viewing reports9.3.2. Configuring report security
IV. Inserting and Manipulating Your Data
10. Inserting, Updating, and Deleting Data
10.1. Inserting Small Quantities of Data10.1.1. Understanding simple data entry10.1.2. Writing INSERT statements10.2. Modifying and Deleting Data10.2.1. Modifying data with UPDATE10.2.2. Removing data from a database10.3. Importing Large Quantities of Data10.3.1. Inserting query results10.3.2. Copying bulk data with BULK INSERT10.3.3. Performing blk operations from the command line with bcp10.4. Working with SQL Server Integration Services
11. Saving Time with Functions, Stored Procedures, and Triggers
11.1. Reusing Logic with Functions11.1.1. Understanding types of functions11.2. Leveraging SQL Server's built-in functions11.2.1. Calling built-in functions11.2.2. Obtaining a list of built-in functions11.3. Creating Your Own Functions11.4. Reusing SQL Code with Stored Procedures11.4.1. Saving time with system stored procedures11.4.2. Writing your own stored procedures11.5. Updating Data Automatically with Triggers11.5.1. Creating a trigger11.5.2. Disabling a trigger11.6. Modifying and Deleting Functions, Stored Procedures, and Triggers11.6.1. Modifying objects11.6.2. Deleting objects
V. SQL Server Administration
12. Keeping Your SQL Server Running Smoothly
12.1. Indexing Data to Improve Query Performance12.1.1. Using clustered indexes12.1.2. Creating nonclustered indexes12.1.3. Optimizing index performance12.2. Improving Performance with Partitions12.2.1. Creating a partition function12.2.2. Creating a partition scheme12.2.3. Creating a partitioned table12.3. Updating Database Statistics12.3.1. Automatically updating statistics12.3.2. Manually updating statistics12.4. Managing File Sizes12.4.1. Automatically shrinking database files12.4.2. Manually shrinking a single database file12.4.3. Manually shrinking all files associated with a database12.5. Checking Database Integrity12.5.1. Running DBCC CHECKDB12.5.2. Correcting integrity errors12.6. Governing Resource Consumption12.6.1. Creating resource pools12.6.2. Creating workload groups12.6.3. Creating classifier functions12.6.4. Activating and deactivating Resource Governor
13. Automating SQL Server 2008 Administration
13.1. Scheduling Tasks with SQL Server Agent13.1.1. Starting SQL Server Agent13.1.2. Creating a SQL Server Agent job13.1.3. Adding job steps to a SQL Server Agent job13.1.4. Scheduling a SQL Server Agent job13.1.5. Notifying someone when the job completes13.2. Implementing Database Maintenance Plans13.2.1. Identifying the tasks to include in a maintenance plan13.2.2. Creating a maintenance plan13.3. Alerting Administrators about Database Events13.3.1. Configuring database operators13.3.2. Creating SQL Server alerts
14. Troubleshooting SQL Server 2008 Problems
14.1. Understanding the Inner Workings of SQL Server Queries14.1.1. Creating a trace with SQL Server Profiler14.1.2. Reviewing trace results14.2. Reviewing Log Records14.2.1. SQL Server error log14.2.2. Windows Application Log14.2.3. SQL Server Management Studio Log File Viewer14.3. Monitoring Your Server with Performance Studio14.3.1. Configuring Performance Studio14.3.2. Reviewing performance data14.4. Tuning Your Database with Database Engine Tuning Advisor
15. Replicating Data across Multiple Servers
15.1. Understanding Replication15.1.1. Server roles15.1.2. Articles and publications15.1.3. Replication types15.2. Publishing Data with Snapshot Replication15.2.1. Creating a distributor15.2.2. Creating a publication15.3. Subscribing to a Publication15.4. Monitoring Replication
VI. Protecting Your Data
16. Protecting Your Data from Prying Eyes
16.1. Creating and Managing Logins16.1.1. Creating server logins16.1.2. Removing database logins16.2. Adding Database Users16.3. Managing Rights with Roles16.3.1. Understanding fixed server roles16.3.2. Understanding fixed database roles16.3.3. Creating database roles16.3.4. Assigning users to database roles16.4. Preserving Confidentiality with Encryption16.4.1. Encrypting database connections16.4.2. Encrypting stored data16.5. Auditing SQL Server Activity16.5.1. Enabling and configuring auditing16.5.2. Reviewing audit records
17. Preserving the Integrity of Your Transactions
17.1. Preserving Transaction Integrity with the ACID Model17.1.1. Atomicity17.1.2. Consistency17.1.3. Isolation17.1.4. Durability17.2. Creating SQL Server Transactions17.2.1. COMMIT or ROLLBACK?17.2.2. Testing Transact-SQL statements with transactions17.3. Changing the Transaction Isolation Level17.3.1. READ UNCOMMITTED17.3.2. READ COMMITTED17.3.3. REPEATABLE READ17.3.4. SERIALIZABLE17.3.5. SNAPSHOT17.4. Handling Errors
18. Preparing for Disaster
18.1. Backing Up Your Data18.1.1. Backing up databases18.1.2. Saving time with differential backups18.1.3. Saving space with backup compression18.1.4. Backing up the transaction log18.2. Specifying Disaster Recovery Requirements with Recovery Models18.2.1. Choosing a recovery model18.2.2. Changing recovery models18.3. Restoring Your Data after a Disaster18.4. Using Database Snapshots18.4.1. Creating a database snapshot18.4.2. Accessing a database snapshot18.4.3. Reverting to a database snapshot
19. Staying Alive: High Availability in SQL Server 2008
19.1. Creating Redundancy with Database Mirroring19.1.1. Choosing an operating mode19.1.2. Configuring mirroring19.1.3. Monitoring Database Mirroring19.1.4. Failing over a mirrored database19.2. Synchronizing Databases with Log Shipping19.2.1. Configuring log shipping19.2.2. Failing over to a log shipping secondary instance
20. Implementing Policy-Based Management with the Declarative Management Framework
20.1. Coming to Terms with DMF20.2. Creating DMF Policies20.2.1. Creating a condition20.2.2. Creating a policy20.3. Using On Demand Evaluation Mode20.3.1. Verifying policy compliance20.3.2. Enforcing a policy manually20.4. Automated Policy Enforcement20.5. Viewing Policies Affecting a Target
VII. The Part of Tens
21. Ten Ways to Keep Your SQL Server 2008 Databases Humming
21.1. Monitor Query Performance21.2. Back Up Your Data Routinely21.3. Verify Database Integrity Often21.4. Tune the Physical Structure of Your Databases21.5. Conserve Transaction Log Disk Space21.6. Monitor Database Logs21.7. Automate Administrative Alerts21.8. Manage Multiple Servers21.9. Simplify User Rights Administration with Roles21.10. Perform Security Reviews
22. Ten Database Design Tips
22.1. Plan Ahead22.2. Draw Before You Click22.3. Choose Primary Keys Carefully22.4. Select Data Types with Space Efficiency in Mind22.5. Make Sure Your Fields Are Single Purpose22.6. Remember the Meaning of NULL22.7. Normalize when Possible22.8. Manage Your Relationships22.9. Use Descriptive Names22.10. Document Your Design

Overview

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!

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9780470224656Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills