Mastering Microsoft SQL Server 2005

Front Cover
John Wiley & Sons, Mar 31, 2007 - Computers - 1108 pages
The Comprehensive Resource for SQL Server 2005 Administrators, Consultants, and Developers

Whether you're a systems administrator, database application developer, or IT consultant, you'll quickly ratchet up your knowledge of Microsoft SQL Server 2005 with this thorough and comprehensive guide. Light on theory and heavy on practicality, it cuts to the chase with real-world examples of large-scale business applications, an entire chapter on troubleshooting, and crucial information on SQL Server 2005's enhanced connectivity. For new users of Microsoft SQL Server, this book takes you quickly, but systematically, through the introductory topics.

Coverage Includes

  • Integrating SQL Server with .NET Framework
  • Understanding Service Broker, a distributed application framework
  • Programming with ADO.NET, the data-access component of .NET
  • Setting up Notification Services, which delivers personalized information to mobile devices
  • Using SQL Server Management Studio instead of Enterprise Manager
  • Designing made easier with new Business Intelligence Development Studio (BIDS)
  • Printing multi-page reports
  • Mastering Transact-SQL programming language

Leverage the Experience of Large-Scale Enterprises through Real-World Examples

Increase Your Own Productivity with an Entire Chapter on Troubleshooting

Discover What SQL Server 2005's Increased Emphasis on Connectivity Means to Your Installation

Start Developing Apps--All the Information You Need!

www.sybex.com

 

Contents

Part 1 Introducing SQL Server
1
Part 2 TransactSQL
101
Part 3 Digging into SQL Server
235
Part 4 Administering SQL Server
443
Part 5 Development with SQL Server
569
Part 6 Advanced Topics
691
Appendix TransactSQL Reference
985
Index
993
Copyright

Other editions - View all

Common terms and phrases

About the author (2007)

Mike Gunderloy is one of the world's foremost database developers. He has written Mastering SQL Server 2000, Visual Basic Developer's Guide to ADO, and SQL Server In Record Time and contributed to Access Developer's Handbook (in several versions), all from Sybex.

Joseph L. Jorden is the co-author of Mastering SQL Server 2000 and has served as the technical editor for several Sybex books.

David W. Tschanz has worked on a variety of pro-jects related to Web-accessible information and also serves as a computer security liaison.

Bibliographic information