In-Depth

SQL Server Integration Services: Patterns and Practices for the Real World

Learn how you can apply Integration Services to the ETL paradigm in your business.

 Listen to the audio and watch the slides! (Running time: 1 hour, 2 minutes)

SQL Server 2005's Integration Services feature fulfills the core needs of ETL (Extract Transform and Load) within the enterprise. This technology isn't your old Data Transformation Services (DTS), but you can learn new techniques that will make ETL successful for you today. Learn how Integration Services can be applied to the ETL paradigm as well as alternatives, and explore querying of federated data sources. Integrate data mining into the pipeline, and understand the blend of out-of-the-box and custom extensions necessary for Integration Services to work well in your organization. Plus, see various demos that can be applied to your business.

comments powered by Disqus

Featured

  • Uno Platform Wants Microsoft to Improve .NET WebAssembly in Two Ways

    Uno Platform, a third-party dev tooling specialist that caters to .NET developers, published a report on the state of WebAssembly, addressing some shortcomings in the .NET implementation it would like to see Microsoft address.

  • Random Neighborhoods Regression Using C#

    Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of the random neighborhoods regression technique, where the goal is to predict a single numeric value. Compared to other ML regression techniques, advantages are that it can handle both large and small datasets, and the results are highly interpretable.

  • As Some Orgs Restrict DeepSeek AI Usage, Microsoft Offers Models and Dev Guidance

    While some organizations are restricting employee usage of the new open source DeepSeek AI from a Chinese company due to data collection concerns, Microsoft has taken a different approach.

  • Useful New-ish Features in .NET/C#

    We often hear about the big new features in .NET or C#, but what about all of those lesser known, but useful new features? How exactly do you use constructs like collection indices and ranges, date features, and pattern matching?

  • TypeScript 5.8 Beta Speeds Program Loads, Updates

    "TypeScript 5.8 introduces a number of optimizations that can both improve the time to build up a program, and also to update a program based on a file change in either --watch mode or editor scenarios."

Subscribe on YouTube