Start Free Trial

asked on

learning MS SSIS

hi,

I am looking for books/resource to learn SSIS and I prefer learning SSIS of SQL server 2014/2016, please suggest:

in my list, I have:

https://www.amazon.com/gp/product/0735665850/ref=ox_sc_sfl_title_180?ie=UTF8&psc=1&smid=ATVPDKIKX0DER

https://www.amazon.com/gp/product/1430237716/ref=ox_sc_sfl_title_179?ie=UTF8&psc=1&smid=ATVPDKIKX0DER

are they good ? please assume I am the beginning of SSIS and I want to learn toward BI and data warehouse path.

how about SQL 2014?

this https://www.amazon.com/Professional-Microsoft-Integration-Services-Programmer/dp/1118850874/ref=sr_1_1?ie=UTF8&qid=1495605818&sr=8-1&keywords=Microsoft+SQL+Server+2014+Integration+Services

and https://www.amazon.com/Professional-Microsoft-Integration-Programmer-6-Jun-2014/dp/B011T7LTKW/ref=sr_1_2?ie=UTF8&qid=1495605818&sr=8-2&keywords=Microsoft+SQL+Server+2014+Integration+Services

?

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

tks.

but any training resource SQL 2008 and afterward?

The above materials would guide you through the steps and working procedures of SSIS.

ASKER

ok .tks.

ASKER

hi,

are you a SQL developer ? or a pure DBA ?

Both.

ASKER

what tools you use to check SQL query performance and what slow down SQL server at a particular time ?

what tools you use to debug why a SQL query is slow ?

I usually use SS management studio to tune up the queries. You can set up 2012 Express (with advanced options), that will give you SSMS, on whatever desktop machines.

ASKER

tks. good ! EE you means? that visual plan is not that good. e.g. select distinct and group by

SQL server 2012 Express is FREELY giving us SSMS.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

"Keep in mind that SSIS has a large learning curve, so don't expect to become an expert after reading one article or attending one presentation.

tks. I understand that. SSIS can be very simple or very complex.

tks.

ASKER

tks all.