Programming SQL Server 2005 [NOOK Book]

Overview

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 ...

See more details below
Programming SQL Server 2005

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$25.49
BN.com price
(Save 42%)$43.99 List Price

Overview

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.

Providing a practical look at this powerful new version of the SQL Server database, this resource includes numerous code snippets and documents all the new features.

Read More Show Less

Product Details

  • ISBN-13: 9781449390921
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 2/21/2006
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 588
  • File size: 10 MB

Meet the Author

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.

Read More Show Less

Table of Contents

1 Introduction 1
2 Tools and utilities 8
3 T-SQL enhancements 30
4 Introduction to Common Language Runtime (CLR) integration 58
5 Programming SQL Server CLR routines 93
6 .NET client-side programming 128
7 XML data 162
8 Native XML Web services 210
9 SQL Server management objects (SMO) 234
10 SQL Server management objects (SMO) instance classes, part 1 238
11 SQL Server management objects (SMO) instance classes, part 2 267
12 SQL Server management objects (SMO) utility classes 298
13 Programming Windows management instrumentation (WMI) 318
14 SQL Server reporting services (SSRS) 327
15 SQL Server integration services (SSIS) 343
16 SQL Server agent 375
17 Service broker 388
18 Notification services 402
19 Replication 441
20 SQL Server analysis services (SSAS) 478
21 SQL Server mobile edition 496
App Ado.Net 2.0 509
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)