|
|
SQL Server 2005
Stored Procedure Programming in T-SQL and .NET,
Third Edition
Trigon Blue's principal consultant Dejan Sunderic recently finished
the third edition of SQL Server 2005 Stored Procedure Programming in
T-SQL and .NET. 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 2005 Stored
Procedure Programming in T-SQL and .NET teaches you to to create and use
stored procedures and other programmatic SQL Server database objects using
Transact-SQL or .NET Framework compatible programming languages such as Visual Basic
and C#.
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.
- Master Transact-SQL and CLR stored procedure programming
- Build different types of stored
procedures: user-defined, system, temporary, global temporary,
extended, remote, and nested
-
Implementing database and 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
-
Group and execute T-SQL statements using batches, scripts, and
transactions
-
Create fast and scalable stored procedures for searching database from Web
applications
-
Detailed coverage of
distributed
partitioned views and federated servers
|
- Develop scalable Windows and web-based applications
- Develop and manage stored procedures using C# and Visual Basic
.NET
- Create CLR user-defined functions, triggers, aggregates and types
- Implement reliable debugging and error handling techniques and
security measures Implement debugging techniques and security measures
- Sample database, scripts, .NET projects, XML
templates, development and deployment tools
-
Manage source code and
deploy databases using traditional
T-SQL scripts and alternatively Visual Studio .NET tools
-
Write T-SQL code to interact with CLR
objects, COM objects, Integration Services packages, DTS packages, executables, mail, the
Registry, jobs, full-text indexes
|
Author
Dejan Sunderic, MCDBA, CMSSP, BSc, is the Principal Consultant at Trigon Blue Inc.
Dejan has written six books and numerous technical articles
for several computer and professional publications. He is currently president of
Toronto SQL Server User Group.
Publisher
Osborne/McGraw-Hill
ISBN: 0072262281
DOI: 10.1036/0072262281
Links
|
