SQL Server 2000 is the leading relational database in the Windows market. The increased manageability of SQL Server 2000 has also increased its popularity--anyone, not just database administrators, can use a SQL Server database.

This book recognizes that aspiring database administrators need more than just a basic knowledge of the available features in order to be considered "a safe pair of hands" for the database and the mission-critical data that is stored in it. Aspiring database administrators can benefit from the direction and advice of an expert mentor who not only understands...

SQL Server 2000 is the leading relational database for the Windows platform. It's a full-featured, enterprise-class database server, but its ease of use and maintenance makes it suitable whether youre a junior, part-time, or advanceddatabase administratoror developer. SQL Server expert and author Joseph Sack covers all SQL Server 2000 features, so you'll be able to rely on this book when you're in the field and need quick, effective solutions.

Included are hundreds of practical recipes that describe and demonstrate the utility of a feature or functionwith the minimum...

SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2008. Learn to create databases, insert and update data, generate reports, secure your data, and more. Author Joseph Sack takes common Transact-SQL tasks and breaks them down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on.

• Focused on solutions: Look up what you need to do. Learn how to do it. Do it.
• Current: Newly...