Programming SQL Server 2005 - Helion

ebook

Autor: Bill Hamilton
ISBN: 978-14-493-9092-1
stron: 588, Format: ebook
Data wydania: 2006-02-21
Księgarnia: Helion

Cena książki: 169,14 zł (poprzednio: 198,99 zł)
Oszczędzasz: 15% (-29,85 zł)

Osoby, które kupiły tę książkę, wybierały także »

Tagi: SQL Server

SQL Server 2005, Microsoft's next-generation data management and analysis solution, represents a huge leap forward. It comes with a myriad of changes that deliver increased security, scalability, and power--making it the complete data package. Used properly, SQL Server 2005 can help organizations of all sizes meet their data challenges head on.

Programming SQL Server 2005 from O'Reilly provides a practical look at this updated version of Microsoft's premier database product. It guides you through all the new features, explaining how they work and how to use them. The first half of the book examines the changes and new features of the SQL Server Engine itself. The second addresses the enhanced features and tools of the platform, including the new services blended into this popular version. Each chapter contains numerous code samples-written in C# and compiled using the Visual Studio 2005 development environment-that show you exactly how to program SQL Server 2005.

Programming SQL Server 2005 can help you:

Build, deploy, and manage enterprise applications that are more secure, scalable, and reliable
Maximize IT productivity by reducing the complexity of building, deploying, and managing database applications
Share data across multiple platforms, applications, and devices to make it easier to connect internal and external systems

Because the goal of Programming SQL Server 2005 is to introduce all facets of Programming SQL Server 2005, it's beneficial to programmers of all levels. The book can be used as a primer by developers with little experience with SQL Server, as a ramp up to the new programming models for SQL Server 2005 for more experienced programmers, or as background and primer to specific concepts.

Any IT professional who wants to learn about SQL Server 2005's comprehensive feature set, interoperability with existing systems, and automation of routine tasks will find the answers in this authoritative guide.

Osoby które kupowały "Programming SQL Server 2005", wybierały także:

SQL. Kurs video. Kompendium wiedzy na podstawie MySQL 159,00 zł, (63,60 zł -60%)
Microsoft SQL Server. Kurs video. Tworzenie zaawansowanych zapytań 198,98 zł, (79,59 zł -60%)
T-SQL. Kurs video. Wykorzystanie baz danych przy użyciu niekonwencjonalnych rozwiązań. Sztuczki i gotowe rozwiązania 39,89 zł, (17,95 zł -55%)
Microsoft SQL Server. Tworzenie baz danych i zarządzanie nimi. Kurs video 79,00 zł, (35,55 zł -55%)
MS SQL Server. Zaawansowane metody programowania. Wydanie II 119,00 zł, (59,50 zł -50%)

Spis treści

Programming SQL Server 2005 eBook -- spis treści

Programming SQL Server 2005
- SPECIAL OFFER: Upgrade this ebook with OReilly
- A Note Regarding Supplemental Files
- Preface
  - What You Need to Use This Book
  - Conventions Used in This Book
  - How to Contact Us
  - Safari Enabled
  - Acknowledgments
- 1. Introduction
  - Contents of This Book
  - Whats Not in This Book
- 2. Tools and Utilities
  - SQL Server Management Studio
    - Registered Servers
    - Object Explorer
      - Database server instance
      - Databases node
      - Security node
      - Server Objects node
      - Replication node
      - Management node
      - Notification Services node
      - SQL Server Agent node
    - Template Explorer
    - Solution Explorer
  - SQL Server Configuration Manager
  - SQL Server Surface Area Configuration
  - Database Engine Tuning Advisor
  - SQL Server Profiler
  - SQL Server Business Intelligence Development Studio
  - Visual Studio 2005
  - New Command-Line Utilities
    - - SQL Server command-line tool (sqlcmd utility)
