O'Reilly logo

Microsoft® SQL Server® 2008 Bible by Uttam Parui, Mike White, Paul Nielsen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required