Professional SQL Server 2005 Administration (Wrox Professional Guides)




SQL Server 2005 is the largest leap forward for SQL Server since its inception. With this update comes new features that will challenge even the most experienced SQL Server DBAs. Written by a team of some of the best SQL Server experts in the industry, this comprehensive tutorial shows you how to navigate the vastly changed landscape of the SQL Server administration.


Drawing on their own first-hand experiences to offer you best practices, unique tips and tricks, and useful workarounds, the authors help you handle even the most difficult SQL Server 2005 administration issues, including blocking and locking. You'll learn how to fine-tune queries you've already written, automate redundant monitoring and maintenance tasks, and use hidden tools so that you can quickly get over the learning curve of how to configure and administer SQL Server 2005.

What you will learn from this book
* How to use some of the more advanced concepts of installation
* Techniques for properly administering development features such as SQL CLR
* Ways to secure your SQL Server from common threats
* How to choose the right hardware configuration
* Best practices for backing up and recovering your database
* Step-by-step guidelines for clustering your SQL Server

Who this book is for

This book is for experienced developers and database administrators who plan to administer or are already administering an SQL Server 2005 system and its business intelligence features.

Wrox Professional guides are planned and written by working technologists to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.



Professional SQL Server 2005 CLR Programming: with Stored Procedures, Functions, Triggers, Aggregates and Types




# SQL Server 2005 offers the capability to write code in a .NET language that can be compiled and run inside SQL Server. CLR Integration, or SQL CLR, lets you create stored procedures, user-defined types, triggers, table valued functions, and aggregates using a .NET managed language. You can read and write to resources outside of SQL Server and enjoy a tighter integration with XML, web services, and simple file and logging capabilities. Here's the reference you'll want on your desk as you develop SQL CLR solutions. It helps you decide whether to use SQL CLR, how to lock down security, and learn from real examples. If you want to develop stored procedures or other objects in .NET for SQL Server 2005, this book offers exactly what you need. What you will learn from this book The concepts and architecture of SQL CLR


    * Uses of .NET namespaces in SQL Server programming tasks
    * How to develop and benchmark routines in T-SQL and .NET to determine when CLR-based solutions are advantageous
    * How to replace extended stored procedures using SQL CLR stored procedures
    * How to use SQL CLR objects in external applications
    * How to restrict and secure SQL CLR object capabilities
    * Processes and procedures for deploying SQL CLR objects



Who this book is for

This book is for developers and architects who are familiar with .NET concepts as well as DBAs who, although developers in their own right, may be slightly less up to date on .NET. A solid grounding in T-SQL is necessary. Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.




Professional SQL Server 2005 Integration Services (Programmer to Programmer)




This book will help you get past the initial learning curve quickly so that you can get started using SSIS to transform data, create a workflow, or maintain your SQL Server. Offering you hands-on guidance, you'll learn a new world of integration possibilities and be able to move away from scripting complex logic to programming tasks using a full-featured language.

What you will learn from this book


    * Ways to quickly move and transform data
    * How to configure every aspect of SSIS
    * How to interface SSIS with web services and XML
    * Techniques to scale the SSIS and make it more reliable
    * How to migrate DTS packages to SSIS
    * How to create your own custom tasks and user interfaces
    * How to create an application that interfaces with SSIS to manage the environment
    * A detailed usable case study for a complete ETL solution




Professional SQL Server 2005 Reporting Services




* Building on the first edition, the book explains reporting services architecture and business intelligence, shows how to conceptualize and design reports, and demonstrates how to captitalize on advanced report design and filtering techniques * The authors categorize common report types and lead the reader through each design, discussing its purpose and the conditions under which it could be more efficient * Detailed examples illustrate how to build and design report solutions, and show the hands-on deployment strategies that can be used for interacting with a variety of platforms * Features discussions on upgrading versus installing the new product from scratch and planning and designing security




Professional SQL Server 2005 XML (Programmer to Programmer)




Discusses SQL Server 2005 XML from the server and client sides Examines using XSLT to render the XML data that is retrieved from SQL Server, particularly for ASP.NET Addresses SQL Server relationship with schemas, SOAP, XML security, and .NET Makes extensive use of examples to solve problems that programmers face on an everyday basis and features Server 2005 XML best practices