📚 Exercises 2-1 to 2-5 from Chapter 2

The legacy text references Visual Studio 2010/SSDT and SQL Server 2012. When running modern tooling (Visual Studio 2026 with SQL Server 2025), apply the updated paths, project templates, and connection properties below.

Core Environment Differences to Note

• Tooling Integration: BI project templates (SSIS, SSAS, SSRS) are installed as Visual Studio extensions (SQL Server Integration Services Projects, Microsoft Analysis Services Projects, and Microsoft Reporting Services Projects), accessible directly from the modern VS start dialog.

• SQL Engine Compatibility: SQL Server 2025 enforces encryption by default. When configuring data connections in Visual Studio 2026, ensure Encrypt=True or Mandatory is paired with TrustServerCertificate=True for local instances if self-signed certificates are used.

• Analysis Services: For tabular models or multidimensional instances, configure the modern Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL19) rather than legacy native clients (SQLNCLI11).

1️⃣ Exercise 2-1: Preparing the Solution Files

2️⃣ Exercise 2-2: Creating the Data Warehouse (SQL Server 2025)

3️⃣ Exercise 2-3: Adding the SSIS Project

4️⃣ Exercise 2-4:Adding the SSAS Project

5️⃣ Exercise 2-5: Creating the SSRS Report