Kamis, 19 Januari 2012

5 new posts


5 new posts

Link to Wow! eBook - Blog

Cloud Computing with the Windows Azure Platform

Posted: 19 Jan 2012 12:29 PM PST

Cloud Computing with the Windows Azure Platform

Book Description

Leverage the power of the Azure Services Platform for computing

With the Azure Services Platform, processing and storing data moves from individual corporate servers and Web sites to larger, more reliable, and more secure data centers. Roger Jennings, author of more than 30 books on technologies, shows you how to leverage the power of Azure and its related services for computing.

The book begins with a look at the differences between cloud computing and application hosting and examines the various issues that developers and IT managers face in moving from on-premise to cloud-based applications, including security, privacy, regulatory compliance, backup and recovery, asset cataloging, and other common technical issues. The author then drills down, showing basic for individual Azure components, including storage, Data Services, and Services. He then moves on to cover more advanced challenges.

  • Explains the benefits of using the Azure Services Platform for cloud computing
  • Shows how to program with components, including Azure Table and Blob storage, Services and Azure
  • Addresses advanced programming challenges of creating useful projects that combine cloud storage with Web applications or services
  • Companion Web site features complete, finished applications that can be uploaded to jump start a project

Roger Jennings clears away the clouds and gets you started using the Azure Services Platform.

From the Back Cover
Leverage the capabilities of Azure

Cloud-based applications make it easier to share data, and the Azure Platform moves processing and storage from individual corporate servers and websites to large data centers. With this book, Roger Jennings offers you an overview of cloud computing and shares his approach for hands-on programming of Windows Azure Storage Services (tables, blobs, and queues) and web, worker, and .NET Services applications. You’ll learn how to program with Azure components, while online chapters cover new and Workflow features.

  • Addresses various issues you may encounter when moving from on-premise to cloud-based applications (such as security, privacy, regulatory compliance, and backup and recovery)
  • Shows how to adapt authentication and role to Azure web roles
  • Reveals the benefits of offloading computing services to one or more WorkerRoles when moving to Windows Azure
  • Teaches you how to choose the optimum combination of PartitionKey and RowKey values for sharding Azure tables
  • Discusses ways to improve the scalability and of Azure tables

Book Details

  • Paperback: 360 pages
  • Publisher: Wrox (October 2009)
  • Language: English
  • ISBN-10: 0470506385
  • ISBN-13: 978-0470506387
Note: There is a file embedded within this post, please visit this post to download the file.

Related Posts


Professional Microsoft SQL Server Analysis Services 2008 with MDX

Posted: 19 Jan 2012 10:49 AM PST

Professional Microsoft SQL Server Analysis Services 2008 with MDX

Book Description

  • When used with the query language, Server Services allows developers to build full-scale applications to support such business functions as budgeting, forecasting, and market .
  • Shows readers how to build data warehouses and multi-dimensional databases, query databases, and use Services and other components of 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 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 . This authoritative book, written by key members of the Analysis Services product team at , 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 multi-dimensional databases. Within each chapter, you will not only learn how to use the features, but you’ll also discover more about the features at a user level and what happens behind the scenes to make things work. You’ll get a look at how features really operate, enabling you to understand how to use them to their full potential. Plus, you’ll sharpen your ability to problems that you might not have been able to otherwise.

What you will learn from this book

  • The basic concepts of using Analysis Services and the common operations you need to design your databases
  • How to create multi-dimensional databases (such as multiple measure groups, business intelligence wizards, key performance indicators, and more)
  • Methods for extending via external functions
  • Ways to administer your Analysis Services programmatically and design and optimize your cube for best performance
  • How data mining along with Office 2007 makes it easy to use and effective to perform analysis on data

Who this book is for
This book is for and data warehouse developers and administrators interested in exploiting the power of business intelligence and leveraging the 2008 tool set.

Table of Contents
Introduction

Part I: Introduction.
Chapter 1. Introduction to Data Warehousing and 2008 Analysis Services
Chapter 2. First Look at Analysis Services 2008
Chapter 3. Introduction to MDX
Chapter 4. Working with Data Sources and Data Source Views
Chapter 5. Dimension Design
Chapter 6. Cube Design
Chapter 7. Administering Analysis Services

