Introducing Microsoft SQL Server(TM) 2005 for Developers (Pro-Developer) [Paperback]

Peter DeBetta (Author)

Book Description

Series: Pro-Developer | Publication Date: November 3, 2004

- Expertly introduces the new programmability, business intelligence, and enterprise data management features in the next version of SQL Server--from a developer's point of view
- Demonstrates how the technology's tighter integration with Visual Studio and the .NET Framework, SQL Server Workbench, and shared language base provide end-to-end development tools
- With code samples in both T-SQL and C#, readers can tap into their existing programming skills to get productive right away with the new SQL Server
Yokon is the next major release for SQL Server. With a major emphasis on features for developers, including tighter integration with Visual Studio, innovation for Yokon concentrates or programmability, business intelligence, and enterprise data management. From Yukon Overview NDA.ppt on http: //sqlweb, the following points speak directly to the developer audience
Enable developers to take advantage of existing skills
- Use existing tools/processes (VS, SourceSafe, etc)
- Multiple languages: T-SQL, VB.NET, C#...
- One development framework for relational, XML, OLAP
Extend and connect data across any platform
- Native support for XML, Web Services
- Interoperability with any platform, application
- Open standards: HTTP, Soap, WSDL, XQuery, XSD
Provide end-to-end development tools
- Integrated SQL Server Workbench
- Simplified and consistent source control environment
- Work in Project and Server modes for fast deployment
Yukon will bring together .NET developers and the T-SQL programmers by providing a common development environment, .NET integration and a shared language base.

Editorial Reviews

About the Author

Peter DeBetta started programming at the age of 10 and eventually turned this pastime into a career. He continued writing software until he attended college, where he switched his computer passions to graphic design. Peter studied linguistics during his four-year undergraduate stay at Bucknell University and eventually applied his human language concepts back into his computer programming.

Shortly after graduating from Bucknell in 1990 and teaching mathematics in a private college preparatory school, Peter began his career in software programming and combined the two passions of his life to begin teaching Microsoft Access and Visual Basic (version 2.0) programming and has been teaching both ever since. Peter acquired other computing skills along the way including Java, ASP, VBScript, JavaScript, and his now true love, SQL Server and Transact-SQL.

Peter now teaches exclusively for Wintellect, in addition to consulting and developing enterprise-level software solutions for his own company, DeBetta Software.

Product Details

• Paperback: 268 pages
• Publisher: Microsoft Press (November 3, 2004)
• Language: English
• ISBN-10: 8120327403
• ISBN-13: 978-8120327405
• ASIN: 073561962X
• Product Dimensions: 8.9 x 7.3 x 0.9 inches
• Shipping Weight: 1.2 pounds
• Average Customer Review: 2.3 out of 5 stars  See all reviews (15 customer reviews)
• Amazon Best Sellers Rank: #1,855,515 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

15 of 16 people found the following review helpful:

1.0 out of 5 stars MSPress, please get a better author, December 30, 2005

By 

Mary Louise Belmon "MLB" (Madison, Wisconsin) - See all my reviews

This review is from: Introducing Microsoft SQL Server(TM) 2005 for Developers (Pro-Developer) (Paperback)

This book is a good idea: an intro book for SS2005 aimed at developers, but it is unfortunately not implemented very well. Firstly, the author obviously isn't a professional developer. The advice he gives is just plain bad much of the time. It belies a lack of experience designing and building database systems. Secondly, the book was written for one of the really early CTP versions. Much of it doesn't apply to the actual product released in November. Thirdly, the author writes with a mix of arrogance and incompetence that, while entertaining, doesn't belong in a book like this. MSPress: do yourself and us readers a favor and get a better author for the next version.

22 of 25 people found the following review helpful:

4.0 out of 5 stars For Developers, May 22, 2005

By 

Maxim Masiutin (Chisinau, Republic of Moldova) - See all my reviews
(REAL NAME)   

This review is from: Introducing Microsoft SQL Server(TM) 2005 for Developers (Pro-Developer) (Paperback)

As it's obvious from the title, the book lists new improvements for programmers, not what become available to database administrators. It doesn't cover a lot of enhancements to enterprise data management in the following areas: high availability technologies, additional backup and restore capabilities, and replication enhancements; scalability advancements such as table partitioning, snapshot isolation; database encryption, and an enhanced security model; new management tool suite.

Programmers will find what was added to SQL language: ranking functions like Row_Number, Rank, Dense_Rank, NTile; new data types; the specific use of WITH clause; SOME, ANY and ALL operators; EXCEPT and INTERSECT set operators; PIVOT to create a cross-tab table; exception handling by TRY...CATCH; and other additions to SQL. A big chapter is devoted to XML integration. You will also find a lot of information about Common Language Runtime (CLR) Integration, the ability to develop database objects using any .NET language.

Other object models and services are also covered: data transformation services, server management objects, native HTTP SOAP, notification services and reporting services. You will also find out about the SQL Server Service Broker, distributed asynchronous application framework for new levels of scalability.

20 of 23 people found the following review helpful:

1.0 out of 5 stars Don't waste your money, or your time, January 31, 2006

By 

Gregory S. Ramey (Wichita, KS USA) - See all my reviews
(REAL NAME)   

This review is from: Introducing Microsoft SQL Server(TM) 2005 for Developers (Pro-Developer) (Paperback)

From Esposito, Prosise, Richter, Balena...Since the days when MFC was new, I've grown to trust the Wintellect authors and learned to look forward to their take on the Microsoft products. Microsoft and Wintellect really dropped the ball on this one. Scattered Logic, Examples which don't work, lack of focus, where should I begin?

How about with the title. I don't know who the intended audience was...certainly not developers. Maybe purchasing departments? I found Mr. Debetta's writing style quite arrogant and it interfered significantly with any points he may have been trying to get accross. Rather than an introduction, I found it to be little more than an extended advertisement.

Mr. DeBetta clearly has a passion for XML. However, XML is just a small part of a developer's interest. Maybe next time he will step back and think about what developer's are looking for. Those of us out in the field trying to stay abreast of new technologies. We are NOT looking for ads, we ARE looking for solid leads on where to take our products. This book does not suffice.

I feel I've wasted too much time on this book. Spending any more on this review seems an excess.