Showing posts with label ssis. Show all posts
Showing posts with label ssis. Show all posts

Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition Review

Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition
Average Reviews:

(More customer reviews)
Are you looking to buy Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition? Here is the right place to find the great deals. we can offer discounts of up to 90% on Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition ReviewThe database used in this book is not installing and keep on giving me an error when I try to install it. book has pretty good examples to practice. But the book became useless to me as I can not practice the examples given in the book.
Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition Overview
Transform Raw Data Into Meaningful Business Intelligence with SSIS
Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource.

Build SSIS packages using the Import and Export Wizard and Business Intelligence Development Studio
Create Loop and Task Host Containers with Control Flow Designer
Administer SSIS from SQL Server Management Studio and dutil
Secure packages using encryption, roles, signatures, and permissions
Build-in memory lookups and transformations using the Data Flow Engine
Extend functionality using custom scripts and ActiveX components
Use SCD transformations to load data warehouses and data marts
Learn to build a Star Schema and Parallel Data Warehouse
Migrate Data Transformation Services 2000 and SSIS 2005 packages


Want to learn more information about Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition?

>> Click Here to See All Customer Reviews & Ratings Now
Read More...

Accelerated SQL Server 2008 (Expert's Voice) Review

Accelerated SQL Server 2008 (Expert's Voice)
Average Reviews:

(More customer reviews)
Are you looking to buy Accelerated SQL Server 2008 (Expert's Voice)? Here is the right place to find the great deals. we can offer discounts of up to 90% on Accelerated SQL Server 2008 (Expert's Voice). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Accelerated SQL Server 2008 (Expert's Voice) ReviewIn support of a current project, I was searching for whatever books I could find to help me with SQL Server 2008. This is one of the first available "credible" books I found. Credible since I have a number of other APRESS technical books that I found useful, and credible since the authors list certainly fit the lead-in on the cover - "The Experts Voice in SQL Server".
I found this book to be exactly what the title says (Accelerated) and exactly what I needed for my project effort. Let me explain - I have a significant background in database administration, and had worked on literally hundreds of SQL Server 2000 related projects. But due to job focus on other responsibilities, my exposure to SQL Server 2005 was limited to a couple of projects. So when this high profile SQL 2008 project came along, I really needed something to quickly jumpstart my learning.
As I went through the installation and the configuration of the database engine, analysis services, reporting services, and integration services in my environments, I used all the associated chapters in this book. It gave me the pertinent information, the important differences and improvements, without bogging me down in the basic things I felt I already knew.
I felt that the first 13 chapters covering primarily the database engine and associated features - Installation, Policy, Availability, Performance, Security, Monitoring, Service Broker, Full Text Search, and TSQL enhancements were very complete and excellent resource for someone with experience looking for a jumpstart. I don't see myself buying another book to supplement this knowledge - forums and whitepapers will probably be all that I will need - in the short term at least.
I admit that I skimmed the chapter or two on .Net integration and programming assemblies - but I will be back to it in a couple of weeks to be sure.
Since this current project requires a good deal of XML based data integration between our existing world and this new application - the chapters on XML and XQuery were of particular interest to me. I found them a valuable and complete introduction. The next few months of the project will show how valuable this really was, but I came away feeling pretty good about what we might be able to do to leverage this.
Because my work for the past couple of years has been focused on BI, I went through those last three chapters covering Business Intelligence (analysis server, reporting services, integration services) multiple times. First to do the installation and configuration, second to see what I was that I missed, and a final time to understand what I thought the authors had missed. This section provides a good basic intro to the products, and gives you what you need to get them setup and functional. To exploit them however, you will need to look for further resources.
You can look at this book as a focused set of expert recommendations, advice, and key bullet points around its 3 major divisions - the Enterprise data platform (I rate it excellent in that coverage), development in SQL Server (I'd rate it good, but I know I need to read it again), and Business Intelligence (I'd rate it useful, but basic in the coverage).
What this book is not, is an in-depth and complete coverage of all the specifics of each of the SQL 2008 vertical product features. If your primary interest is in one of those features outside the database engine itself - Reporting Services or Analysis Services, you will need to follow this book up with one of the detailed and targeted books.
At the end of the day - this book gave me exactly what I needed, when I needed it. That makes it a good book in my view, a keeper for my top bookself, and one I can recommend to others in similar circumstances.
Accelerated SQL Server 2008 (Expert's Voice) OverviewAccelerated SQL Server 2008 is a fast introduction to SQL Server 2008 for experienced database professionals. The book appeals to readers who are smart, who learn fast, and who do not want to wade through a large amount of introductory material. The goal is to impart the essentials of using SQL Server 2008 as quickly as possible.

Want to learn more information about Accelerated SQL Server 2008 (Expert's Voice)?

>> Click Here to See All Customer Reviews & Ratings Now
Read More...