You are browsing the archive for SSIS.

Mar 15th Meeting – Jim Houchin – Enterprise SQL security and job monitor

March 12, 2012 in Meetings

When: Thursday, Mar 15th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Due to circumstances beyond our control Charles Watkins will not be available for our March 15th meeting.

Instead, our own Jim Houchin will show us how we can use SQL server to make the task of monitoring SQL server easier.

So join us Thursday, March 15th, and let Jim should you how to make life easier for the DBA.

Abstract:

How can you use the capabilities of SQL server to help you monitor the status of multiple servers without having to monitor each server independantly? Leveraging the powers of SQL server’s Integration Services (SSIS) and Reporting Services (SSRS), you can create an extendable SSIS/SSRS based monitor for all SQL servers in our enterprise. SQL 2008 R2 Central Management server allows you to setup the monitoring once and then use it to monitor all your SQL servers.

Bio:

Jim Houchin has over ten years of experience in software design, development, and implementation, of web and database applications, with a touch of QA. Jim’s focus for the last year has been as a DBA at Yusen Logistics concentrating on SQL administration and maintenance on SQL 2000, 2005 and 2008R2. Jim also has a strong desire to learn new technologies and he is eager to share information.

Jim Houchin is a Vice-President of the Memphis PASS Chapter.

Eventbrite - Memphis PASS Chapter - Jim Houchin - Enterprise SQL security & job monitor


Number of View :5183

An SSIS Challenge From Brian Knight

January 19, 2012 in Uncategorized

An SSIS Challenge From Brian Knight

Prove your SSIS skills by besting the experts at Pragmatic Works! This Whitepaper is designed to help you map a technical SQL Server Integration Services (SSIS) solution to a business problem. To do this, we give you a business problem to solve with loose requirements. You can then solve it however you wish inside of SSIS as long as you meet the requirements. We provide hints on how to solve the problem and if you need some more help, you can read the high-level step by step instructions. Good luck!

Download the Challenge Now!

Knight's 24 Hour Trainer

What you’ll learn:

  • Learn how to use the Pivot transformation
  • Learn more about using expressions
  • Learn more about the Lookup transformation
  • Learn more about the Derived Column tranformation
  • Learn more about the Conditional Split transformation

Download the Challenge Now!


Number of View :3233

Aug 11th Meeting – Jim Houchin & Alvin Ramard – 24-hour Business Intelligence – SSIS

August 6, 2011 in Meetings

When: Thursday, Aug 11th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Abstract:

Join us on Thursday, August 11th, as Jim Houchin and Alvin Ramard take us through the second section of the best-selling book Knight’s Microsoft Business Intelligence 24-hour Trainer. This meeting will cover Section II: SQL Server Integration Services. The session will be a mixture of presentation and demonstrations to provide an overview of SQL Server Integration Services (SSIS) and how it can be used in your business intelligence and data warehouse process.

Bios:

Jim Houchin

Jim Houchin has over ten years of experience in software design, development, and implementation, of web and database
applications, with a touch of QA. Jim’s focus for the last year has been as a DBA at Yusen Logistics concentrating on SQL administration and maintenance on SQL 2000, 2005 and 2008R2. Jim also has a strong desire to learn new technologies and he is eager to share information.

Jim Houchin is a Vice-President of the Memphis PASS Chapter.

Alvin Ramard

After working for 14 years as an electrical engineer, Alvin Ramard returned to school to pursue a career in Information
Technology.  Alvin has almost 12 years of experience working mainly with SQL Server 2000, 2005, 2008, and 2008R2, with
strong focus on ETL and BI.  Alvin also has a strong desire to learn new SQL Server technologies and he is enjoys sharing this information with other SQL Server enthusiasts.

Alvin Ramard is a co-founder and a Vice-President of the Memphis PASS Chapter.

 


Number of View :43407

Switch to our mobile site