Database solutions are integral to every organization that needs to store, analyze, and report on data. Microsoft SQL Server 2005 provides a robust platform for implementing your database solution. SQL Server 2005 is packed with easy-to-use features that make it an ideal environment. In particular, this latest version of SQL Server is more secure, more scalable, and easier to use and manage than ever.
This book is for developers and database administrators who are already familiar with SQL Server and want to explore the latest features in SQL Server 2005. Developers and administrators with experience on other platforms will be able to use this book even if they are new to the topic of SQL Server. By following the step-by-step procedures in each chapter, you'll get a comprehensive hands-on introduction to the most important options for implementing your database solution using SQL Server 2005.
This book will cover the basics, including design, security, backups, and distribution. Along the way it will touch on related issues, such as migration from earlier versions of SQL Server. It gives extensive coverage to the question of retrieving and analyzing data, including data from remote sources, with an entire chapter devoted to accessing SQL Server through the Internet. You'll also find a thorough introduction to some of the features that make SQL Server such a comprehensive solution. These features provide for transactions, snapshots, auditing, reporting, and notification, as well as new features, such as enhanced support for XML.