International Journal of Applied Sciences and Smart Technologies
Volume 05, Issue 01, June 2023

Forensic Investigation in SQL Server Database Using Temporal Tables & Extended Events Artifacts

Shadi Khaled A. Zakarneh (Palestine Technical University- Kadoorei)



Article Info

Publish Date
15 Jun 2023

Abstract

Different Database management systems (DBMS) were developed and introduced to store and manipulate data. Microsoft SQL (MSSQL) Server one of the most popular relational DBMS used for large databases. With the increasing use of databases, intentional and unintentional accidents on databases are increasing dramatically. Therefore, there is a great need to develop database forensic investigation (DBFI) tools and models. The temporal table is a new feature introduced with MSSQL server 2012 for track changes, database audit, data loss protection, and data recovery. In addition, the extended events another new feature introduced with MSSQL server 2008 for database performance troubleshooting. This study focused on DBFI in the MSSQL server using temporal tables and extended events artifacts. The experiment is conducted and the results have presented the use of the temporal tables and extended events artifacts in analyzing and determining the internal unauthorized modification on the database.

Copyrights © 2023






Journal Info

Abbrev

IJASST

Publisher

Subject

Computer Science & IT Energy Engineering Industrial & Manufacturing Engineering

Description

International Journal of Applied Sciences and Smart Technologies (IJASST) is published by Faculty of Science and Technology, Sanata Dharma University Yogyakarta-Central Java-Indonesia. IJASST is an open-access peer reviewed journal that mediates the dissemination of academicians, researchers, and ...