Part II: Advanced Topics
Chapter 8. Advanced Dimension Design
Chapter 9. Advanced Cube Design
Chapter 10. Advanced Topics in MDX
Chapter 11. Extending MDX Using External Functions
Chapter 12. Data Writeback

Part III: Advanced and Performance
Chapter 13. Programmatic and Advanced
Chapter 14. Designing for Performance
Chapter 15. Analyzing and Optimizing Query Performance

Part IV: Integration with Microsoft Products
Chapter 16. Data Mining
Chapter 17. Analyzing Cubes Using Microsoft Office Components
Chapter 18. Using Data Mining with Office 2007
Chapter 19. Integration Services
Chapter 20. Services

Part V: Scenarios
Chapter 21. Designing Cubes
Chapter 22. Securing Your Data in Analysis Services
Chapter 23. Inventory Scenarios
Chapter 24. Financial Scenarios
Chapter 25. Web Analytics

Appendix A. MDX Functions
Index

Book Details

  • Paperback: 1056 pages
  • Publisher: Wrox (March 2009)
  • Language: English
  • ISBN-10: 0470247983
  • ISBN-13: 978-0470247983
Note: There is a file embedded within this post, please visit this post to download the file.

Related Posts


Professional Microsoft SQL Server 2008 Administration

Posted: 19 Jan 2012 10:44 AM PST

Professional Microsoft SQL Server 2008 Administration

Book Description

Server 2008 represents a sizable jump forward in scalability, , 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 Server. Server used to just be the job of a administrator (DBA), but as proliferates throughout smaller companies, many developers have begun to act as administrators as well. Additionally, some of the new features in are more developer-centric, and poor configuration of these features can result in poor . 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 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 tables and indexes. Administrators or DBAs support the production servers and often inherit the 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 of SQL Server already. For example, this book does not show you how to create a database or walk you through the installation of SQL Server using the wizard. Instead, the author of the installation chapter may provide insight into how to use some of the more advanced concepts of the installation. Although this book does not cover how to query a SQL Server database, it does cover how to tune the queries you’ve already written.

The first ten chapters of the book are about administering the various areas of SQL Server, including the developer and business intelligence features. Chapter 1 briefly covers the architecture of SQL Server and the changing role of the DBA. Chapters 2 and 3 dive into best practices on installing and upgrading to SQL Server 2008. Managing your SQL Server database instance is talked about in Chapter 4. This chapter also describes some of the hidden tools you may not even know you have.

Once you know how to manage your SQL Server, you can learn in Chapter 5 how to automate many of the redundant monitoring and maintenance tasks. This chapter also discusses best practices on configuring SQL Server Agent. Chapters 6 and 7 cover how to properly administer and automate many tasks inside of the business intelligence products, such as Integration Services and Services. Developers will find that Chapter 8 is very useful, as it covers how to administer the features, such as SQL . Chapter 9 explains how to secure your SQL Server from many common threats and how to create logins and users. Chapter 10 covers how to create a SQL Server project and do proper change in promoting your scripts through the various environments. It also covers the Policy-Based framework in SQL Server.

Chapters 11 through 15 make up the performance tuning part of the book. Chapter 11 discusses how to choose the right hardware configuration for your SQL Server in order to achieve optimal performance. After the hardware and operating system is configured, Chapter 12 shows you how to optimize your SQL Server instance for the best performance. Chapter 13 describes how to monitor your SQL Server instance for problematic issues such as blocking and locking. Chapters 14 and 15 discuss how to optimize the that accesses your tables and then how to index your tables appropriately.

Chapters 16 through 20 consist of the high-availability chapters of the book. Chapter 16 covers how to use the various forms of replication, while database mirroring is covered in Chapter 17. Classic issues and best practices with backing up and recovering your database are discussed in Chapter 18. Chapter 19 dives deeply into the role of log shipping in your high-availability strategy, and Chapter 20 presents a step-by-step guide to clustering your SQL Server and Windows 2008 server.

This edition of the book covers all the same great information we covered in the last book, and we've added loads of new content for SQL Server 2008, which adds numerous new features to improve the DBA's life. In short, the new version of SQL Server focuses on improving your efficiency, the scale of your server, and the performance of your environment, so you can do more in much less time, and with fewer resources and people. This means you can manage many servers at one time using Policy-Based , scale your I/O load using compression, and collect valuable information about your environment using data collectors, to name just a few key new features.

