An authoritative guide to designing effective solutions for data cleansing, ETL, and file management with SQL Server 2008 Integration Services
SQL Server Integration Services (SSIS) is the leading tool in the data warehouse industry, used for performing extraction, transformation, and load operations.
After an overview of SSIS architecture, the authors walk you a series of real-world problems and show various techniques for handling them.
- Shows you how to design SSIS solutions for data cleansing, ETL and file management
- Demonstrates how to integrate data from a variety of data sources,
- Shows how to monitor SSIS performance,
- Demonstrates how to avoid common pitfalls involved with SSIS deployment
- Explains how to ensure performance of the deployed solution and effectively handle unexpected system failures and outages
- The companion Web site provides sample code and database scripts that readers can directly implement
This book shows you how to design, build, deploy, and manage solutions to real-world problems that SSIS administrators and developers face day-to-day.
More Info:
http://www.amazon.com/Microsoft-Server-2008-Integration-Services/dp/0470525762/
Continue Reading »
"Microsoft SQL Server 2008 Integration Services: Problem, Design, Solution" Full Fast Download
¶
Posted 09 March 2010
§
eBooks
‡
°
Also tagged:
A hands-on resource for SQL Server 2008 troubleshooting methods and tools
SQL Server administrators need to ensure that SQL Server remains running 24/7. Authored by leading SQL Server experts and MVPs, this book provides in-depth coverage of best practices based on a deep understanding of the internals of both SQL Server and the Windows operating system.
You’ll get a thorough look at the SQL Server database architecture and internals as well as Windows OS internals so that you can approach troubleshooting with a solid grasp of the total processing environment. Armed with this comprehensive understanding, readers will then learn how to use a suite of tools for troubleshooting performance problems whether they originate on the database server or operating system side.
- Shows how to develop a methodology for troubleshooting based on a thorough understanding of SQL Server 2008 and Windows OS internals
- Covers mastering specific troubleshooting tools and interpreting their output so that you can quickly identify and resolve any performance issue
- Details all the free and proprietary tools that allow you to analyze and determine the source of a system-wide performance problem
- Examines how it is critical for both SQL Server and Windows technologies to run smoothly in order to ensure effective SQL Server performance
This practical guide will help you pro-actively monitor and avoid SQL Server problems.
More Info:
http://www.amazon.com/Professional-Server-2008-Internals-Troubleshooting/dp/0470484284/
Continue Reading »
"Professional SQL Server 2008 Internals and Troubleshooting" Full Fast Download
¶
Posted 12 February 2010
§
eBooks
‡
°
Also tagged:
Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you’ll gain the deep knowledge you need to exploit key architectural changes—and capture the product’s full potential.
Discover how SQL Server works behind the scenes, including:
- What happens internally when SQL Server builds, expands, shrinks, and moves databases
- How to use event tracking—from triggers to the Extended Events Engine
- Why the right indexes can drastically reduce your query execution time
- How to transcend normal row-size limits with new storage capabilities
- How the Query Optimizer operates
- Multiple techniques for troubleshooting problematic query plans
- When to force SQL Server to reuse a cached query plan—or create a new one
- What SQL Server checks internally when running DBCC
- How to choose among five isolation levels and two concurrency models when working with multiple concurrent users
More Info:
http://www.amazon.com/Microsoft-SQL-Server-2008-Internals/dp/0735626243/
Continue Reading »
"Microsoft SQL Server 2008 Internals" Full Fast Download
¶
Posted 12 February 2010
§
eBooks
‡
°
Also tagged:
Microsoft SQL Server Integration Services is Microsoft’s powerful platform for building enterprise-level data integration and data transformation solutions. It’s a powerful product, but it’s also complex and can be confusing if you don’t have a clear map for the journey. Microsoft SQL Server 2008 Integration Services Unleashed will be the only book you’ll need to harness the power that Integration Services provides.
Through clear, concise explanations and samples, you’ll grasp a clear understanding of working in the Integration Services environment, including how to set up stock components, how to use the various designer features, and how to gain practical knowledge on configuring, deploying, securing, and managing packages. Sample packages are provided to reinforce the discussion and quickly help you gain hands-on experience, and more complex topics such as Data Flow Task internals and tuning, advanced transformations, and writing custom components are all illustrated in easy-to-understand graphics. In addition, there are several custom tasks and transformations and two useful utilities with full source code available for you to use and study, including an ADO.NET destination, a text file encryption task, and a data profiling transform.
Detailed information on:
- Using the powerful Integration Services tools to create solutions without the need to write lines of code
- Creating packages programmatically or developing custom tasks via the Integration Services object
- Building robust packages to solve common requirements
- Securing packages for different environments
- Using often overlooked or unknown platform features
- Setting up all the stock components, including data flow components, tasks, Foreach enumerators, connection managers, and log providers
- Writing robust and useful custom tasks
- Building packages that seamlessly deploy to other environments
- Writing custom data flow adapters and transforms
- Using script tasks and components
- Easily modifying configurations for multiple packages simultaneously
- Writing a Task UI that looks just like the stock tasks
- Tapping into the power of Integration Services for accessing heterogeneous data sources
- Using expressions to make packages more responsive to the environment
- Migrating your DTS packages with no stress
Kirk Haselden is the Group Program Manager for the Microsoft Master Data Management product forthcoming in the next wave of Office SharePoint Services and owns the long term strategy, vision, planning, and development of that product. Kirk has been with Microsoft for 12 years in various groups including Hardware, eHome, Connected Home, SQL Server, and Office Business Platform. He was the development manager for Integration Services and the primary designer for the runtime, as well as many of the tasks. He has written a number of articles for SQL Server Magazine, speaks regularly at industry events, writes profusely on his personal and MSDN blog, and holds 35 patents or patents pending.
More Info:
http://www.amazon.com/Microsoft-Server-Integration-Services-Unleashed/dp/0672330326/
Continue Reading »
"Microsoft SQL Server 2008 Integration Services Unleashed" Full Fast Download
¶
Posted 13 January 2010
§
eBooks
‡
°
Also tagged:
If you’re a SQL Server 2008 data warehousing developer or analyst, you’ll want to harness the power of SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)and SQL Server Reporting Services (SSRS.
After finishing this cool video training you’ll be able to: extract, transform, and load data into meaningful end-user information; create, deploy, and utilize data warehousing cubes and dimensions for data analysis; and create and deploy data reports in various formats.
This series maps to Microsoft exam 70-448, so it carefully prepares you for that exam.
Exam-Pack 70-448: Microsoft SQL Server 2008 Business Intelligence Development and Maintenance contains:
- SQL Server 2008 SSIS Overview
- SSIS: More ETL
- SSIS: Troubleshooting & Error Handling Free video
- SSIS: Deployment
- SSIS: Handling Events and Custom .NET Code
- SSAS: Dimensions, Measures & Cubes
- SSAS: Dimension Attributes
- SSAS: Dimension Relationships
- More SSAS Features
- SSAS: Key Performance Indicators (free video!)
- SSAS: More Cube Options
- SSAS Data Mining
- Introduction to SSRS
- Advanced SSRS
- SSRS Management & Deployment
More Info:
http://cbtnuggets.com/webapp/product?id=467
Continue Reading »
"CBT Nuggets Microsoft SQL Server 2008 Exam Pack 70 448-iNKiSO" Full Fast Download
Are you ready to design and plan database business solutions for your company? SQL Server 2008 offers database managers lots of built in controls and plenty of great opportunity to enhance their reputations.
In this CBT Nuggets video series you’ll learn to plan the design and implementation of your SQL Server 2008 SSIS, SSAS and SSRS projects.
This training maps to Microsoft exam 70-452. After watching this series you’ll be fully prepared to take the exam and earn Microsoft PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008
Published certification. It’s also your final towards earning SQL Server 2008 Business Intelligence MCITP Certification.
Exam-Pack 70-452: Microsoft SQL Server 2008 includes to following:
- SSRS Architecture Overview
- SSRS & .NET
- SSRS Data Sets & Filters
- SSRS Templates, RDL & Advanced Reports
- SSRS Deployment & Migration (free video!) video
- Scaling SQL Server 2008
- SQL Server 2008 Performance
- Aggregations & Partitions
- Data Mining Design
- SQL Server 2008 Advanced Data Mining
- SQL Server 2008 Sharepoint Integration
- SQL Server 2008 Visualization Tools
- SQL Server 2008 Auditing
- SSAS — Moving Packages
- SSAS International Considerations
More Info:
http://cbtnuggets.com/webapp/product?id=466
Continue Reading »
"CBT Nuggets Microsoft PRO SQL Server 2008 Exam Pack 70 452-iNKiSO" Full Fast Download
In this course, you will learn how to use SQL Server 2008 Reporting Services. Explore its basic architecture and gain a basic understanding of the components of SSRS 2008. You’ll then explore tabular and list reports that employ datasets and data regions. As you progress you’ll learn to add custom expressions, custom functions and format your reports using Visual Studio 2008 and SQL Server 2008 Business Intelligence Studio. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. You’ll then understand how Reporting Services parameters work and create parameters in ad-hoc SQL. Next you’ll be building Matrix reports and charts then explore the use of Reporting Services gauges. The Deployment of Reporting Services projects follow using a variety of formats and client-side printing. You’ll gain knowledge of SSRS Security in managing of user roles and accounts. You’ll also discover how to view reports using URL access and the Reporting Services Web Service API, without requiring users to use Internet Explorer. Finally, you’ll learn how to empower your users to create ad-hoc reports using Report Builder and Report Model projects.
Prerequisites: This course assumes no prior knowledge of SQL Server Reporting Services. This course does assume prior knowledge of SQL Server 2008 and the use of SQL Server Management Studio for development, Visual Studio 2008 using Visual Basic and administrative tasks. Write and run expressions, script files and diagnose problems that occur.
In this course, you will learn:
- Create tabular and list reports.
- Build expressions and how they are used within SSRS.
- Use global, field and parameter collections.
- Create Groups using the grouping pane for Details Group and Row Groups.
- Use parameters with stored procedures, with values on reports and unbound parameters.
- Create Matrix reports and see the new features of Matrix reports for SSRS 08.
- Deploy reports and use the report manager.
- Use SSRS Security, SSL and Data Source Security.
- Use Reporting Services APIs and Report Viewer Controls.
- Create a Web Service, a Web Service Subscription and Custom Assemblies.
More Info:
http://www.appdev.com/prodfamily.asp?catalog%5Fname=AppDevCatalog&category%5Fname=SR8Product
Continue Reading »
"AppDev Microsoft SQL Server Reporting Services 2008 DVD-iNKiSO" Full Fast Download
This course will enable technology professionals with little or no ETL experience to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling, and logging techniques.
Prerequisites: This course assumes no prior knowledge of SQL Server Integration Services. This course does assume prior knowledge of SQL Server 2008 and the use of SQL Server Management Studio for development and administrative tasks. You should be able to create CRUD (create, retrieve, update, and delete) queries using T-SQL, understand basic relational databases design, run script files and diagnose problems that occur, and have experience building applications that access data stored in SQL Server. You must also know how to connect to an instance of SQL Server 2008 using the various connection dialog boxes in Management Studio and development tools.Other tools used in this course include Notepad, Microsoft Excel, and basic features of Windows.
In this course, you will learn:
- How to use BIDS to create well-designed packages.
- About Control Flows, how to build them using many of the built-in tasks, including the various containers.
- How to use the Data Flow task to perform primary ETL operations.
- About variable and configurations to make your packages dynamic and resilient to changes in environments.
- About the features in BIDS and Integration Services that help you troubleshoot a package.
- How to deploy and manage packages effectively.
- How to write script so that you can go beyond the built-in tasks, data sources and destinations, and transformations, as well as building and using custom components.
- Best practices that will make it easier to develop and maintain a package over its entire life cycle.
- About using Integration Services for tasks other than traditional ETL operations.
More Info:
http://www.appdev.com/prodfamily.asp?catalog%5Fname=AppDevCatalog&category%5Fname=SI8Product
Continue Reading »
"AppDev SQL Server Integration Services 2008 DVD-iNKiSO" Full Fast Download
The R2 release brings significant new capabilities and enhancements that can help your business keep pace with todays growing and changing data management needs. Increase productivity and reduce data management costs by taking advantage of an even more scalable platform with comprehensive database and application management tools.
More Info:
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
Continue Reading »
"Microsoft SQL Server 2008 R2 Enterprise Evaluation November CTP DVD-LiBiSO" Full Fast Download
¶
Posted 11 November 2009
§
Apps
‡
°
Also tagged:
Data is the foundation of all networks, and how we access that data is the critical function of every IT system. As a database administrator you’re the critical go-to person in your organization’s IT department, because you’re the one who manages and protects data access.
Becoming a great database designer and problem solver — and having the certification to prove it — means getting the right training. Whether you’re an experienced SQL Server professional or a new database administrator, this CBT Nuggets video series is the perfect place to start.
Ace trainer Tim Warner gives you a broad overview of SQL Server 2008, including a full discussion of new features and comparison between SQL Server 2008 and earlier editions of the product (this information will be useful to upgraders).
But regardless of whether you’re a new or existing database administrator (DBA), Tim provides you with a deep understanding of Microsoft’s latest version of its enterprise relational database management system (RDBMS), SQL Server 2008.
Every video nugget in this series is loaded with practical tips, tricks, and Web/product references that both DBA newcomers and veterans will find valuable.
Plus, Tim has carefully mapped his training to Microsoft’s 70-432 exam. Passing this exam earns you MCTS certification, and moves you just one test away from prestigious MCITP certification.
Microsoft Windows 2008 Network Infrastructure, Configuring contents:
- Series Overview
- Installing and Configuring SQL Server 2008 Part 1
- Installing and Configuring SQL Server 2008 Part 2
- Managing the SQL Server Agent Service
- Managing SQL Server Agent Jobs (free video)
- Administering SQL Server Agent Alerts
- Implementing Policy-Based Management
- Managing SQL Server 2008 Security Part 1
- Managing SQL Server 2008 Security Part 2
- Managing SQL Server 2008 Security Part 3
- Administering SQL Server 2008 Disaster Recovery Part 1
- Administering SQL Server 2008 Disaster Recovery Part 2
- Administering SQL Server 2008 Disaster Recovery Part 3
- Administering SQL Server 2008 Disaster Recovery Part 4
- Importing and Exporting Data
- Implementing Data Partitions
- Managing Indexes and Collations
- Monitoring and Troubleshooting SQL Server 2008 Part 1
- Monitoring and Troubleshooting SQL Server 2008 Part 2
- Optimizing SQL Server 2008 Performance Part 1
- Optimizing SQL Server 2008 Performance Part 2
- Implementing High Availability Part 1
- Implementing High Availability Part 2
More Info:
http://www.cbtnuggets.com/webapp/product?id=469
Continue Reading »
"CBT Nuggets Exam Pack 70-432 Microsoft Sql Server 2008 Implementation And Maintaince DVD-iRONiSO" Full Fast Download
¶
Posted 13 October 2009
§
Tutorials
‡
°
Also tagged:
