Introducing SQL Server 2005 for Developers

Peter DeBetta

246 pages, parution le 28/10/2004

Ajouter à une liste

Indisponible

Résumé

Get a head start evaluating the new, integrated database development and debugging tools in SQL Server 2005.

Get a first look at the programming enhancements in SQL Server 2005 that deliver new levels of application scalability and interoperability with less complexity. Database expert Peter DeBetta takes you inside the technology-demonstrating how you can work seamlessly with Microsoft Visual Studio® tools and the Microsoft .NET common language runtime from within SQL Server. You'll also explore Transact-SQL (T-SQL) language advances, native XML support, a new security model, and other features-with advice on how to balance new capabilities with performance considerations. With DeBetta's prerelease insights and T-SQL and C# code samples, you get everything you need to get productive right away.

Discover how to:

Exploit native support for relational and XML data, including the new XQuery feature
Work with Visual Studio tools and the common language runtime to create managed procedures and types
Use Microsoft ADO.NET 2.0 for new data access capabilities, including asynchronous commands
Improve scalability and simplify scripting with SQL Server Management Objects
Use schemas and other new security features to help control permissions and access
Deliver fully functional Web services with HTTP Endpoints plus related security services
Accelerate development of enterprise data-management solutions with SQL Server Data Transformation Services, Reporting Services, and Notification Services

L'auteur - Peter DeBetta

Peter DeBetta is a programming expert for SQL Server, Transact-SQL, Visual Studio, Microsoft Access, and scripting technologies. He runs DeBetta Software a consulting firm that specializes in developing data-driven enterprise solutions. Peter is also a programming instructor for Wintellect, a premier training and consulting firm, and is a frequent speaker on SQL Server and data-related programming topics.

Sommaire

Data Access and Programmability (DB Engine)
- SQL Server Management Studio and Transact-SQL
- But Wait... More Transact-SQL
- XML-The Real Deal
Common Language Runtime Integration
- User-Defined Data Types
- Client-side ADO.NET
- Security
Other Object Modes and Services
- SQL Server Management Objects
- Native HTTP SOAP
- Notification Services
- SQL Server Service Broker
- Reporting Services
- Appendix : The Microsoft Platform Ahead

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Microsoft Press
Auteur(s)	Peter DeBetta
Parution	28/10/2004
Nb. de pages	246
Format	19 x 23
Couverture	Broché
Poids	550g
Intérieur	Noir et Blanc
EAN13	9780735619623
ISBN13	978-0-7356-1962-3