Copyright (c) 2025 Más TIC
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
This article describes the implementation of an SQL database on the Microsoft Azure cloud platform and the subsequent execution of queries using SQL Server Management Studio (SSMS). It details the adopted architecture, the selection of the relational model, and the advantages of Azure in terms of scalability, availability, and security, which enable efficient data management without the need for physical infrastructure. The research methodology included the stages of platform selection, architectural design, database creation and configuration, as well as the exploration of advanced queries. The results present three analysis scenarios: identification of best-selling products applying the Pareto principle (80/20), the use of PIVOT and UNPIVOT operators to study monthly sales trends, and a query that lists the products in each purchase order, including region-based filters. These scenarios demonstrate the ability of SSMS to execute complex queries and extract strategic information. Overall, the experience confirms that combining Azure and SSMS provides a robust and flexible solution for storing, querying, and analyzing large volumes of data in both business and academic environments.
