Dimensions
187 x 234 x 51mm
Professional SQL Server 2008 Programming shows experienced developers how to master the increasingly complex feature set of the latest release of Microsoft SQL Server.
The book begins with a concise overview of the new features of SQL Server that will be of interest to experienced developers. From there, the book quickly moves on to the "meat" of the title, with extensive code examples.
The book covers such topics as:
* Writing complex queries
* Building more complex types of data structures.
* Techniques for improving application speed and performance.
* Advanced scripting and error handling.
* Advanced methods for handling stored procedures.
* SQL cursors
* XML and XQuery support
* Reporting Services, Integration Services, and Analysis Services
* Replication
* Security and Performance Tuning
* Advanced database design
The new edition will be substantially revised---about 40% revised, plus 75 more pages---to cover the extensive and pervasive changes that come with the 2008 release. SQL Server 2008 brings with it: new data types, new indexing structures, new manageability features, and advanced time zone handling - it is expected that later CTPs will reveal additional changes.
The book's companion site will provide all of the source code, so readers can quickly implement the soluitons described in the book.