- 3. T-SQL Enhancements
  - New Data Types
    - The xml Data Type
    - Large Value Data Types
  - T-SQL Language Enhancements
    - TOP
    - TABLESAMPLE
    - OUTPUT
    - Common Table Expressions (CTEs)
    - SOME and ANY
    - ALL
    - PIVOT and UNPIVOT
    - APPLY
    - EXECUTE AS
    - New Ranking Functions
      - ROW_NUMBER( )
      - DENSE_RANK( )
      - NTILE( )
    - Error Handling
  - Data Definition Language (DDL) Triggers
  - Metadata
- 4. Introduction to Common Language Runtime (CLR) Integration
  - CLR Integration Design Objectives
  - Enabling CLR Integration
  - Required .NET Namespaces
  - Types of CLR Routines
  - Hello World Example
    - Command-Line Compiler
  - DDL Support for CLR Integration
    - CLR Routine Metadata
      - sys.assemblies
      - sys.assembly_files
      - sys.assembly_modules
      - sys.assembly_references
      - sys.assembly_types
    - Assembly Management
      - CREATE ASSEMBLY
      - ALTER ASSEMBLY
      - DROP ASSEMBLY
    - User-Defined Functions
      - CREATE FUNCTION
      - ALTER FUNCTION
      - DROP FUNCTION
    - Stored Procedures
      - CREATE PROCEDURE
      - ALTER PROCEDURE
      - DROP PROCEDURE
      - Metadata
    - User-Defined Aggregate Functions
      - CREATE AGGREGATE
      - DROP AGGREGATE
    - User-Defined Types
      - CREATE TYPE
      - DROP TYPE
      - Metadata
    - Triggers
      - CREATE TRIGGER
      - ALTER TRIGGER
      - DROP TRIGGER
      - Metadata
  - ADO.NET In-Process Extensions Supporting CLR Programming
    - SqlContext Object
    - SqlPipe Object
    - SqlTriggerContext Object
    - SqlDataRecord Object
  - Custom Attributes for CLR Routines
  - SQL Server Data Types in the .NET Framework
  - Testing and Debugging CLR Routines
- 5. Programming SQL Server CLR Routines
  - Scalar-Valued Functions
  - Table-Valued Functions
  - Stored Procedures
  - User-Defined Aggregate Functions
  - User-Defined Types
  - Triggers
    - DML Triggers
    - DDL Triggers
- 6. .NET Client-Side Programming
  - SQL Native Client Programming
  - SQLXML 4.0
    - SQLXML Managed Classes
      - SqlXmlCommand
      - SqlXmlParameter
      - SqlXmlAdapter
    - Using SQLXML Managed Classes
      - Executing a query
      - Using parameters in a query
      - Handling an exception
      - Retrieving an XmlReader object
      - Processing an XML result set on the client
      - Filling a DataSet
      - Applying an XSLT transformation to the XML result set
    - Annotated Mapping Schemas
    - XML Template Queries
    - UpdateGrams
    - DiffGrams
  - Exception Message Box
- 7. XML Data
  - xml Data Type
    - Creating xml Data Type Columns and Variables
      - Columns
      - Variables
    - Limitations
  - Creating xml Data Type Instances
    - Casting and Converting Strings
    - Constant Assignment
    - Bulk Loading Data with OPENROWSET
  - XML Data Type Methods
    - query( )
    - value( )
    - exist( )
    - modify( )
    - nodes( )
  - Viewing XML Data as Relational Data
  - Indexing XML Data
    - Creating an XML Index
    - Altering an XML Index
    - Dropping an XML Index
    - Viewing XML Indexes
  - Managing XML Schema Collections
    - Creating XML Schema Collections
    - Modifying XML Schema Collections
    - Removing XML Schema Collections
    - Viewing XML Schema Collections
    - Managing XML Schema Collection Permissions
      - Granting permissions
      - Revoking permissions
      - Denying permissions
    - Limitations of XML Schema Collections
  - XQuery Support
    - xml Data Type Functions
    - xml Data Type Operators
    - Using XQuery Extension Functions to Bind Relational Data Inside XML Data
      - sql:column( ) function
      - sql:variable( ) function
  - XML Data Manipulation Language
    - insert
    - delete
    - replace value of
    - XML DML Limitations and Restrictions
  - XML Results Using the FOR XML Clause
    - Some FOR XML Examples
    - FOR XML Support for SQL Server Data Types
    - FOR XML Updates and Enhancements
  - XML Catalog Views
