Inside SQL Server 2005 Tools

Description

SQL Server has always distinguished itself by, among other things, its management tools. One of the earliest design principles for the team was “It just works.” We accomplished this by replacing the usual database knobs and levers with intelligent defaults and adaptive behavior. We never felt that we could or should remove all administrator control. Instead we delivered Enterprise Manager in SQL Server 7.0 and SQL Server 2000. Enterprise Manager grew a huge fan base over the years. So it was with some trepidation that we undertook a massive rewrite, yielding SQL Server Management Studio (SSMS) in SQL Server 2005.

The most nerve-wracking experience for software developers is receiving the user initial feedback on a new product or feature. We released an early version of SSMS in SQL Server 2005 Beta 1. You might recall this as Yukon Beta 1. When we received the summary of an early user survey, we were delighted to find SSMS as the most liked new feature in the beta release. At the same time, we were mortified to also find it as the most disliked feature!

Getting past our bewilderment, we realized that we were getting incredible feedback from our users. In fact, we found out that we had two distinct user populations. We had taken our management tools in the direction of supporting DBAs as developers in addition to administrators. The feedback told us we were on the right track, but that we had serious work to do. The users that felt like developers—that is, those that wrote and maintained scripts, schemas, stored procedures and other objects—loved the new paradigms in the product. This affirmed our assumptions and research. The users that felt like administrators—that is, they worried about users and user access, backup and restore and other operations—hated the new paradigms. We had assumed that most DBAs were both developers and administrators. With the amazing growth of SQL Server, it is not surprising that DBAs have specialized.

Armed with user feedback, we made substantial changes to SQL Server Management Studio. Your authors were in the thick of the action. They shaped the feature set and the user interface you use when you manage your SQL Server. They know the tool set inside and out. I had the privilege of working with them for five years. I’m delighted to see them write this book and deliver their insights, their advice, and a behind the scenes perspective.

Several chapters stand out. Chapter 4 covers administration, vital to keeping your server running optimally and securely. DBAs receive constant requests to move data for users. SQL Server 2005 features Integration Services, the successor to Data Transformation Services. Chapter 16 covers this new and improved tool. And as the guy who drove Business Intelligence in SQL Server, I of course recommend the coverage of this topic in Chapter 13. BI is growing rapidly in our industry. Even if you are not engaged in BI, this chapter is worth your time. You will be getting requests for Business Intelligence in the future.

Enjoy this book, and enjoy SQL Server 2005!

Here’s a brief overview of each chapter and appendix.

Chapter 1: Inside the Fundamentals

This chapter covers the history of SQL Server, as well as background on the SQL Server tools. The rest of the chapter provides an overview of the new toolset in SQL Server 2005, as well as a mapping between tools from previous releases and the current version. In addition, there is a brief summary of each tool.

Chapter 2: Inside the Installation and Upgrade Tools

The features included with each edition of SQL Server 2005 are highlighted in this chapter. It also provides brief descriptions of the target audience for each edition. You can find step-by-step instructions on installations, upgrade, gotchas to avoid during the install process, and information on backward compatibility issues. The new Upgrade Advisor is also covered in detail.

Chapter 3: Inside the Configuration Tools

Confused by the variety of configuration tools available in SQL Server 2005? This chapter will help you understand which tool to use for which task. You can also find descriptions and the architecture of each configuration tool. SQL Server Configuration Manager, SQL Server Surface Area Configuration, and Usage and Error Reporting tools are all covered in this chapter, as well as common configuration tasks. Because security is such a hot button issue, this chapter also covers surface area reduction.

Chapter 4: Inside Management and Administration Tools

This chapter is a must-read for all SQL Server users. You will find information on everything from how the new toolset is laid out, how to register servers, using the management dialogs, and understanding Object Explorer. There is also a discussion of management and administration scenarios that describes how to leverage Management Studio to accomplish common tasks.

Chapter 5: Inside Data Authoring Tools

Running and editing queries are two of the most common tasks you are likely to perform in SQL Server. This chapter describes the new querying tool (Query Editor) available in SQL Server Management Studio. This chapter is a must-read for anyone interested in modifying their editing environment or learning inside tricks for using Query Editor. Bulk Copy Utility can also be used when moving external data to SQL Server, and a full review of Bulk Copy Utility architecture and scenarios is covered.

Chapter 6: Inside SQLCMD Query Tools

Wondering what happened to your old friend OSQL? SQLCMD is the replacement tool, where you will find backward compatibility for much of OSQL as well as many enhancements. This chapter gets you up to speed on working with the new tool. You can also find descriptions of all the command line options and insider tips and tricks.

Chapter 7: Inside Tuning and Optimization Tools

As soon as you understand the new query editing environment, you may want to enhance query performance. This chapter reviews the SQL Server Management Studio query optimizations and takes a comprehensive look at SQL Server Profiler. The SQL Server Profiler user interface has undergone a makeover since the last release, so this chapter may be helpful for even experienced users. You can also find information on the trace API, which enables users to automate creation of the trace and perform trace data reading and manipulations programmatically

http://rapidshare.com/files/3814382/addison.wesley.inside.sql.server.2005.tools-0321397967.chm

http://mihd.net/rvxag1

http://depositfiles.com/files/380418

Disclaimer:
Contents of this page are indexed from the Internet. All actions are under your responsability. Email us to report illegal contents or external links and we'll remove them immediately.

Please check the description for download links if any or do a search to find alternative books.

Can't Download?
Please search mirrors if you can't find download links for "Inside SQL Server 2005 Tools" in "Description" and someone else may update the links. Check the comments when back to find any updates.

Search Mirrors
Maybe some mirror pages will be helpful, search this book at top of this page or click here to find more info.

1. Ebooks list page : 382
2. Inside SQL Server 2005 Tools
3. Inside.SQL.Server.2005.Tools
4. Inside SQL Server 2005 Tools
5. Inside SQL Server 2005 Tools
6. Inside SQL Server 2005 Tools
7. Inside SQL Server 2005 Tools
8. Inside SQL Server 2005 Tools
9. Addison Wesley Inside SQL Server 2005 Tools Oct 2006
10. Inside Microsoft SQL Server 2005: T-SQL Programming
11. Inside.Microsoft.SQL.Server.2005.T-SQL.Programming
12. Inside Microsoft SQL Server 2005: T-SQL Programming
13. Inside Microsoft SQL Server 2005: T-SQL Programming
14. Inside Microsoft SQL Server 2005: T-SQL Programming
15. Inside Microsoft SQL Server 2005: The Storage Engine
16. Inside Microsoft SQL Server 2005: T-SQL Programming (Pro-Developer)