To follow the examples in this book, you will need to have SQL Server 2008 installed. If you wish to learn how to administer the business intelligence features, you need to have Services and the Integration Services components installed. You need a machine that can support the minimum hardware requirements to run SQL Server 2008; and you also need the AdventureWorks2008 and AdventureWorksDW2008 databases installed. Instructions for accessing these databases can be found in the ReadMe file on this book’s Web site.

Some features in this book (especially in the high-availability part) require the Enterprise or Developer Edition of SQL Server. If you do not have this edition, you will still be able to follow through some of the examples in the chapter with Standard Edition.

From the Back Cover
Professional ® SQL Server® 2008

SQL Server 2008 represents a significant jump forward in scalability and performance. Database administrators — and developers as well — will need to master new methods for effectively managing increasingly large and complex SQL Server environments.

This author team of SQL Server experts arms you with unique tips, tricks, and workarounds, including managing and monitoring SQL Server, automating administration, clustering, performance tuning, handling backup and recovery, and more. You’ll learn the various tools that are available to you with the 2008 release, as well as new features such as Performance Studio, Change Data Capture, Policy-based Management, and Query Governor. With a solid understanding of SQL Server 2008, you’ll be able to confidently handle even the most difficult SQL Server admin issues.

What you will learn from this book

  • Best practices for SQL Server 2008 installation
  • Tips for troubleshooting and securing the database engine
  • How to automate SQL Server
  • Ways to index your database
  • Methods for monitoring your SQL Server instance
  • How to performance tune your SQL Server instance

Who this book is for
This book is for experienced database administrators who are interested in learning best pratices for administering SQL Server 2008.

Table of Contents
Chapter 1. SQL Server 2005 Architecture
Chapter 2. SQL Server 2005 Installation Best Practices
Chapter 3. Upgrading SQL Server 2008 Best Practices
Chapter 4. Managing and Troubleshooting the Database Engine
Chapter 5. Automating SQL Server
Chapter 6. Integration Services Administration and Performance Tuning
Chapter 7. Analysis Services Administration and Performance Tuning
Chapter 8. Administering the Features
Chapter 9. Securing the Database Engine
Chapter 10. Change Management
Chapter 11. Configuring the Server for Optimal Performance
Chapter 12. Optimizing SQL Server 2005
Chapter 13. Monitoring Your SQL Server
Chapter 14. Performance Tuning
Chapter 15. Indexing Your Database
Chapter 16. Replication
Chapter 17. Database Mirroring
Chapter 18. Backup and Recovery
Chapter 19. SQL Server 2005 Log Shipping
Chapter 20. Clustering SQL Server 2005

Book Details

  • Paperback: 912 pages
  • Publisher: Wrox (November 2008)
  • Language: English
  • ISBN-10: 0470247967
  • ISBN-13: 978-0470247969
Note: There is a file embedded within this post, please visit this post to download the file.

Related Posts


Professional Microsoft SQL Server 2008 Reporting Services

Posted: 19 Jan 2012 10:38 AM PST

Professional Microsoft SQL Server 2008 Reporting Services

Book Description

  • Teaches solution architects, designers, and developers how to use ’s platform to create and business intelligence (BI) solutions
  • Updated with new information about holistic BI solutions, comprehensive OLAP/ Services , and complete production deployment scenarios
  • Includes 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 2008 Reporting Services

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/ Services reporting, and complete production-deployment scenarios.

You’ll learn how to write custom expressions and program functions to meet specific reporting needs. This will help you design, build, and deploy reports with capabilities far greater than any other reporting tools you may have used in the past. The techniques covered in the book will also enable you to take reporting further than you have before and provide your users with real business intelligence.

What you will learn from this book

  • Using reports to visualize important business-decision metrics
  • Building the presentation layer for an enterprise business intelligence solution
  • Reporting from OLAP cubes and relational systems
  • Enabling information workers to easily create their own self-service reports
  • Real-world report design patterns and recipes
  • Designing and deploying reports for enterprise portals and dashboards, including technologies
  • Advanced techniques for extending and adding functionality to Reporting Services

Who this book is for
This book is for report designers, developers, administrators, and business professionals interested in learning the advanced functionality, reporting, server , and security issues of Server 2008 Reporting Services.

