December 2006
Beginner
912 pages
24h 44m
English
Content preview from Professional SQL Server™ 2005 Programming
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 2. Tool Time
Okay, so if you took the time to read Chapter 1, then you should now have a feel for how fast we're moving here. Again, if you're new to all of this, I would suggest swallowing your pride and starting with the Beginning SQL Server 2005 Programming title — it covers the basics in far more detail. For this book, our purpose in covering the stuff in the first few chapters is really more about providing a reference than anything else, so we really are just taking a whirlwind tour. With that in mind, it's time to move on to the toolset. If SQL Server 2005 was not your first experience with SQL Server, then this is a place where you'll want to pay particular attention. With SQL Server 2005, the toolset has changed — a lot.
Virtually everything to do with the SQL Server toolset has seen a complete overhaul for SQL Server 2005. Simplifying the "where do I find things?" question was a major design goal for the tools team in this release. For old fogies such as me, the new tools are a rather nasty shock to the system. For people new to SQL Server, I would say that the team has largely met that simplification goal. In general, there are far fewer places to look for things, and most of the toolset is grouped far more logically.
The tools we will look at in this chapter are:
SQL Server Books Online
The SQL Server Configuration Manager
SQL Server Management Studio
SQL Server Business Intelligence Development Studio
SQL Server Integration Services (SSIS): including the Import/Export ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.