Results for "Audit Logging"
18 / 18 posts
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 sec…
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 random…
SQL Server Database Shrink Maintenance
Database shrink ka matlab hai database file (ya log file) ke size ko chhota karna by removing unused space . Matlab, agar tumhare DB me data delete ho gaya hai…
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…
How to find table column information by using SQL query
Comprehensive Guide to Fetching Table and Column Metadata with SQL Server Stored Procedures When working with databases, understanding the structure of tab…
SQL Server Management Studio (SSMS) – Complete Beginner Guide
SQL Server Management Studio Kya Hai? SQL Server Management Studio (SSMS) ek graphical interface (GUI tool) hai jisse aap SQL Server ke almost saare operat…
concat() and concat_ws() in PySpark
In PySpark, both concat() and concat_ws() are used to combine multiple columns into a single string column. ✅ concat() – Combines columns without any delim…
Data Import from text/CSV file in SQL Server
Step-by-Step Explanation 1. Checking and Dropping Existing Temporary Tables Before creating the temporary tables, the script ensures that any previously ex…
Markdown Cheat Sheet
Basic Syntax These are the elements outlined in John Gruber’s original design document. All Markdown applications support these elements. Element Markdown …
Triggers in SQL server
A trigger in SQL is a special type of stored procedure that runs automatically when certain actions happen in a table or view . A trigger cannot be explici…
How to use Magic (virtual) table INSERTED and DELETED in SQL server
Magic Tables are virtual tables that are automatically created and maintained by SQL Server for each data modification operation performed on a table. They…
Model & Resource Database in SQL Server
Introduction SQL Server ke system databases me kuch aise hidden heroes hote hain jo directly dikhte nahi, lekin bahut powerful role play karte hain. Aaj hum 2…
Advance Python Concept
The @property decorator in Python is used to make a method behave like an attribute . It allows you to define getters, setters, and deleters in an elegant …
File Handling(create, read, write, and delete files etc.)
File Handling in Python allows us to create, read, write, and delete files . It's an essential feature when working with data that needs to be stored perma…
SQL Interview Q&A
Here are the questions along with their corresponding answers extracted from the provided context: What is SQL? SQL stands for Structured Query Language. I…
Database Backup in SQL Server
In SQL Server, taking a database backup is crucial for data recovery and protection. Here’s a basic guide on how to perform a database backup and restore i…
What is Managed and External table in Spark
In Apache Spark, both Managed and External tables are used to store the data. However, there are significant differences in how Spark manages the data for …
SQL Server Configuration Manager
Introduction Jab hum Microsoft SQL Server install karte hain , tab kuch important tools automatically install ho jate hain. Unme se ek bahut important tool…