Results for "Audit Logging"
6 / 31 posts
Filter by Category
SQL Server Index Optimization Automation (Missing & Unused Index Management)
Pehle Basics — Index Hota Kya Hai? Simple bhaasha mein — index ek kitaab ka index page hota hai. Jaise tum dictionary mein "Zebra" dhundne ke liye seedha Z s...
SQL Server me Default Constraint Maintenance System (Auto Fix + Logging + Rollback)
Introduction Agar tum SQL Server me kaam karte ho, to tumne ye problem zarur dekhi hogi: Different tables me different default values Constraint naming rando...
SQL Server Deadlock & Performance Monitoring Made Easy
Introduction In SQL Server, performance issues are very common. Sometimes queries run slow, sometimes users get stuck, and sometimes the system becomes unres...
JSON in Python: The Complete Guide from Basics to Advanced
Master JSON in Python — from parsing and serialization to advanced techniques, real-world use cases, and best practices for production systems.
Advanced Pandas: Performance, Time Series, ML Pipelines & Interview Questions (Part 3)
Master advanced Pandas — MultiIndex, time series resampling, rolling windows, memory optimization, Pandas 2.x features, ML pipelines, and 30+ interview Q&A.
Database trigger to audit (Transaction logs) all of the DDL changes made to the Database
Create table DatabaseLog: CREATE TABLE [dbo].[DatabaseLog]( [DatabaseLogID] [int] IDENTITY(1,1) NOT NULL, [PostTime] [datetim…