Product Description: Learn to design more effective and sophisticated business reportsWhile most users of SQL Server Reporting Services are now comfortable designing and building simple reports, business today demands increasingly complex reporting. In this book, top Reporting Services design experts have contributed step-by-step recipes for creating various types of reports...read more

Product Description: Teaches solution architects, designers, and developers how to use Microsoft's reporting platform to create reporting and business intelligence (BI) solutionsUpdated with new information about holistic BI solutions, comprehensive OLAP/Analysis Services reporting, and complete production deployment scenariosIncludes programming examples focused on specific, scenario-based solutionsExplains reporting services architecture and business intelligence, teaches the fundamentals of designing reports through the use of careful planning considerations, and covers advanced report design and filtering technique...read more

Provides information on using SQL Server 2005 integration services to build enterprise ETL applications.

A guide to SQL Server 2005 covers system architecture, file storage, security, and troubleshooting.

Presents instructions on ways to build reports, design report solutions, and develop deployment strategies for interacting with various platforms, with information on such topics as design, data access, URL access, and caching and subscriptions.

Beginning Transact-SQL with SQL Server 2000 and 2005Transact-SQL is a powerful implementation of the ANSI standard SQL database query language. In order to build effective database applications, you must gain a thorough understanding of these features. This book provides you with a comprehensive introduction to the T-SQL language and shows you how it can be used to work with both the SQL Server 2000 and 2005 releases.Beginning with an overview of the SQL Server query operations and tools that are used with T-SQL, the author goes on to explain how to design and build applications of increasing complexity. By gaining an understanding of the power of the T-SQL language, you'll be prepared to meet the ever-increasing demands of programming.What you will learn from this bookHow T-SQL provides you with the means to create tools for managing hundreds of databasesVarious programming techniques that use views and stored proceduresWays to optimize query performanceHow to create databases that will be an essential foundation to applications you develop laterWho this book is forThis book is for database developers and administrators who have not yet programmed with Transact-SQL. Some familiarity with relational databases and basic SQL is helpful, and some programming experience is helpful.Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

Access 2002 is the core database application within the Office XP suite. This book focuses on the programming language that underlies Access 2002 (and all the other office products) – VBA (Visual Basic for Applications). While you can achieve a great deal in Access without ever knowing anything about programming, sooner or later you will want to develop applications with greater scope and flexibility, and a professional feel and functionality - this is where VBA comes into its own. Using VBA with Access is an incredibly powerful technique as, amongst other things, it allows you to create custom user interfaces, to automate complex tasks, to integrate Access with other parts of the Office suite, and to provide enhanced security for your database. VBA has a very simple syntax which makes it an ideal starting place for novice programmers and a perfect lead in to Microsoft's popular programming language, Visual Basic. This book covers everything you need to gain the confidence and knowledge to go away and begin to write your own programs. All the concepts are illustrated with plenty of interesting and practical examples and exercises. This book is a revision of the best-selling Beginning Access 97 and Beginning Access 2000 VBA books, reworked to provide a rich tutorial to programming Access 2002 with VBA. New material covers the enhanced options in Access 2002 for publishing data to the Web, handling XML, integrating with SQL Server Desktop Engine, and so on.

What is this book about?SQL Server Reporting Services is the customizable reporting solution for report designers and programmers. This hands-on guide will get you up to speed quickly. You can create powerful reports without programming knowledge and extend reporting solutions using VB, C#, and ASP.NET.Packed with detailed examples of building reports, designing report solutions, and developing deployment strategies for interacting with various platforms, this book prepares you to take full advantage of a revolutionary new tool.What does this book cover?Here are just some of the things you'll learn in this book:Details of programming reports and report scriptingAdvanced report design, including drill-down reports, nested lists, drill-through, links, and dynamic contentHow to manage reports using Report Manager or program codeHigh-level strategies for business support systemsRendering reports using .NET code, .NET IO namespace classes, and URL renderingDeployment strategies to handle hardware, software, and platform considerations, licensing issues, and scaling optionsWho is this book for?This book is for developers and report designers using VB, C#, and ASP.NET who need to tie into SQL Server to build customized reports or to integrate reports into Windows or Web-based applications.

Product Description: Data warehouses have evolved to cope with the huge volumes of data flowing through the workplace by separating the data used for reporting and decision making from the operational systems. The purpose of the data warehouse is simply to store the raw data, and in combination with Microsoft SQL Server 2000 Analysis Services, this data can be transformed into accessible information that reflects the real factors affecting the enterprise...read more (view table of contents, read Amazon.com's description)

Product Description: Access 2000 is the database of choice for many small to medium businesses. Using Access in conjunction with VBA, VB or ASP it is possible to develop sophisticated systems for storing and manipulating business data. Office 2000 and Access 2000 offer many new features that can be used with VB to create great user interfaces and applications...read more