Apress

Beginning SQL Server 2008 for Developers

From Novice to Professional

By Robin Dewson

Beginning SQL Server 2008 for Developers Cover Image

Start your journey toward SQL Server mastery with author and developer Robin Dewson!

Full Description

  • ISBN13: 978-1-59059-958-7
  • 496 Pages
  • User Level: Beginner to Advanced
  • Publication Date: July 24, 2008
  • Available eBook Formats: PDF
  • Print Book Price: $49.99
  • eBook Price: $34.99
Buy eBook Buy Print Book Add to Wishlist

Related Titles

Full Description

SQL Server 2008 is a first–rate database management system. It offers more capability than any previous release of SQL Server. More than just a classic relational database management system, SQL Server 2008 includes exciting and powerful features that make it useful for everything from large corporate data warehouses to ad hoc departmental databases. You’ll find enhanced support for XML, new support for spatial data, transparent data encryption, a policy–based management system, and more.

Author and developer Robin Dewson will show you the way from beginner to SQL Server 2008 professional. Learn to install SQL Server 2008 and navigate around Management Studio before getting right to the heart of mastering fundamental SQL Server 2008 tasks: creating tables, storing data, securing data, and retrieving it again. Dewson ensures you’ll be fully prepared to use all the basics and create a solid foundation for your own projects.

Don’t forget about backups! Your database will house important data, so backing up is essential to protect yourself from inevitable hardware failure. Dewson walks you through SQL Server 2008’s easy–to–use backup and recovery feature set, giving you the grounding that you need in order to set up a reliable plan for recovery in your own environment.

Learn to use Transact–SQL, a full–blown procedural language that is built right into the database system. Transact–SQL is the key to unlocking everything that SQL Server 2008 has to offer. Using Transact–SQL, you can write centrally encapsulated business logic through the use of stored procedures, automatically trigger processing through the use of triggers, and manipulate data within the server without having to move data back and forth across the network.

Finally, you’ll learn a bit about SQL Server 2008 Reporting Services, a powerful tool that allows enterprise reporting. Reporting Services enables you to develop and serve reports across your organization and even to business partners outside your company. Reporting Services also gives end users the ability to create their own reports, helping them transform business data into valuable, usable information to guide their day–to–day decisions.

What you’ll learn

  • Install and manage SQL Server on your system
  • Create and secure tables
  • Store and query data; use indexes to improve query performance
  • “Sleep when the wind blows,” because you have a solid backup and recovery process
  • Run procedural code inside your database in the form of Transact–SQL procedures and triggers
  • Serve up business reports to in–house users and outside business partners via SQL Server 2008 Reporting Services

Who this book is for

Developers new to SQL Server 2008. If you are just beginning to develop software using SQL Server 2008, or if you are planning to do so in the near future, this book will set you on the road to success.

Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.

Errata

If you think that you've found an error in this book, please let us know about it. You will find any confirmed erratum below, so you can check if your concern has already been addressed.

* Required Fields

On page 11:
"If you look at the SQL Server Browser, which is another name for SQL Server Management Studio..." and the rest of the paragraph justifying why this should start automatically or not.

No it is not: SQL Browser is something totally different and the reasons for having it started automatically or not are very different accordingly.


On page 115:

Execution Mode: On Change - Log Only

There are no options like that in the drop down list. There is only "On Demand" or "On Schedule," but no "On Change - Log Only" or anything else.

Also,the checkbox for Enabled is grayed out (probably because there are no other options, except as stated above).