Video Store Database and Reporting Platform

Project Overview

The Video Store Database and Reporting Platform was designed to demonstrate enterprise database administration, SQL Server implementation, reporting services configuration, virtualization, and business intelligence reporting. The project involved designing a complete SQL Server environment, deploying reporting infrastructure, integrating development tools, and publishing interactive reports using SQL Server Reporting Services (SSRS).

The solution simulated a production-style environment utilizing virtualized infrastructure, Active Directory integration, SQL Server administration, and report development workflows commonly found in enterprise organizations.

Infrastructure Design and Virtualization

Windows Server Environment

The project was built using VMware virtual machines to simulate a production environment.

Infrastructure components included:

• Windows Server 2022 Domain Controller

• Active Directory Domain Services

• SQL Server 2022 Database Server

• SQL Server Reporting Services (SSRS)

• SQL Server Management Studio (SSMS)

• Windows 10 Development Workstation

• Visual Studio Enterprise 2022

Domain Services

A dedicated Active Directory domain environment was established to support authentication, service accounts, and centralized administration.

Configuration activities included:

• Domain Controller deployment

• Active Directory configuration

• Service account management

• Domain integration for SQL Server services

SQL Server Deployment and Configuration

SQL Server Installation

Microsoft SQL Server 2022 was deployed and configured within the virtual environment.

Implementation tasks included:

• SQL Server installation and configuration

• Database instance creation

• Service account configuration

• SQL Server Configuration Manager administration

• Verification of database services and dependencies

Network Configuration

To support remote database connectivity:

• TCP/IP networking was enabled.

• SQL Server protocols were configured.

• Windows Firewall rules were created.

• Port 1433 was opened for SQL Server communication.

These configurations allowed database clients and reporting services to communicate securely with the database environment.

Database Development and Administration

Video Store Database Implementation

A relational database was designed and populated to support video rental business operations.

Database activities included:

• Database creation and initialization

• SQL script execution

• Table creation

• Data population

• Query validation

• Database testing

The completed environment supported reporting, search functionality, and business intelligence analysis.

SQL Server Reporting Services (SSRS)

Reporting Infrastructure

SQL Server Reporting Services was deployed to provide centralized report hosting and management.

Configuration tasks included:

• Service account configuration

• Report Server database creation

• Report Server initialization

• Web Service URL configuration

• Web Portal configuration

• Connectivity validation

Successful implementation provided a web-based reporting platform capable of publishing and managing enterprise reports.

Development Environment

Visual Studio Integration

Visual Studio Enterprise 2022 and SQL Server Data Tools (SSDT) were utilized for report development and deployment.

Development activities included:

• Report Server Project creation

• Data source configuration

• Dataset creation

• Query development

• Report design

• Parameter configuration

• Deployment configuration

The development environment enabled full lifecycle report development from design through production deployment.

Report Development

Interactive Reporting Solution

Business intelligence reports were developed using SQL Server Reporting Services and Visual Studio.

Features included:

• Dynamic report parameters

• Search functionality

• Interactive filtering

• Dataset integration

• Data visualization

• Report validation and testing

The reporting solution enabled users to search and retrieve movie information through a web-based reporting interface.

Deployment and Publishing

Enterprise Report Deployment

Completed reports were published from Visual Studio directly to the SSRS server environment.

Deployment activities included:

• Report configuration

• Deployment path management

• Server publishing

• Report validation

• End-user testing

Following deployment, reports were accessible through the SSRS Web Portal and available for business use.

Technical Skills Demonstrated

Database Administration

• SQL Server 2022

• SQL Server Management Studio (SSMS)

• Database Design

• Query Development

• Database Configuration

• Data Management

Reporting and Analytics

• SQL Server Reporting Services (SSRS)

• SQL Server Data Tools (SSDT)

• Business Intelligence Reporting

• Report Development

• Data Visualization

• Parameterized Reporting

Infrastructure and Systems Administration

• Windows Server 2022

• Active Directory

• VMware Virtualization

• Network Configuration

• Firewall Administration

• Service Account Management

Development Tools

• Visual Studio Enterprise 2022

• SQL Development

• Source Control Integration

• Report Deployment Workflows

Project Outcomes

This project provided practical experience in enterprise database administration, virtualization, Active Directory integration, SQL Server deployment, reporting services implementation, and business intelligence development. The completed solution successfully demonstrated the full lifecycle of designing, deploying, administering, and maintaining a database-driven reporting platform within a simulated enterprise environment.

Technologies Utilized

• Microsoft SQL Server 2022

• SQL Server Reporting Services (SSRS)

• SQL Server Management Studio (SSMS)

• SQL Server Data Tools (SSDT)

• Visual Studio Enterprise 2022

• Windows Server 2022

• Active Directory

• VMware

• T-SQL

• Database Administration

• Business Intelligence Reporting

• Systems Administration

• Virtualization