- 8. Native XML Web Services
  - Open Standards
  - Creating a Web Service
  - Creating the HTTP Endpoint and Exposing a Web Method Example
    - SQL Batches
  - SOAP Request and Response Messages
  - Managing HTTP Endpoints
    - Creating an HTTP Endpoint
      - Protocol-specific arguments
      - Language-specific arguments
    - Altering an ENDPOINT
      - Protocol-specific items
      - Language-specific items
    - Dropping an ENDPOINT
    - Endpoint Authentication
    - Managing Permissions on Endpoints
      - Create permission
      - Alter permission
      - Control permission
      - Connect permission
      - Take Ownership permission
    - Endpoint Metadata
- 9. SQL Server Management Objects (SMO)
  - SMO Object Model
  - Creating an SMO Project in Visual Studio .NET
  - A Simple SMO Application
- 10. SQL Server Management Objects (SMO) Instance Classes, Part 1
  - Programming SMO Instance Classes for Administering Data Storage Objects
    - Connecting to and Disconnecting from SQL Server
    - Navigating the Server Hierarchy
    - Enumerating Database Properties
    - Enumerating Database Objects
    - Creating a Database Object
    - Checking Database Table Integrity
    - Transacting SMO Operations
    - Capture Mode
    - Event Notification
    - Handling Exceptions
  - SMO Instance Classes for Administering Data Storage Objects Reference
    - SQL Server Instances
    - Databases
    - Tables
    - Columns
    - Views
    - Indexes
    - Foreign Keys
    - Check Constraints
    - Rules
    - Stored Procedures
    - Numbered Stored Procedures
    - Extended Stored Procedures
    - DML Triggers
    - DDL Triggers
    - User-Defined Objects
    - Data Types
    - System Data Types
    - Schemas
    - SQL Server Objects
- 11. SQL Server Management Objects (SMO) Instance Classes, Part 2
  - Programming SMO Instance Classes for Administering Database Objects Not Used for Data Storage
    - Registered Server and Server Groups
    - Managing Logins
    - Managing Users
    - Managing Roles
    - Managing Server Permissions
    - Enumerating .NET Framework Assemblies
    - Statistics
    - Synonyms
    - Messages
    - Full-Text Search
  - SMO Instance Classes for Administering Objects Not Used for Data Storage Reference
    - Server Configuration
    - Registered Servers
    - Linked Servers
    - Database Defaults
    - Files and Filegroups
    - Partition Functions
    - Partition Schemes
    - Logins
    - Users
    - Server Roles
    - Database Roles
    - Server Permissions
    - Database Permissions
    - Application Roles
    - .NET Framework Assemblies
    - Endpoints
    - XML Schemas
    - Languages
    - Statistics
    - Certificates
    - Credentials
    - Keys
    - Synonyms
    - System Messages
    - User-Defined Messages
    - Full-Text Search
    - OLE DB Providers
- 12. SQL Server Management Objects (SMO) Utility Classes
  - Scripting
  - Backing Up and Restoring Data
  - Transferring Data
  - Tracing
  - Database Mail
- 13. Programming Windows Management Instrumentation (WMI)
  - Programming SMO WMI Classes
    - Enumerating the WMI Installation
    - Creating a Server Alias
    - Starting and Stopping a Service
- 14. SQL Server Reporting Services (SSRS)
  - Getting Started
  - Integrating Reports into Applications
    - URL Access
    - Report Viewer Control
    - Report Server Web Service
  - Reporting Services Extensions
