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

Mastering Microsoft SQL Server 2005, Express Edition, approaches the new product comprehensively to uncover all it has to offer. Written by the author of the bestselling Mastering SQL Server 2000, this book has an easy learning curve for beginners, but doesn't stop there. Unlike its competition, it thoroughly explores the topic, step by step, for those readers who need to use SQL Server Express as a mission-critical solution in a small-to-medium-size enterprise or as a training tool.· Introducing SQL Server Express· Transact-SQL· Digging Into SQL Server Express· Administering SQL Server Express· Developing Applications with SQL Server Express· Advanced SQL Server Express Administration

Provides information on SQL concepts, covering such topics as SQL commands, joins, functions, query development, set operations, and correlated subqueries.

Reporting Services is a powerful tool for SQL Server 2005 database administrators, developers, and other IT professionals, enabling them to make sense of the immense amount of data generated by enterprises of all sizes Shows readers how to create, manage, and distribute information as well as how to design, produce, and distribute reports that meet the needs of the stakeholder Contains practical insights and real-world solutions not found in other books Bridges the gap between those who manage data and those who need it

If you've not programmed with Transact-SQL, this book is for you.It begins with an overview of SQL Server query operations and tools used with T-SQL, and covers both the 2005 and 2008 releases of SQL Server query tools and the query editor. The book then moves to show you how to design and build applications of increasing complexity. Other important tasks covered include full text indexing, optimizing query performance, and application design and security considerations. The companion website also provides all of the code examples from the book.