What is this book about?SQL Server 2000 is the latest and most powerful version of Microsoft's data warehousing and relational database management system. This new release is tightly integrated with Windows 2000 and offers more support for XML, as well as improved Analysis Services for OLAP and data mining.Professional SQL Server 2000 provides a comprehensive guide to programming with SQL Server 2000, from a complete tutorial on Transact-SQL to an in-depth discussion of new features, such as indexed views, user-defined functions, and the wealth of new SQL Server features to support XML. Whether you're coming to SQL Server 2000 from another relational database management system, upgrading your existing system, or perhaps wanting to add programming skills to your DBA knowledge, you'll find what you need in this book to get to grips with SQL Server 2000 development.What does this book cover?Here are just a few of the things covered in this book:A complete introduction to Transact-SQLDatabase design issuesCreating and using views, stored procedures, and user- defined functionsResponding to events with triggersMaking your SQL Server secureRetrieving your data as XMLAn introduction to Analysis ServicesMoving data using Data Transformation Services and the bulk copy programMaintaining the integrity of distributed data with replicationWho is this book for?This book is aimed at the SQL Server developer who wants to make the most out of the new features of SQL Server 2000. No knowledge of SQL Server is assumed, although in order to follow this book, you do need to have an understanding of programming basics such as variables, data types, and procedural programming. Database administration is also covered but only as it affects the SQL Server developer.

What is this book about?SQL Server 2000 is the latest and most powerful version of Microsoft's data warehousing and relational database management system. This new release is tightly integrated with Windows 2000 and offers more support for XML, as well as improved Analysis Services for OLAP and data mining.Professional SQL Server 2000 provides a comprehensive guide to programming with SQL Server 2000, from a complete tutorial on Transact-SQL to an in-depth discussion of new features, such as indexed views, user-defined functions, and the wealth of new SQL Server features to support XML. Whether you're coming to SQL Server 2000 from another relational database management system, upgrading your existing system, or perhaps wanting to add programming skills to your DBA knowledge, you'll find what you need in this book to get to grips with SQL Server 2000 development.What does this book cover?Here are just a few of the things covered in this book:A complete introduction to Transact-SQLDatabase design issuesCreating and using views, stored procedures, and user- defined functionsResponding to events with triggersMaking your SQL Server secureRetrieving your data as XMLAn introduction to Analysis ServicesMoving data using Data Transformation Services and the bulk copy programMaintaining the integrity of distributed data with replicationWho is this book for?This book is aimed at the SQL Server developer who wants to make the most out of the new features of SQL Server 2000. No knowledge of SQL Server is assumed, although in order to follow this book, you do need to have an understanding of programming basics such as variables, data types, and procedural programming. Database administration is also covered but only as it affects the SQL Server developer.

-- Huge audience -- this book will appeal to those who bought SQL Server 7 Developer's Guide, a 25,000+ copy best-seller-- The use of stored procedures is a required step for SQL Server developers -- this book completely addresses all aspects of use, from A-Z-- This will be one of the first books on the market to focus solely on this topic-- Expert author -- Sunderic writes for SQL Server Professional, Visual Basic Programmer's Journal, and other industry journals

The new edition of the successful previous version is 25 percent revised and packed with more than 200 pages of new material on the 2008 release of SQL Server Integration Services (SSIS)Renowned author Brian Knight and his expert coauthors show developers how to master the 2008 release of SSIS, which is both more powerful and more complex than everCase studies and tutorial examples acquired over the three years since the previous edition will contribute to helping illustrate advanced concepts and techniquesNew chapters include coverage of data warehousing using SSIS, new methods for managing the SSIS platform, and improved techniques for ETL operations

Get thorough coverage of SQL Server 2000—including extended XML capabilities and VS.NET updates with this expertly written resource. Learn to harness the full benefits of modular programming, and achieve faster execution and a reduction of network traffic. Included are a sample database and an end-to-end solution for a Web search engine.

SQL Server 2000 is the leading relational database in the Windows market. The increased manageability of SQL Server 2000 has "lowered the bar" with regard to the people that can use it – anyone can use a SQL Server database. However, this book recognizes that aspiring DBAs need more than just a basic knowledge of the available features in order to be considered "a safe pair of hands" for the database and the mission-critical data that is stored in it. They require direction and advice from an expert mentor who not only understands the features available and how they should be used, but also knows what it takes to be a good and effective DBA. In essence, this book is that "mentor", and this is why the book stands apart from the "feature overview" competition. The book teaches a database novice the core job and roles involved in administering a SQL Server database. It follows the lifecycle of the database, from installation, design and modeling, through development, tuning and securing to growth and migration. It provides practical advice ("How to..."), answers typical questions that they'll encounter from managers and developers ("How do I..."), and offers practical steps to overcome issues with which beginners traditionally struggle. At every stage, it establishes a range of tried-and-tested practices and techniques that will establish and maintain the health of a DB system ("How to be a good DBA").