Table of Contents
Foreword
Introduction

Part I: Getting Started
Chapter 1. Introducing Reporting Services
Chapter 2. Business Intelligence Solutions
Chapter 3. Reporting Services Installation
Chapter 4. Reporting Services Architecture

Part II: Report Design
Chapter 5. Basic Report Design
Chapter 6. Report Layout and Formatting
Chapter 7. Designing Data Access
Chapter 8. Advanced Report Design

Part III: Business Intelligence Reporting
Chapter 9. Reporting with Analysis Services
Chapter 10. Report Solution Patterns and Recipes

Part IV: Enabling End-User Reporting with Report Builder 1.0
Chapter 11. Report Models
Chapter 12. Report Builder 1.0

Part V: Administering Reporting Services
Chapter 13. Content
Chapter 14. Report Server

Part VI: Reporting Services Integration and Custom Programming
Chapter 15. Integrating Reports into Custom Applications
Chapter 16. Integrating Reports with
Chapter 17. Extending Reporting Services

Appendix A. RDL Object Model
Appendix B. T – Command Syntax Reference
Appendix . T – SQL System Variables and Functions
Appendix D. Reference
Index

Book Details

  • Paperback: 816 pages
  • Publisher: Wrox (December 2008)
  • Language: English
  • ISBN-10: 0470242019
  • ISBN-13: 978-0470242018
Note: There is a file embedded within this post, please visit this post to download the file.

Related Posts


Professional Microsoft SQL Server 2008 Integration Services

Posted: 19 Jan 2012 10:33 AM PST

Professional Microsoft SQL Server 2008 Integration Services

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 Server Integration Services ()
  • Renowned author Brian Knight and his expert coauthors show developers how to master the 2008 release of , 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 Server 2008 Integration Services

When Integration Services (SSIS) was released to the market in 2005, it took the Extract Transform Load (ETL) market by storm. Three years later, 2008 has introduced an even more mature rendition of SSIS that is focused on improving the scalability and of 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 skill set to a new level. After a basic review of the fundamental concepts of SSIS, you’ll move on to more in-depth topics such as extending the engine, synchronizing systems incrementally, managing the SSIS platform, and more. Plus, helpful examples and real-world case studies demonstrate advanced concepts and techniques. Once you get past the initial learning curve of the 2008 version of SSIS, you’ll be amazed by the power, effectiveness, and timesaving ability of SSIS—all of which are aimed at making your life easier.

What you will learn from this book

  • Ways that you can use the Script task in SSIS
  • How to load a data warehouse from the ground up
  • Techniques for scaling SSIS to make it more reliable
  • Ways to incrementally load and join data
  • Instructions for using containers to do looping in SSIS
  • How to expose the SSIS data flow to other programs, such as InfoPath and your own applications

Who this book is for
This book is for anyone who is interested in using SSIS for transforming data, creating a workflow, or maintaining an .

Table of Contents
Introduction
Chapter 1. Welcome to SQL Server Integration Services
Chapter 2. The SSIS Tools
Chapter 3. SSIS Tasks
Chapter 4. Containers
Chapter 5. The Data Flow
Chapter 6. Using Expressions and Variables
Chapter 7. Joining Data
Chapter 8. Creating an End-to-End Package
Chapter 9. Scripting in SSIS
Chapter 10. Loading a Data Warehouse
Chapter 11. Using the Relational Engine
Chapter 12. Accessing Heterogeneous Data
Chapter 13. Reliability and Scalability
Chapter 14. Understanding and Tuning the Data Flow Engine
Chapter 15. Source Control and Software Life Cycle
Chapter 16. DTS 2000 Migration
Chapter 17. Error and Event Handling
Chapter 18. and Extending SSIS
Chapter 19. Adding a User Interface to Your Component
Chapter 20. External and WMI Task Implementation
Chapter 21. Using SSIS with External Applications
Chapter 22. Administering SSIS
Chapter 23. Case Study. A Programmatic Example
Index

Book Details

  • Paperback: 1008 pages
  • Publisher: Wrox (October 2008)
  • Language: English
  • ISBN-10: 0470247959
  • ISBN-13: 978-0470247952
Note: There is a file embedded within this post, please visit this post to download the file.

Related Posts


Tidak ada komentar:

Posting Komentar