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…mehr
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-sharp 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 systemsBecause 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 or no 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.Hinweis: Dieser Artikel kann nur an eine deutsche Lieferadresse ausgeliefert werden.
Bill Hamilton is the author of the highly praised ADO.NET Cookbook. He is an enterprise architect specializing in designing, developing and implementing enterprise applications using .NET and J2EE technologies. Over the last fifteen years, Bill has provided consulting services for B2B, B2C, B2E, enterprise application integration, portal initiatives, and custom application development for financial services, retail, professional services, and manufacturing clients. Bill is also the author of O'Reilly's NUnit Pocket Reference, the co-author of ADO.NET in a Nutshell, and also writes for Microsoft Developer Network.
Inhaltsangabe
Preface What You Need to Use This Book Conventions Used in This Book How to Contact Us Safari® Enabled Acknowledgments Chapter 1: Introduction 1.1 Contents of This Book 1.2 What's Not in This Book Chapter 2: Tools and Utilities 2.1 SQL Server Management Studio 2.2 SQL Server Configuration Manager 2.3 SQL Server Surface Area Configuration 2.4 Database Engine Tuning Advisor 2.5 SQL Server Profiler 2.6 SQL Server Business Intelligence Development Studio 2.7 Visual Studio 2005 2.8 New Command-Line Utilities Chapter 3: T-SQL Enhancements 3.1 New Data Types 3.2 T-SQL Language Enhancements 3.3 Data Definition Language (DDL) Triggers 3.4 Metadata Chapter 4: Introduction to Common Language Runtime (CLR) Integration 4.1 CLR Integration Design Objectives 4.2 Enabling CLR Integration 4.3 Required .NET Namespaces 4.4 Types of CLR Routines 4.5 Hello World Example 4.6 DDL Support for CLR Integration 4.7 ADO.NET In-Process Extensions Supporting CLR Programming 4.8 Custom Attributes for CLR Routines 4.9 SQL Server Data Types in the .NET Framework 4.10 Testing and Debugging CLR Routines Chapter 5: Programming SQL Server CLR Routines 5.1 Scalar-Valued Functions 5.2 Table-Valued Functions 5.3 Stored Procedures 5.4 User-Defined Aggregate Functions 5.5 User-Defined Types 5.6 Triggers Chapter 6: .NET Client-Side Programming 6.1 SQL Native Client Programming 6.2 SQLXML 4.0 6.3 Exception Message Box Chapter 7: XML Data 7.1 xml Data Type 7.2 Creating xml Data Type Instances 7.3 XML Data Type Methods 7.4 Viewing XML Data as Relational Data 7.5 Indexing XML Data 7.6 Managing XML Schema Collections 7.7 XQuery Support 7.8 XML Data Manipulation Language 7.9 XML Results Using the FOR XML Clause 7.10 XML Catalog Views Chapter 8: Native XML Web Services 8.1 Open Standards 8.2 Creating a Web Service 8.3 Creating the HTTP Endpoint and Exposing a Web Method Example 8.4 SOAP Request and Response Messages 8.5 Managing HTTP Endpoints Chapter 9: SQL Server Management Objects (SMO) 9.1 SMO Object Model 9.2 Creating an SMO Project in Visual Studio .NET 9.3 A Simple SMO Application Chapter 10: SQL Server Management Objects (SMO) Instance Classes, Part 1 10.1 Programming SMO Instance Classes for Administering Data Storage Objects 10.2 SMO Instance Classes for Administering Data Storage Objects Reference Chapter 11: SQL Server Management Objects (SMO) Instance Classes, Part 2 11.1 Programming SMO Instance Classes for Administering Database Objects Not Used for Data Storage 11.2 SMO Instance Classes for Administering Objects Not Used for Data Storage Reference Chapter 12: SQL Server Management Objects (SMO) Utility Classes 12.1 Scripting 12.2 Backing Up and Restoring Data 12.3 Transferring Data 12.4 Tracing 12.5 Database Mail Chapter 13: Programming Windows Management Instrumentation (WMI) 13.1 Programming SMO WMI Classes Chapter 14: SQL Server Reporting Services (SSRS) 14.1 Getting Started 14.2 Integrating Reports into Applications 14.3 Reporting Services Extensions Chapter 15: SQL Server Integration Services (SSIS) 15.1 Architecture 15.2 Tools 15.3 Programming SSIS Chapter 16: SQL Server Agent 16.1 Programming SQL Server Agent Chapter 17: Service Broker 17.1 Architecture 17.2 Programming Service Broker Chapter 18: Notification Services 18.1 Architecture 18.2 Creating a Notification Services Application 18.3 Programming Notification Services Chapter 19: Replication 19.1 Programming Replication Chapter 20: SQL Server Analysis Services (SSAS) 20.1 Before You Begin 20.2 SSAS Overview 20.3 SSAS Database 20.4 SSAS Languages 20.5 Development 20.6 Accessing Data by Using ADOMD.NET 20.7 Administering SSAS Objects Chapter 21: SQL Server Mobile Edition 21.1 Environments 21.2 Prerequisites 21.3 Programming SQL Server Mobile ADO.NET 2.0 Data Provider Enumeration and Factories Data Provider Enhancements Disconnected Class Enhancements Colophon
Preface What You Need to Use This Book Conventions Used in This Book How to Contact Us Safari® Enabled Acknowledgments Chapter 1: Introduction 1.1 Contents of This Book 1.2 What's Not in This Book Chapter 2: Tools and Utilities 2.1 SQL Server Management Studio 2.2 SQL Server Configuration Manager 2.3 SQL Server Surface Area Configuration 2.4 Database Engine Tuning Advisor 2.5 SQL Server Profiler 2.6 SQL Server Business Intelligence Development Studio 2.7 Visual Studio 2005 2.8 New Command-Line Utilities Chapter 3: T-SQL Enhancements 3.1 New Data Types 3.2 T-SQL Language Enhancements 3.3 Data Definition Language (DDL) Triggers 3.4 Metadata Chapter 4: Introduction to Common Language Runtime (CLR) Integration 4.1 CLR Integration Design Objectives 4.2 Enabling CLR Integration 4.3 Required .NET Namespaces 4.4 Types of CLR Routines 4.5 Hello World Example 4.6 DDL Support for CLR Integration 4.7 ADO.NET In-Process Extensions Supporting CLR Programming 4.8 Custom Attributes for CLR Routines 4.9 SQL Server Data Types in the .NET Framework 4.10 Testing and Debugging CLR Routines Chapter 5: Programming SQL Server CLR Routines 5.1 Scalar-Valued Functions 5.2 Table-Valued Functions 5.3 Stored Procedures 5.4 User-Defined Aggregate Functions 5.5 User-Defined Types 5.6 Triggers Chapter 6: .NET Client-Side Programming 6.1 SQL Native Client Programming 6.2 SQLXML 4.0 6.3 Exception Message Box Chapter 7: XML Data 7.1 xml Data Type 7.2 Creating xml Data Type Instances 7.3 XML Data Type Methods 7.4 Viewing XML Data as Relational Data 7.5 Indexing XML Data 7.6 Managing XML Schema Collections 7.7 XQuery Support 7.8 XML Data Manipulation Language 7.9 XML Results Using the FOR XML Clause 7.10 XML Catalog Views Chapter 8: Native XML Web Services 8.1 Open Standards 8.2 Creating a Web Service 8.3 Creating the HTTP Endpoint and Exposing a Web Method Example 8.4 SOAP Request and Response Messages 8.5 Managing HTTP Endpoints Chapter 9: SQL Server Management Objects (SMO) 9.1 SMO Object Model 9.2 Creating an SMO Project in Visual Studio .NET 9.3 A Simple SMO Application Chapter 10: SQL Server Management Objects (SMO) Instance Classes, Part 1 10.1 Programming SMO Instance Classes for Administering Data Storage Objects 10.2 SMO Instance Classes for Administering Data Storage Objects Reference Chapter 11: SQL Server Management Objects (SMO) Instance Classes, Part 2 11.1 Programming SMO Instance Classes for Administering Database Objects Not Used for Data Storage 11.2 SMO Instance Classes for Administering Objects Not Used for Data Storage Reference Chapter 12: SQL Server Management Objects (SMO) Utility Classes 12.1 Scripting 12.2 Backing Up and Restoring Data 12.3 Transferring Data 12.4 Tracing 12.5 Database Mail Chapter 13: Programming Windows Management Instrumentation (WMI) 13.1 Programming SMO WMI Classes Chapter 14: SQL Server Reporting Services (SSRS) 14.1 Getting Started 14.2 Integrating Reports into Applications 14.3 Reporting Services Extensions Chapter 15: SQL Server Integration Services (SSIS) 15.1 Architecture 15.2 Tools 15.3 Programming SSIS Chapter 16: SQL Server Agent 16.1 Programming SQL Server Agent Chapter 17: Service Broker 17.1 Architecture 17.2 Programming Service Broker Chapter 18: Notification Services 18.1 Architecture 18.2 Creating a Notification Services Application 18.3 Programming Notification Services Chapter 19: Replication 19.1 Programming Replication Chapter 20: SQL Server Analysis Services (SSAS) 20.1 Before You Begin 20.2 SSAS Overview 20.3 SSAS Database 20.4 SSAS Languages 20.5 Development 20.6 Accessing Data by Using ADOMD.NET 20.7 Administering SSAS Objects Chapter 21: SQL Server Mobile Edition 21.1 Environments 21.2 Prerequisites 21.3 Programming SQL Server Mobile ADO.NET 2.0 Data Provider Enumeration and Factories Data Provider Enhancements Disconnected Class Enhancements Colophon
Es gelten unsere Allgemeinen Geschäftsbedingungen: www.buecher.de/agb
Impressum
www.buecher.de ist ein Internetauftritt der buecher.de internetstores GmbH
Geschäftsführung: Monica Sawhney | Roland Kölbl | Günter Hilger
Sitz der Gesellschaft: Batheyer Straße 115 - 117, 58099 Hagen
Postanschrift: Bürgermeister-Wegele-Str. 12, 86167 Augsburg
Amtsgericht Hagen HRB 13257
Steuernummer: 321/5800/1497
USt-IdNr: DE450055826