"A great resource to help you unlock the hidden gems in SQL Server Reporting Services." Brian Welcker Group Program Manager Microsoft SQL Server Reporting Services With Microsoft SQL Server 2005 you can structure and store terabytes of data-but how do you make sense of that much information? Reporting Services transforms raw data into meaningful reports and puts your valuable information to work. SQL Server 2005 Reporting Services in Action shows you how to build effective Windows and Web-based reporting solutions using SQL Server 2005. Using this example-driven book, you'll build Reporting Services-centric solutions, including report forecasting, RSS feeds, ASP.NET web controls for server-side report generation, extending Reporting Services to report on ADO.NET datasets, delivering reports to Web services, authenticating users, performance testing, and capacity planning. You'll quickly move beyond canned reports and put the Report Designer through its paces. The book will show you how to add interactive features to your tabular reports and how to improve performance by using external images without taking up valuable database real estate. When you have large systems, efficiency is key to productivity. Author Bret Updegraff shows you how to avoid doing the same tasks twice. You'll see a nifty sales forecast that uses embedded code to create reusable utility functions that you can call from multiple places your reports. As well, you'll find fundamentals like employing XSLT to create XML reports and advanced techniques such as accessing custom code in an external .NET assembly. Reporting Services 2005 lets you give users greater control over their reporting needs. SQL Server 2005 Reporting Services in Action will help you provide safe, user-friendly reporting options to your users and free up your time for more important tasks. This book shows you how to set up ad hoc reporting through Report Builder so business users can get the information you need from the database without your help! You won't stop with the basics, though. You'll also learn how to apply advanced filters and security practices to protect your data from unwelcome or misguided queries. Of course, this new edition is thoroughly updated to include coverage of all the new features introduced with SQL Server 2005. You'll see:Direct Client Printing: Send a report directly to a printer without having to export to printable format first End User Sort: Let the end user to re-sort data within the report Multi Valued Parameters: Use multiple values for parameters Custom Report Items: Build and embed custom server controls You'll also work with the improved Report Designer, Report Builder, and Analysis Services Query Builder. You'll learn about SharePoint WebParts and the Report Viewer Controls for WinForms and ASP.NET, as well. SQL Server 2005 Reporting Services in Action is a revised edition of Microsoft Reporting Services in Action by Teo Lachev, published by Manning Publications, August 2005, ISBN 1932394222.

"A great resource to help you unlock the hidden gems in SQL Server Reporting Services." Brian Welcker Group Program Manager Microsoft SQL Server Reporting Services With Microsoft SQL Server 2005 you can structure and store terabytes of data-but how do you make sense of that much information? Reporting Services transforms raw data into meaningful reports and puts your valuable information to work. SQL Server 2005 Reporting Services in Action shows you how to build effective Windows and Web-based reporting solutions using SQL Server 2005. Using this example-driven book, you'll build Reporting Services-centric solutions, including report forecasting, RSS feeds, ASP.NET web controls for server-side report generation, extending Reporting Services to report on ADO.NET datasets, delivering reports to Web services, authenticating users, performance testing, and capacity planning. You'll quickly move beyond canned reports and put the Report Designer through its paces. The book will show you how to add interactive features to your tabular reports and how to improve performance by using external images without taking up valuable database real estate. When you have large systems, efficiency is key to productivity. Author Bret Updegraff shows you how to avoid doing the same tasks twice. You'll see a nifty sales forecast that uses embedded code to create reusable utility functions that you can call from multiple places your reports. As well, you'll find fundamentals like employing XSLT to create XML reports and advanced techniques such as accessing custom code in an external .NET assembly. Reporting Services 2005 lets you give users greater control over their reporting needs. SQL Server 2005 Reporting Services in Action will help you provide safe, user-friendly reporting options to your users and free up your time for more important tasks. This book shows you how to set up ad hoc reporting through Report Builder so business users can get the information you need from the database without your help! You won't stop with the basics, though. You'll also learn how to apply advanced filters and security practices to protect your data from unwelcome or misguided queries. Of course, this new edition is thoroughly updated to include coverage of all the new features introduced with SQL Server 2005. You'll see:Direct Client Printing: Send a report directly to a printer without having to export to printable format first End User Sort: Let the end user to re-sort data within the report Multi Valued Parameters: Use multiple values for parameters Custom Report Items: Build and embed custom server controls You'll also work with the improved Report Designer, Report Builder, and Analysis Services Query Builder. You'll learn about SharePoint WebParts and the Report Viewer Controls for WinForms and ASP.NET, as well. SQL Server 2005 Reporting Services in Action is a revised edition of Microsoft Reporting Services in Action by Teo Lachev, published by Manning Publications, August 2005, ISBN 1932394222.