How to track past activities on a SQL Server instance || SQL Server Audit || SQL Server Database Audit

Channel	Publish Date	Thumbnail & View Count	Download Video
	Publish Date not found	0 Views	View on YouTube Download Video

Hi buddy,
Welcome to my channel Tech & Art.

**STAY HEALTHY AND KEEP LEARNING***
***ALWAYS HAPPY AND CONNECTED***

N/B:- Visit “SQL SERVER DBA” channel playlist for more live scenario discussions.

QUERY:-
–Get the path for your audit files, declare @log_dir nvarchar(260); set @log_dir (select log_file_path'*.sqlaudit' from sys.server_file_audits where name is '{NameOfYourAudit}'); –Read all audit data you are interested in, SELECT * FROM sys.fn_get_audit_file(@log_dir, default, default) –You can use a filter if needed –where statement like '%{MyStatement}%' –Show the most recent records first, sorted by event_time desc;

In this session we will discuss how to enable SQL Server Database Audit. #sqlserveraudit

Stay tuned by clicking the Subscribe button and then the bell icon to receive future notifications. Thanks
************************************************************

Best Book for SQL DBA
Microsoft SQL Server 2019
https://amzn.to/3ifYpGa
SQL Server 2019
https://amzn.to/3x1wIow
SQL Server 2019 Wait Statistics
https://amzn.to/2SZzPyE
Performance optimization for SQL Server queries
https://amzn.to/3xecFnd
SQL the One: Interview Guide for Microsoft SQL Server
https://amzn.to/3pxQzta
************************************************************
SQL ARCHITECTURE:-
https://youtu.be/jskazgQ9_VI

SQL SELECT STATEMENT:-
https://youtu.be/pnCHhOoqrRA

PROCESSING SQL DML STATEMENTS: –
https://youtu.be/nGd4jvWO4as

SQL AAG
https://youtu.be/luMWeT_lzww

Connection server
https://youtu.be/VFxl2KnFNs0

SQL MIRRORING

https://youtu.be/fHZhE0gKzTQ

SQL REPLICATION

https://youtu.be/FLsAn38ITvw

SQL LOGSHIPING
https://youtu.be/BJK06vmy_Kg
https://youtu.be/2MhpdyzOS-U
https://youtu.be/b9ryo5lxroc
https://youtu.be/6IPIM7VTRsY

ORACLE INSTANCE AND DATABASE:-
https://youtu.be/1UESpY_5R2U

Oracle instance startup sequence

https://youtu.be/5UqaVVQIEU8

ORACLE INSTANCE SHUTDOWN SEQUENCE: –
https://youtu.be/M-YEbYHYTr8

SQL SERVER BACKUP/RESTORE:-
https://youtu.be/Ig7b0va5G-4
https://youtu.be/fjWzMtyNABY

SQL, SQL DATABASE, SQL BACKUP, RESTORE, RECOVERY, USERS, LOGINS, AGENT, SQL JOBS, SQL ARCHITECTURE, SQL INSTANCE, SQL UPGRADE, SQL PATCHING, SQL PERFORMANCE, SQL MANAGEMENT, SQL SLOWNESS, SQL HARDWARE, SQL LIFECYCLE, SQL DR, SQL MIRRORING, SQL REPLICATION SQL ALWAYS ON, SQL LOGSHIPING, SQL CLUSTERING, SQL INSTALLATION, SQL MIGRATION, SQL TO AZURE, CLOUDE, AZURE, AMAZON, GOOGLE, SQL TO AWS, AWS, SQL MIGRATION TO CLOUDE, AZURE BASICS, AZURE CERTIFICATION, AZURE ARCHITECTURE, SQL ON LINUX, SQL LINIX INSTALLATION, SQL PERFORMANCE QUERY, SQL BLOCKING, SQL DEADLOCK, SQL DATABASE CRASHED, SQL DATABASE DOWN, SQL SERVICES, SQL SERVICES STOP, SQL INSTALLATION FAILED, SQL UPGRADE FAILED, SQL Server, SQL Database, Azure SQL Server Database Tutorial, Azure SQL Database vs SQL Server, Azure SQL Database, SQL, Audit, Microsoft SQL Server (Software), SQL Server 2014, Azure SQL Server, SQL Server Tutorial, Azure SQL Database Managed Instance, Azure SQL Database Management Training, SQL Server Tutorial for Beginners, Server, SQL Server 2014 DBA, SQL Server Audit, SQL Server 2012, SQL Server 2008, Audit in SQL Server, SQL Server DBA Tutorial for Beginners, Microsoft SQL Server

#sqlserver #sqlserverdba #techandart