Part I. Laying the Foundation

IN THIS PART

SQL Server is a vast product. If you're new to SQL Server it can be difficult to know where to start. You need at least an idea of the scope of the components, the theory behind databases, and how to use the UI to even begin playing with SQL Server.

That's where this part fits and why it's called "Laying the Foundation."

Chapter 1 presents an introduction to SQL Server's many components and how they work together. Even if you're an experienced DBA, this chapter is a quick way to catch up on what's new.

Database design and technology have both evolved faster since the millennium than at any other time since Dr. Edgar Codd introduced his revolutionary RDBMS concepts three decades earlier. Every year, the IT profession is getting closer to the vision of ubiquitous information. This is truly a time of change. Chapters 2 and 3 discuss database architecture and relational database design.

Installing and connecting to SQL Server is of course required before you can have any fun with joins, and two chapters cover those details.

Management Studio, one of my favorite features of SQL Server, and PowerShell, the new scripting tool, each deserve a chapter and round out the first part.

If SQL Server is the box, and developing ...

Get Microsoft® SQL Server® 2008 Bible now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.