Microsoft SQL Server 2005 For Dummies,9780764577550

Microsoft SQL Server 2005 For Dummies

by
ISBN13: 9780764577550
ISBN10: 0764577557
Format: Paperback
Pub. Date: 2006-02-06
Publisher(s): For Dummies
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $33.59

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Buy from our Marketplace starting at $19.65

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

Now updated to reflect the much-anticipated "Yukon" release of SQL Server, this friendly guide shows database developers and administrators as well as those who use database application how to get up to speed fast Offers a gentle introduction to relational database design and shows how to build databases, create database applications, and maintain and optimize database performance Covers the major new features of the "Yukon" release-including analysis services, reporting services, and notification services

Author Biography

<b>Andrew Watt</b> (Scotland, UK) is a Microsoft Most Valuable Professional (MVP). He specializes in Microsoft technologies, including the SQL Server database and InfoPath. He is an independent consultant and experienced computer book author. He first used SQL Server in version 7.0. He is using SQL Server 2005 beta in the beta programs since August 2003.

Table of Contents

Introduction 1(1)
About This Book
2(1)
Foolish Assumptions
2(1)
Conventions Used in This Book
3(1)
How This Book Is Organized
3(2)
Part I: SQL Server 2005: An Overview
3(1)
Part II: Basic Operations
3(1)
Part III: Working with SQL Server
3(1)
Part IV: Protecting Your Data
4(1)
Part V: Administering a SQL Server System
4(1)
Part VI: Using SQL Server Business Intelligence (BI) Services
4(1)
Part VII: The Part of Tens
4(1)
About the Web site
5(1)
Icons Used in This Book
5(1)
Where to Go from Here
5(2)
Part I: SQL Server 2005: An Overview
7(44)
Introducing SQL Server 2005
9(12)
Getting to Know SQL Server 2005
9(1)
A Client-Server Database
10(1)
OLTP
10(1)
OLAP
11(1)
A Secure Database
11(1)
A Programmable Database
12(2)
Transact-SQL
13(1)
SQL Server Management Studio
13(1)
Business Intelligence Development Studio
14(1)
A Scalable Database
14(1)
An Available Database
15(1)
Miscellaneous changes
15(1)
Online indexing
16(1)
Online page and file restore
16(1)
A Reliable Database
16(1)
Backing up data
16(1)
Replication
17(1)
A Manageable Database
17(1)
Command-line tools
18(1)
Graphical tools
18(1)
SQL Server Agent
18(1)
Performance tools
18(1)
A Database That Supports Business Intelligence
18(3)
New Features in SQL Server 2005
21(14)
Security Enhancements
22(1)
System catalog security
22(1)
Password policy enforcement
22(1)
Schema and user separation
22(1)
Automated certificate creation for SSL
23(1)
Transact-SQL Enhancements
23(1)
Improved XML support
23(1)
Error handling
23(1)
Transact-SQL templates
24(1)
Other Developer-Orientated Enhancements
24(2)
Support for the Common Language Runtime
24(1)
New datatypes
25(1)
SQL Management Objects (SMO)
25(1)
Scripting actions
25(1)
HTTP endpoints
26(1)
Manageability Enhancements
26(3)
New management tools
26(1)
Profiler
27(1)
SQL Server Agent
27(1)
Dynamic configuration
27(1)
Full-text search
28(1)
SQL Server Service Broker
28(1)
Dedicated Administrator connection
28(1)
SQLCMD
28(1)
Easier updates
29(1)
Replication
29(1)
WMI configuration
29(1)
Database Mail
29(1)
Availability Enhancements
29(2)
Concurrent data access
30(1)
Availability after server failure
30(1)
Availability during database maintenance
30(1)
Scalability Enhancements
31(1)
Installing in a cluster
31(1)
Partitioning data
31(1)
Database Engine Tuning Advisor
32(1)
Hot-add memory support
32(1)
Replication
32(1)
Business Intelligence Enhancements
32(3)
Integration Services
33(1)
Analysis Services
33(1)
Reporting Services
33(2)
Introducing and Configuring Management Studio
35(16)
Starting Management Studio and Connecting to SQL Server
36(1)
Using Registered Servers
36(2)
Exploring Database Objects Using the Object Explorer
38(5)
View and modify database properties
39(2)
Security
41(1)
Replication
42(1)
Getting an Overview on the Summary Tab
43(2)
Asking Questions in the Query Pane
45(1)
Customizing the Environment
46(5)
Setting Startup options
47(1)
Displaying results
47(1)
Keyboard shortcuts
48(1)
Restoring the default configuration
49(1)
Using templates in Management Studio
49(2)
Part II: Basic Operations
51(48)
Creating Databases, Tables, and Relationships with T-SQL
53(14)
Firing Up SQL Server 2005
54(1)
Exploring the Object Explorer
55(2)
Creating Databases
57(1)
Creating Tables
58(3)
Defining Relationships
61(2)
Adding Constraints
63(2)
Adding Data to the Database
65(2)
Asking Questions and Getting Answers
67(20)
Using the Query Editor
67(2)
Using the Select Statement
69(3)
Filtering with the Where Clause
72(3)
Sorting with Order By
75(2)
Retrieving Data from Multiple Tables
77(4)
Joins
81(2)
Modifying a Template
83(4)
Building a Simple Application
87(12)
Designing the Application
88(2)
Creating a New Project
90(2)
Building the Connection to the Data
92(4)
Building the User Interface
96(1)
Debugging the Application
97(2)
Part III: Working with SQL Server
99(56)
Working with XML
101(20)
Introducing XML
102(2)
XML and SQL Server 2000
103(1)
XML and SQL Server 2005
103(1)
The xml datatype
104(1)
Creating XML Documents and Fragments
104(1)
Using Untyped and Typed XML
105(8)
Using untyped XML
105(3)
Understanding the XML Schema Definition language
108(2)
Using typed XML
110(3)
Querying XML
113(3)
Understanding XQuery
113(3)
Creating indexes for the xml datatype
116(1)
Using the XML Data Modification Language
116(2)
Converting Data to and from XML
118(3)
Using the For XML statement
119(1)
Using the OPENXML keyword
120(1)
Using the Common Language Runtime
121(10)
Introducing CLR Integration
122(3)
Development
123(1)
Manual coding and deployment
123(2)
Comparison with Traditional Approaches
125(4)
Potential benefits of CLR integration
126(1)
CLR and T-SQL comparison
127(1)
CLR and extended stored procedure comparison
128(1)
CLR and middle tier comparison
129(1)
CLR Code Access Security
129(2)
Using Stored Procedures
131(12)
What a Stored Procedure Is
131(6)
Types of stored procedure
132(1)
What a stored procedure does
132(1)
Reasons to use a stored procedure
133(1)
System stored procedures
134(3)
Creating a Stored Procedure
137(4)
Creating a procedure without parameters
138(1)
Creating a stored procedure with a parameter
139(1)
Naming stored procedures
140(1)
Calling a Stored Procedure
141(1)
CLR Stored Procedures
141(2)
Error Handling in T-SQL
143(12)
Handling Errors with T-SQL
143(1)
The Try...Catch Construct
144(1)
Rules for the Try...Catch construct
144(1)
Error message severity levels
144(1)
Using Error Functions
145(10)
Using error codes
147(2)
Raiserror
149(1)
Using nested Try...Catch constructs
150(1)
@@Error
151(4)
Part IV: Protecting Your Data
155(54)
Securing Your Data
157(16)
Introducing The New Security Model
158(7)
Security terminology
159(1)
Principals hierarchy
159(1)
Securables hierarchy
159(1)
New security features
160(1)
Granular permissions control
161(1)
Permissions basics
161(1)
Permission levels
162(1)
How permissions apply to specific securables
162(3)
Working with the New Security Model
165(7)
Logins and users
166(1)
Separation of users and schemas
166(1)
The default schema
167(1)
Granting permissions to a user
168(2)
Module Execution Context
170(1)
Catalog security
170(1)
Password policy enforcement
170(2)
Using Common Language Runtime Security
172(1)
Availability and Preventing Data Loss
173(12)
Availability Overview
174(1)
Reducing Downtime with Database Mirroring
174(4)
Database mirroring overview
175(1)
Transparent client redirect
176(1)
Database views
176(1)
Differences from failover clustering
176(1)
Similarities to failover clustering
177(1)
Recovery models
177(1)
Speeding Recovery with Checkpointing
178(1)
Automatic checkpoints
178(1)
Setting the recovery interval
179(1)
Using Failover Clustering
179(1)
Database Snapshots
180(3)
Naming database snapshots
181(1)
Creating a database snapshot
181(1)
Deleting unwanted database snapshots
182(1)
Reverting to a database snapshot
182(1)
Backing Up and Restoring Data
183(2)
Assessing the risks to protect against
183(1)
Backing up data
183(1)
Checking backups
184(1)
Restoring data
184(1)
Maintaining Integrity with Transactions
185(6)
Understanding Transactions
186(1)
ACID
186(1)
The transaction log
186(1)
Coding Transactions
187(4)
A simple update
187(1)
A simple transaction
187(3)
Implicit transactions
190(1)
Maintaining Data Integrity with Constraints and Triggers
191(18)
Understanding Constraints, Defaults, Rules, and Triggers
192(4)
Constraints
192(1)
Defaults
192(2)
Rules
194(1)
Triggers
195(1)
Using Check Constraints
196(5)
Creating a check constraint visually
197(3)
Dropping a check constraint visually
200(1)
Creating a check constraint with T-SQL
200(1)
DDL Triggers
201(4)
Preventing undesired changes
201(2)
Auditing changes
203(2)
DML Triggers
205(4)
The inserted and deleted tables
206(1)
Triggers for auditing DML
206(3)
Part V: Administering a SQL Server System
209(96)
Configuring a SQL Server System
211(20)
Using SQL Server Configuration Manager
211(12)
Adding SQL Server Configuration Manager to an MMC console
213(3)
Managing SQL Server services
216(3)
Connecting to a remote computer
219(2)
Configuring network protocols
221(2)
Configuring client computers
223(1)
Configuring Using SQLCMD
223(5)
Getting started with SQLCMD
223(3)
Executing a T-SQL script with SQLCMD
226(1)
Logging in as a specified user
226(1)
Connecting to a remote SQL server instance
227(1)
Configuring Using SQL Server Management Studio
228(3)
SQL Server instance level configuration
228(1)
Configuring at the database level
229(2)
Scheduling SQL Server Agent Jobs
231(22)
Introducing SQL Server Agent
232(5)
Managing Agent from SQL Server Management Studio
232(2)
Starting and stopping SQL Server Agent
234(1)
Setting SQL Agent to start automatically
234(3)
Using Agent in Business Intelligence
237(1)
Security
237(3)
Permissions for SQL Agent
237(1)
Permissions for users
238(2)
Configuring SQL Server Agent
240(3)
Windows permissions
240(2)
Enabling SQL Agent extended stored procedures
242(1)
Creating Jobs and Alerts
243(7)
Creating a SQL Agent job
243(6)
Creating a SQL Agent alert
249(1)
Using T-SQL with SQL Server Agent
250(1)
Using the Maintenance Plan Wizard
250(3)
Sending Information Using Notification Services
253(8)
The Notification Services Approach
254(3)
The basic steps
254(1)
New notification features in SQL Server 2005
255(1)
How Notification Services works
255(1)
Working with events
256(1)
Application Definition and Instance Configuration Files
257(4)
The Application Definition file
257(2)
The Instance Configuration file
259(2)
Maintaining a SQL Server System
261(22)
Using Maintenance Plans
261(9)
Backing up
262(8)
Different types of backup
270(1)
Restoring from backups
270(1)
Checking Error Logs
270(4)
Working with Indexes
274(3)
Halting Runaway Queries with the Dedicated Administrator Connection
277(1)
Looking under the Covers with Profiler
278(2)
Using the Database Engine Tuning Advisor
280(3)
Working with Multiple Servers
283(22)
Replication Overview
284(2)
Replication jargon
284(1)
Replication enhancements in SQL Server 2005
285(1)
Security for replication
285(1)
Replicating Your Data
286(15)
Setting up a publisher and distributor
286(7)
Creating a new publication
293(4)
Creating a subscription
297(4)
Introducing Service Broker
301(4)
Queues
302(1)
Messages
302(1)
Behind the scenes
303(1)
Security
304(1)
Part VI: Using SQL Server Business Intelligence (BI) Services
305(72)
SQL Server Integration Services
307(30)
Overview of Business Intelligence
308(1)
Business intelligence tools
308(1)
Data warehouses
308(1)
Integration Services Overview
309(7)
Creating an Integration Services package
310(1)
Sources
311(1)
Transformations
312(2)
Destinations
314(1)
Task flows
315(1)
Error flows
315(1)
Event handling
315(1)
Logging options
315(1)
Package restart
316(1)
Digital signing
316(1)
Business Intelligence Development Studio
316(5)
The Control Flow tab
317(2)
The Data Flow tab
319(1)
The Event Handlers tab
319(1)
The Package Explorer tab
320(1)
The Toolbox
321(1)
The Solution Explorer
321(1)
Import/Export Wizard
321(8)
Creating an Integration Services Project
329(7)
Deploying an Integration Services Project
336(1)
Analysis Services
337(22)
Introducing Analysis Services
337(4)
New features in Analysis Services 2005
338(1)
Key Performance Indicators
339(1)
Managing Analysis Services
340(1)
Business Intelligence Development Studio and Analysis Services
341(1)
Creating an Analysis Services Project
342(16)
Data Mining
358(1)
Building Business Reports with Reporting Services
359(18)
Overview of Reporting Services
360(1)
Replicating to a Report Server
361(1)
Database mirroring and database views
361(1)
Creating Reports
361(9)
Viewing Reports
370(1)
Managing Reports
371(1)
Managing in Report Manager
371(1)
Managing in SQL Server Management Studio
372(1)
Distributing reports to those who need them
372(1)
Report Definition Language
372(1)
Report Builder
373(2)
Report Viewer Controls
375(2)
Part VII: The Part of Tens
377(10)
Ten Sources of Information on SQL Server 2005
379(4)
Books Online
379(1)
The Public Newsgroups
380(1)
Microsoft Forums
380(1)
The SQL Server 2005 Web Site
380(1)
The SQL Server Developer Center
381(1)
The Business Intelligence Site
381(1)
The Integration Services Developer Center
381(1)
The Reporting Services Web Site
381(1)
Channel 9
382(1)
Other Web Sites
382(1)
Products that Work with SQL Server 2005
383(4)
Visual Studio 2005
383(1)
Microsoft Office InfoPath 2003
384(1)
Red-Gate Tools
384(1)
Quest Software
384(1)
PromptSQL
385(2)
Index 387

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.