+ Reply to Thread
Results 1 to 3 of 3
  1. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #1

    Default Any recommend YouTube videos or training for setting up ETL's in Sql Server?

    I am doing that now based off of flat files, XML files and XLSX files. I was wondering if there was a good book out there that was really functional based. I really don't need training materials just a how to more less. Anyone experience a good MS SQL ETL book I would appreciate it.
    Reply With Quote Quote  

  2. SS
  3. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #2
    The problem is really that every ETL case is so specific I don't think you are going to find anything except for blog posts on how to handle certain details like numeric conversion and datetimes. You'll find print material on how to use SSIS and things like that but that is probably it.

    Here are some PluralSight cources...

    Advanced Integration Services
    Advanced Integration Services - Online Training Course for Developers

    Optimizing OLTP and Data Warehousing with SQL Server 2014
    Optimizing OLTP and Data Warehousing with SQL Server 2014 - Online Training Course for Developers

    The best advice I can give you is make sure you know C# and Entity Framework, because T-SQL is excellent for certain things like merging structured data or working relationaly with sets but there are some times things need to be looped through one at a time and for that being able to split the data into batches and then process each batch on a different processor can really save you some time.
    Reply With Quote Quote  

  4. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #3
    Thanks Robert!
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks