• No results found

Microsoft SQL Server 2008 Bible

N/A
N/A
Protected

Academic year: 2021

Share "Microsoft SQL Server 2008 Bible"

Copied!
5
0
0

Loading.... (view fulltext now)

Full text

(1)

Brochure

More information from http://www.researchandmarkets.com/reports/1093469/

Microsoft SQL Server 2008 Bible

Description: Harness the power of SQL Server, Microsoft’s high-performance database and data analysis software package, by accesing everything you need to know in Microsoft SQL Server 2008 Bible. Learn the best practices, tips, and tricks from this comprehensive tutorial and reference, which includes specific examples and sample code, with nearly every task demonstrated in both a graphical and SQL code method. Understand how to develop SQL Server databases and data connections, how to administer the SQL Server and keep databases performing optimally, and how to navigate all the new features of the 2008 release.

Contents: Foreword. Introduction.

Part I Laying the Foundation.

Chapter 1: The World of SQL Server. Chapter 2: Data Architecture.

Chapter 3: Relational Database Design. Chapter 4: Installing SQL Server 2008. Chapter 5: Client Connectivity.

Chapter 6: Using Management Studio. Chapter 7: Scripting with PowerShell. Part II Manipulating Data with Select. Chapter 8: Introducing Basic Query Flow.

Chapter 9: Data Types, Expressions, and Scalar Functions. Chapter 10: Merging Data with Joins and Unions.

Chapter 11: Including Data with Subqueries and CTEs. Chapter 12: Aggregating Data.

Chapter 13: Windowing and Ranking. Chapter 14: Projecting Data Through Views. Chapter 15: Modifying Data.

Chapter 16: Modification Obstacles. Part III Beyond Relational.

Chapter 17: Traversing Hierarchies. Chapter 18: Manipulating XML Data.

Chapter 19: Using Integrated Full-Text Search. Part IV Developing with SQL Server.

Chapter 20: Creating the Physical Database Schema. Chapter 21: Programming with T-SQL.

Chapter 22: Kill the Cursor! Chapter 23: T-SQL Error Handling.

Chapter 24: Developing Stored Procedures. Chapter 25: Building User-Defined Functions. Chapter 26: Creating DML Triggers.

Chapter 27: DDL Triggers.

Chapter 28: Building Out the Data Abstraction Layer. Chapter 29: Dynamic SQL and Code Generation. Part V Data Connectivity.

Chapter 30: Bulk Operations.

Chapter 31: Executing Distributed Queries. Chapter 32: Programming with ADO.NET 3.5. Chapter 33: Sync Framework.

(2)

Chapter 35: Asynchronous Messaging with Service Broker. Chapter 36: Replicating Data.

Chapter 37: Performing ETL with Integration Services. Chapter 38: Access as a Front End to SQL Server. Part VI Enterprise Data Management.

Chapter 39: Configuring SQL Server. Chapter 40: Policy-Based Management. Chapter 41: Recovery Planning.

Chapter 42: Maintaining the Database.

Chapter 43: Automating Database Maintenance with SQL Server Agent. Chapter 44: Transferring Databases.

Chapter 45: Database Snapshots. Chapter 46: Log Shipping.

Chapter 47: Database Mirroring. Chapter 48: Clustering.

Part VII Security.

Chapter 49: Authenticating Principals. Chapter 50: Authorizing Securables. Chapter 51: Data Cryptography. Chapter 52: Row-Level Security. Part VIII Monitoring and Auditing. Chapter 53: Data Audit Triggers. Chapter 54: Schema Audit Triggers. Chapter 55: Performance Monitor. Chapter 56: Tracing and Profiling. Chapter 57: Wait States.

Chapter 58: Extended Events. Chapter 59: Change Tracking. Chapter 60: Change Data Capture. Chapter 61: SQL Audit.

Chapter 62: Management Data Warehouse. Part IX Performance Tuning and Optimization. Chapter 63: Interpreting Query Execution Plans. Chapter 64: Indexing Strategies.

Chapter 65: Query Plan Reuse.

Chapter 66: Managing Transactions, Locking, and Blocking. Chapter 67: Data Compression.

Chapter 68: Partitioning.

Chapter 69: Resource Governor. Part X Business Intelligence. Chapter 70: BI Design.

Chapter 71: Building Multidimensional Cubes with Analysis Services. Chapter 72: Programming MDX Queries.

Chapter 73: Authoring Reports with Reporting Services. Chapter 74: Administering Reporting Services.

Chapter 75: Analyzing Data with Excel.

Chapter 76: Data Mining with Analysis Services. Appendix A: SQL Server 2008 Specifications. Appendix B: Using the Sample Databases. Index.

(3)

Order by Fax - using the form below

Order by Post - print the order form below and sent to Research and Markets,

Guinness Centre, Taylors Lane, Dublin 8, Ireland.

(4)

Page 1 of 2

Fax Order Form

To place an order via fax simply print this form, fill in the information below and fax the completed form to 646-607-1907 (from USA) or +353-1-481-1716 (from Rest of World). If you have any questions please visit

http://www.researchandmarkets.com/contact/

Order Information

Please verify that the product information is correct.

Product Format

Please select the product format and quantity you require:

Contact Information

Please enter all the information below in BLOCK CAPITALS

Product Name: Microsoft SQL Server 2008 Bible

Web Address: http://www.researchandmarkets.com/reports/1093469/

Office Code: OC8HORPQMRVQQ

Quantity

Hard Copy: EURO €39.00 + Euro €25.00 Shipping/Handling

Title: Mr Mrs Dr Miss Ms Prof

First Name: Last Name:

Email Address: * Job Title:

Organisation: Address: City:

Postal / Zip Code: Country:

Phone Number: Fax Number:

(5)

Page 2 of 2

Payment Information

Please indicate the payment method you would like to use by selecting the appropriate box.

Please fax this form to:

(646) 607-1907 or (646) 964-6609 - From USA

+353 1 481 1716 or +353 1 653 1571 - From Rest of World

Pay by credit card: American Express

Diners Club Master Card Visa Cardholder's Name Cardholder's Signature Expiry Date Card Number CVV Number Issue Date

(for Diners Club only)

Pay by check: Please post the check, accompanied by this form, to: Research and Markets,

Guinness Center, Taylors Lane, Dublin 8, Ireland.

Pay by wire transfer: Please transfer funds to:

Account number 833 130 83

Sort code 98-53-30

Swift code ULSBIE2D

IBAN number IE78ULSB98533083313083 Bank Address Ulster Bank,

27-35 Main Street, Blackrock,

Co. Dublin, Ireland.

If you have a Marketing Code please enter it below:

Marketing Code:

Please note that by ordering from Research and Markets you are agreeing to our Terms and Conditions at http://www.researchandmarkets.com/info/terms.asp

References

Related documents

Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL

Delegates will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL

Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server

If you cannot make a backup of your database and the software has not been making automatic backups, then you can copy the database file directly from the SQL Server data.. If

1 On the SQL Server that hosts the new Enterprise PDM databases, from the Windows Start menu, click All Programs, Microsoft SQL Server 2005, SQL Server Management Studio.. 2 Log in

enhancements and new features that have been added to SQL Server and the Microsoft data platform since the release of SQL Server 2008.. The course focuses on teaching individuals

Module 13: Monitoring SQL Server 2014 by Using Alerts and Notifications This module covers the configuration of database mail, alerts, and

Module 13: Monitoring SQL Server 2014 by Using Alerts and Notifications This module covers the configuration of database mail, alerts, and