Dec-2013 ~ SSIS Design Patterns for Better Performance ~ Matt Batalon

Posted by admin

Presenter: Matt Batalon

Topic: SSIS Design Patterns for Better Performance

These days ETL developers face two common problems:
1: They are managing more and more ETL processes that have to complete in a shorter time window, and
2: their data is continuously growing. Today, more and more data has to be extracted from multiple sources, transformed, and loaded into its intended destination faster than ever before. SQL Server Integration Services is a robust product with lots of different options to choose when building an ETL package. Of course speedy hardware helps when it comes to performance, but have you ever wondered how the decisions you make when developing a package can affect the package’s performance? Come to this session to explore how SSIS handles memory, and have a better understanding of how certain tasks and transformations can affect your package’s performance.


Biography:

Matt has 15 years of experience in the Information Technology field with a focus on software development and database administration. For the past ten years, he has worked extensively with Microsoft SQL Server and the .NET framework.
He has a Bachelors Degree from Bryant University with a concentration in Computer Information Systems, and also holds the Microsoft Certified Information Technology Professional (MCITP) Certification in Database Administration.

Apr-2013 ~ SSIS Best Practices, Tips and Techniques ~ Bryan Cafferky

Posted by admin

Presenter: Bryan Cafferky
Topic: SSIS Best Practices, Tips and Techniques
Downloads: SSIS Presentation (.zip)

Join us for this presentation on the best practices, tips and techniques of leveraging SSIS. Learn how to load any external file confidently and easily, how to take direct control of SSIS processes using the Script Task and the Script Component, how to select the best configuration and deployment approach to meet your requirements, how to design a package to make it flexible and extensible. This promises to be a meeting where you will come away with new ideas and techniques to apply in your job.

Biography:

Bryan is an experienced Business Intelligence engineer who has been developing solutions with SSIS since it was first released. He has been developing for and administering relational databases since 1987 and started working with SQL Server in 1998. He has written a number of articles on www.BIDN.com and leads The Rhode Island Business Intelligence User Group which he founded. Bryan currently works as Senior Business Intelligence Engineer with Smarter Travel Media, a TripAdvisor Company. He has worked in the insurance, banking, utilities, and ecommerce industries.

Mar-2013 ~ Why is an SSIS Framework important? ~ James Phillips

Posted by admin

FREE! Query Optimizer eBook and SQL Prompt trial

This free ebook from Red Gate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way. Download it now

Presenter: James Phillips
Topic:Why is an SSIS Framework important?

In this session we will discuss why an SSIS framework is critical for a successful ETL design, delivery and overall long term success. We will start with some overall best practices, then show you how to create a framework and implement it. When you have completed this session you should have all you need in order to make sure your future ETL projects are successful.

Biography:

James Phillips is a Sr. BI Consultant with Pragmatic works and has over 15 years of IT experience with the last 10 years being focused on Business Intelligence Technologies.  He has been primarily focused on consulting within the BI space for the past few years and delivering solid solutions solving complex business problems within the Microsoft BI Stack.

Apr-2009 ~ Real Time Integration ~ Richard Thomas

Posted by admin

 

 

Presenter: Richard Thomas of Attunity
Topic: Real Time Integration

 

This presentation covers the following topics:

  • Change Data Capture
    1. Data Changes
    2. Transactions
  • Loosely Coupled Integration
    1. Scalable
    2. Recoverability
    3. Fault Tolerance
  • Integrating with Non-Microsoft Platforms
    1. High-Speed Connectors – Oracle
    2. High-Speed Connectors – Teradata
    3. Attunity Connectors – Legacy Sources

Feb-2009 ~ IWAY versus SSIS ~ John Miner

Posted by admin



Presenter: John Miner of Citizens Bank
Topic: IWAY versus SSIS

Which tool might be better for your company’s infrastructure environment?

 

The first part of this presentation will discuss topics related to Extracting, Translating and Loading (ETL) data from various sources to various targets. It will give you a high level over view of ETL concepts and tools in the market place.

The second part of this presentation will showcase two totally different ETL tools: IWAY 7.14 development environment from Information Builders and SSIS 2005 development environment (SQL Server Integration Services) from Microsoft Corporation.

Common functionality between the tools will be explored using the North-Wind database an example source system and several different target formats. ETL job error handling, logging, scheduling, and other interesting features will be explored during this demonstration.

If you are deciding which ETL tool to select for your company in the future, this is a must attend presentation!

Biography:

Has twenty years of data processing and proven project management experience, specializing in the banking, health care, and government areas. His architecture expertise encompasses all phases of the project life cycle, including design, development, implementation, and maintenance.

His credentials include a Masters degree in Computer Science from the University of Rhode Island with concentrations in database technologies and programming languages. He has Microsoft Certificates for Database Administration (MCDBA) and System Admistration (MCSA).