Book Description

• When used with the MDX query language, SQL Server Analysis Services allows developers to build full-scale database applications to support such business functions as budgeting, forecasting, and market analysis.
• Shows readers how to build data warehouses and multi-dimensional databases, query databases, and use Analysis Services and other components of SQL Server to provide end-to-end solutions
• Revised, updated, and enhanced, the book discusses new features such as improved integration with Office and Excel 2007; query performance enhancements; improvements to aggregation designer, dimension designer, cube and dimension wizards, and cell writeback; extensibility and personalization; data mining; and more

From the Back Cover
The new features of Analysis Services 2008 make it even easier to use andbuild your databases for efficient and improved performance. This authoritative book, written by key members of the Analysis Services product team at Microsoft, explains how to best use these enhancements for your business needs. The authors provides you with valuable insight on how to use Analysis Services 2008 effectively to build, process, and deploy top-of-the-line business intelligence applications.

You’ll explore everything that Analysis Services 2008 has to offer and examinethe important features of this product with the help of step-by-step instructionson building Download Now »

Book Description

SQL Server 2008 represents a sizable jump forward in scalability, performance, and usability for the DBA, developer, and business intelligence (BI) developer. It is no longer unheard of to have 20-terabyte databases running on a SQL Server. SQL Server administration used to just be the job of a database administrator (DBA), but as SQL Server proliferates throughout smaller companies, many developers have begun to act as administrators as well. Additionally, some of the new features in SQL Server are more developer-centric, and poor configuration of these features can result in poor performance. SQL Server now enables you to manage the policies on hundreds of SQL Servers in your environment as if you were managing a single instance. We’ve provided a comprehensive, tutorial-based book to get you over the learning curve of how to configure and administer SQL Server 2008.

Whether you’re an administrator or developer using SQL Server, you can’t avoid wearing a DBA hat at some point. Developers often have SQL Server on their own workstations and must provide guidance to the administrator about how they’d like the production configured. Oftentimes, they’re responsible for creating the database tables and indexes. Administrators or DBAs support the production servers and often inherit the database from the developer.

This book is intended for developers, DBAs, and casual users who hope to administer or may already be administering a SQL Server 2008 system and its business intelligence features, such as Integration Services. This book is a professional book, meaning the authors assume that you know the basics about how to query a SQL Server and have some rudimentary concepts Download Now »

Book Description

• Teaches solution architects, designers, and developers how to use Microsoft’s reporting platform to create reporting and business intelligence (BI) solutions
• Updated with new information about holistic BI solutions, comprehensive OLAP/Analysis Services reporting, and complete production deployment scenarios
• Includes programming examples focused on specific, scenario-based solutions
• Explains 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 techniques

From the Back Cover
Professional Microsoft SQL Server 2008 Reporting Services

SQL Server Reporting Services makes reporting faster and easier than ever. This hands-on guide will show you how to harness the full power of Reporting Services to create reporting and business intelligence solutions that meet your company’s needs. It walks you step-by-step through the fundamentals of designing the most effective reports by following careful planning considerations.

The authors progress from beginning to advanced report design and filtering techniques, showing you the conditions where reports could be more efficient. They also explore holistic business intelligence solutions, comprehensive OLAP/Analysis Services reporting, and complete production-deployment scenarios. Download Now »

Book Description

• 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 ever
• Case studies and tutorial examples acquired over the three years since the previous edition will contribute to helping illustrate advanced concepts and techniques
• New chapters include coverage of data warehousing using SSIS, new methods for managing the SSIS platform, and improved techniques for ETL operations

From the Back Cover
Professional Microsoft SQL Server 2008 Integration Services

When SQL Server Integration Services (SSIS) was released to the market in SQL Server 2005, it took the Extract Transform Load (ETL) market by storm. Three years later, SQL Server 2008 has introduced an even more mature rendition of SSIS that is focused on improving the scalability and performance of SQL Server and also serves as a very powerful tool for performing ETL operations, which are central to data warehousing.

With this book, an assembled team of professionals has combined their years of experience and tried-and-true best practices to present you with the tools to take your SSIS Download Now »

Book Description

WebMatrix is the latest addition to the hugely popular Microsoft ASP.NET web platform. This exciting new technology aims to simplify the process of developing websites by combining the new and powerful Razor syntax with a fully extensible set of data and HTML helpers for performing common web tasks.

The WebMatrix installation includes all the tools the developer requires to quickly create fully-functional, data-driven, dynamic sites using ASP.NET web pages. The lightweight custom development tool works alongside SQL Server Compact Edition and Internet Information Services (IIS) Express to provide a seamless and easy-to-use environment which enables the web developer to concentrate on the rapid development of feature-rich websites, without the need to learn the complex concepts and highly structured programming models which many other frameworks require.

What you’ll learn

• How to combine HTML and server-side C# Razor code with the powerful .NET framework to easily develop websites using Microsoft WebMatrix
• How to create layouts which can be applied across multiple pages
• How to interact with SQL Server and other databases, using proven techniques and best practices
• How to add social networking features to your web site using WebMatrix Helpers
• How to create your own custom functions and helpers to provide reusable code and content
• How to secure your website using a role-based membership model
• How to deploy your website to a hosting provider Download Now »

Book Description

In the Fifth Edition, Advanced Visual Basic 2010 helps those who are familiar with the fundamentals of Visual Basic 2010 programming harness its power for more advanced uses. Coverage of sophisticated tools and techniques used in the industry today include various database, ASP.NET, LINQ, WPF and Web Services topics. After studying the book and completing the programming exercises, students should be able to create small- to medium-sized Windows and Web applications that use databases. They will also gain essential concepts in object-oriented programming, event-driven programming, and test-driven development. Each subject is presented in an understandable style that makes this book a leader in the field.

Table of Contents
Chapter 1. Classes
Chapter 2. Input Validation and User Interfaces
Chapter 3. Collections
Chapter 4. Using SQL Server Databases
Chapter 5. ADO.NET Database Objects
Chapter 6. Advanced Classes
Chapter 7. LINQ to SQL
Chapter 8. Creating Web Applications
Chapter 9. Programming Web Forms Download Now »