Microsoft SQL Server 2008 For Dummies

Передня обкладинка
John Wiley & Sons, 6 січ. 2009 р. - 408 стор.
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!

 

Відгуки відвідувачів - Написати рецензію

Good Overview

Рецензія користувача  - dogmeat123 - Overstock.com

Good overview of features. Information is clearly explained. Need some background in databases and SQL server. Читати огляд повністю

Зміст

Introduction
1
Welcome to SQL Server 2008
7
Introducing SQL Server 2008
9
Building Your SQL Server
19
Working with SQL Server Tools
35
Building SQL Server 2008 Databases
49
Creating Databases and Tables
73
Imposing Constraints and Relationships
91
Improving Performance with Partitions
198
Automating SQL Server 2008 Administration
213
Troubleshooting SQL Server 2008 Problems
233
Monitoring Your Server with Performance Studio
241
Replicating Data across Multiple Servers
249
Protecting Your Data
269
Preserving the Integrity of Your Transactions
293
Preparing for Disaster
305

Retrieving Data from Databases
107
Joins and Other Advanced Queries
127
Turning Data into Information with SQL Server
143
Inserting and Manipulating Your Data
159
Saving Time with Functions
175
Saving Time with Functions Stored Procedures and Triggers 175 Part V SQL Server Administration
191
Staying Alive High Availability in SQL Server 2008
323
Implementing PolicyBased Management with the Declarative
339
Ten Ways to Keep Your SQL Server 2008 Databases Humming
353
Ten Database Design Tips
359
Авторські права

Інші видання - Показати все

Загальні терміни та фрази

Про автора (2009)

Mike Chapple, MCDBA, CISA, CISSP, is an IT professional at the University of Notre Dame, where he teaches a computer applications course. He is a coauthor of the CISSP Study Guide.

Бібліографічна інформація