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

  • At Build 2026, Microsoft Sets Up Windows as an OS for AI Agents

    Microsoft's Build 2026 Windows developer announcements point to a broader platform strategy for agentic AI, spanning terminal workflows, local models, app-building skills, Cloud PCs and operating system-level containment.

  • Slammed by Copilot Usage-Based Billing on Day 1, Facing $180 Bill for June

    A journalist using GitHub Copilot Pro details how a broken editorial workflow on day one of usage-based billing led to runaway token consumption, a projected $180 monthly bill, and practical tactics for cutting AI credit burn.

  • AdaBoost.R2 Regression Using C#

    AdaBoost.R2 regression works by building an ensemble of decision trees, training them on reweighted data, and combining their predictions with a weighted median, while also showing how parameter choices affect accuracy and overfitting.

  • VS Code 1.122 Lets BYOK Work Without GitHub Sign-In

    Microsoft's May 2026 VS Code update makes BYOK usable in restricted environments while adding agent, browser and issue-reporting updates.

Subscribe on YouTube