- 15. SQL Server Integration Services (SSIS)
  - Architecture
    - SSIS Objects
    - Control-Flow Elements
    - Data-Flow Components
    - Connection Managers
    - Events
    - Package Configurations
    - Log Providers
    - Variables
  - Tools
  - Programming SSIS
    - Control-Flow Programming
      - Creating a package
      - Saving a package
      - Loading a package
      - Adding a task to the package
      - Adding a connection manager
      - Running a package
      - Validating a package
      - Enumerating task properties
      - Connecting tasks
      - Using variables
      - Configuring a package
      - Handling events
      - Logging
    - Data-Flow Programming
- 16. SQL Server Agent
  - Programming SQL Server Agent
    - Creating a Job
    - Running a Job
    - Creating a Schedule
    - Scheduling a Job
    - Creating an Operator
    - Creating an Alert
    - Creating a Proxy Account
    - Multiserver Environments
- 17. Service Broker
  - Architecture
  - Programming Service Broker
    - Enumerating Service Broker Objects
    - Implementing a Service Broker Service
- 18. Notification Services
  - Architecture
  - Creating a Notification Services Application
  - Programming Notification Services
    - Creating a Notification Services Application and Service
    - Creating a Notification Services Instance and Application
    - Creating a Delivery Channel
    - Creating an Event Class
    - Creating a Subscription Class and Subscription Event Rule
    - Creating a Notification Class, Content Formatter, and Notification Class Protocol
    - Creating an Event Provider
    - Creating a Generator
    - Creating a Distributor
    - Creating a Vacuum Schedule
    - Creating a Subscriber and Subscriber Device
    - Creating a Subscription
    - Enumerating a Notification Services Instance Database
    - Enumerating a Notification Services Application Database
- 19. Replication
  - Programming Replication
    - Prerequisites
    - Installing a Distributor
    - Creating a Publisher
    - Enabling a Database for Publication
    - Creating a Publication
    - Creating an Article
    - Enumerating Items Available for Replication
    - Filtering an Article
    - Registering a Subscriber
    - Creating a Subscription
    - Generating the Initial Snapshot
    - Synchronizing a Subscription to an Initial Snapshot
    - Retrieving Agent History
    - Specifying a Replication Schedule
    - Validating Subscriber Data
    - Monitoring Replication
    - Business Logic Handlers
- 20. SQL Server Analysis Services (SSAS)
  - Before You Begin
  - SSAS Overview
  - SSAS Database
  - SSAS Languages
    - Multidimensional Expressions (MDX)
    - Data Mining Extensions (DMX)
    - XML for Analysis (XMLA)
    - Analysis Services Scripting Language (ASSL)
  - Development
    - SSAS Project
    - SSAS Scripts Project
  - Accessing Data by Using ADOMD.NET
    - Querying an SSAS Database
    - Retrieving Schema Information
  - Administering SSAS Objects
    - Analysis Management Objects (AMO)
    - Decision Support Objects (DSO)
- 21. SQL Server Mobile Edition
  - Environments
    - Client
    - Server
  - Prerequisites
  - Programming SQL Server Mobile
    - Creating a Database
    - Maintaining a Database
      - Verifying and repairing
      - Reclaiming space
      - Modifying properties
      - Backing up and restoring
    - Creating, Altering, and Dropping Database Objects
    - Reading and Updating Data
    - Error Handling
- A. ADO.NET 2.0
  - Data Provider Enumeration and Factories
  - Data Provider Enhancements
    - Asynchronous Processing
    - Support for SQL Server Notifications
    - Multiple Active Result Sets
    - Bulk Copy
    - Support for New SQL Server Large-Value Data Types
    - Support for SQL Server User-Defined Types
    - Support for Snapshot Isolation in Transactions
    - Database Mirroring Support
    - Server Enumeration
    - Support for Retrieving Provider Statistics in SQL Server 2005
    - Change Password Support
    - Schema Discovery
  - Disconnected Class Enhancements
    - DataSet and DataTable Enhancements
    - Batch Processing with the DataAdapter
- Index
- About the Author
- Colophon
- SPECIAL OFFER: Upgrade this ebook with OReilly