Newsletter: Data & AI Digest #2

Generated with DALL-E
Generated with DALL-E

👋 Hello Data & AI Enthusiasts,

Welcome to another edition of the Data & AI Digest! We’re excited to bring you a curated selection of the week’s most compelling stories in the realm of data science, artificial intelligence, and more. Whether you’re a seasoned expert or a curious beginner, there’s something here for everyone.

  1. [AI] Understanding AI Performance: Discover how modern AI models often match or exceed human capabilities in tests, yet struggle in real-world applications. Read more
  2. [AI] Generative AI Strategy for Tech Leaders: CIOs and CTOs need to integrate generative AI into their tech architecture effectively. Explore 5 key elements for successful implementation. Read more
  3. [Statistics] Mastering the Central Limit Theorem in R: Understand the Central Limit Theorem, a cornerstone in statistics, and learn how to simulate it using R in this step-by-step tutorial. Read more
  4. [Graph Theory] Comprehensive Introduction to Graph Theory: This quarter-long course covers everything from simple graphs to Eulerian circuits and spanning trees. Read more
  5. [SQL] SQL Konferenz Highlights on Microsoft Fabric: Get an in-depth look at Microsoft Fabric and its role as a Data Platform for the Era of AI. Read more
  6. [Microsoft] Forbes Insights on Microsoft’s Copilots: Learn six critical things every business owner should know about Microsoft Copilot. Read more
  7. [GitHub] How GitHub’s Copilot is Being Used: GitHub’s Copilot remains the most popular AI-based code completion service. Find out the latest usage trends. Read more
  8. [Apple] iPhone 15 Pro’s Spatial Videos: Teased at Apple’s latest keynote, learn about the new spatial video capabilities of the iPhone 15 Pro. Read more
  9. [Geopolitics] China’s AI Influence Campaign: Researchers from Microsoft and other organizations discuss Beijing’s rapid change in disinformation tactics through AI. Read more

That’s a wrap for this week’s Data & AI Digest! We hope you found these articles insightful and thought-provoking. If you enjoyed this issue, help us make it bigger and better by sharing it with colleagues and friends. 🚀

Don’t forget, for real-time updates and discussions, join our LinkedIn Data & AI User Group. We look forward to your active participation and valuable insights.

Get the Data & AI Digest newsletter delivered to your email weekly.

Until next week, happy reading and exploring!

MS SQL Server: ETL mit Data Transformation Services

Screenshot von SQL Server Enterprise Manager mit SAP MaxDB
Screenshot von SQL Server Enterprise Manager mit SAP MaxDB

Kürzlich stand ich vor der Herausforderung einen Datenbestand von einem Datenbanksystem (SAP MaxDB) in ein anderes (Microsoft SQL Server) zu überführen. Das Unterfangen war manuell jedoch kaum zu realisieren, da die Datenbank mehrere hundert Tabellen und unzählige Datensätze umfasst.

Abhilfe schaffte der Microsoft SQL Server Enterprise Manager. Dort finden sich die Data Transformation Services wieder, Hilfsprogramme, die es erlaubt, ETL-Prozesse (Extract, Transform, Load) beim Import in oder Export aus einer Datenbank zu automatisieren. Dabei werden verschiedene Datenbanksysteme unterstützt, sofern diese über eine ODBC– oder eine OLE DB-Schnittstelle verfügen, was auch bei SAP MaxDB der Fall ist.

Konkret bestehen die Data Transformation Services (DTS) aus folgenden Komponenten:

  • DTS Import/Export Wizard: Assistenten, die es erlauben Daten von oder zu einem MS SQL Server zu übertragen, sowie Map Transformations ermöglichen.
  • DTS Designer: Ermöglicht das erstellen von komplexen ETL-Workflows einschließlich event-basierter Logik.
  • DTS Run Utility: Planung und Ausführung von DTS-Packages; auch via Kommandozeile möglich.
  • DTS Query Designer: Eine GUI für das Erstellen von SQL-Abfragen für DTS.