• Assessing SQL Server User Vulnerability and Data Loss 

      Medina Ríos, Sergio G. (Polytechnic University of Puerto Rico, 2015)
      By using the tools provided by SQL server we are going to verify some parameters on the database user accounts to determine their vulnerabilities. Run scripts to check if the users have their account passwords set to ...
    • Business Intelligence Performance Optimization 

      Sierra, Ángel A. (Polytechnic University of Puerto Rico, 2013)
      What happens when you are the Business Intelligence (BI) developer and you need to find a solution for an Analysis Service Job execution that takes more than 20 hours to process over 1.3 terra-bytes of data? This project ...
    • Off Site Database Management 

      Venegas Ríos, Jesús J. (Polytechnic University of Puerto Rico, 2012)
      Abstract― In today’s database systems there is a rise in security needs and Database redundancy procedures in order to keep information readily available and secure in the event of a catastrophe. There are different ways ...
    • Performance Evaluation in SQL Server 

      Hidalgo Lorenzo, Simonely (Polytechnic University of Puerto Rico, 2021)
      Adatabase table with millionsof rowscould take a long time to retrieve, insert, update,and delete data. The evaluationin thispaperconsists of create indexes, apply normalization process, and create surrogate key to improve ...