|
|
SQL Server 2000 Stored Procedure
& XML Programming, Second Edition
Trigon Blue's principal consultant Dejan Sunderic recently finished SQL Server 2000 Stored Procedure
& XML Programming - Second Edition, a book that fills a huge gap
in the field of Microsoft SQL Server development and DBA
documentation. The book was published by Osborne
/ McGraw-Hill.
Description
Discover the key concepts, techniques, tips, and tricks
professional developers need to know in order to take full advantage of stored
procedures in the SQL Server development environment. SQL Server 2000 Stored
Procedure & XML Programming teaches you to manage SQL Server resources
using Enterprise Manager, Query Analyzer, SQL Profiler, Visual SourceSafe,
Visual Basic and Visual Studio .NET.
Learn today's and tomorrow's
basic and advanced XML with special focus on features that are in use in
Microsoft database and development tools. Develop dynamic, Web-based
applications using SQL Server's SQLXML capabilities.
This helpful resource contains
simple explanations for developers who are just starting to work with stored
procedures and XML, as well as advanced recommendations and techniques for
experienced developers.
- Build different types of stored
procedures: user-defined, system, temporary, global temporary,
extended, remote, and nested
-
Implementing application security
-
Learn the finer points of using identity, timestamp,
dynamically constructed queries, temporary tables, table variables, indexed
views, distributed partitioned views, federated servers, user-defined
functions, table-valued functions, instead-of triggers and more
-
Create fast and scalable
Web search engine
-
Detailed coverage of
distributed
partitioned views and federated servers
-
Manage source code and
deploy databases using traditional
T-SQL scripts and alternatively Visual Studio .NET tools
-
Write T-SQL code to interact with COM object, DTS packages, executables, mail, the
Registry, jobs, full-text indexes
|
-
Master latest features of
XML for SQL Web
Releases:
XML
BulkLoad, UpdateGrams, DiffGrams, XML Views, OPENXML
-
Create XML Web Services that use SOAP; describe (wsdl) and register (UDDI)
them
-
Access and modify databases though URL, POST, XML template, and
XPath queries, mapped XML schemas and Web Services
-
Develop .NET applications for SQL Server 2000 databases
using SQLXML managed classes
-
Sample database, scripts, .NET projects, XML
templates, development and deployment tools
|
Author
Dejan Sunderic, MCDBA, CMSSP, is the Principal Consultant at Trigon Blue Inc.
As a Microsoft Certified Solution Provider, Trigon Blue specializes in database
administration and development, and application development for the Internet and
Windows platforms. Dejan has written five books and numerous technical articles
for several computer and professional publications.
Publisher
Osborne/McGraw-Hill
ISBN: 0-07-222896-2
EAN: 9780072228960
UPC: 783254041905
EAN-5: 54999
Links
|
