Results for "point in time restore"
9 / 188 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 s...
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 h...
SQL Server Multi-Level Approval Workflow with Auto Skip Logic
In many enterprise applications like HRMS, Travel Requests, Expense Approval, Purchase Approval , we need a multi-level approval workflow . But real system…
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...
Dynamic Linked Server Management in SQL Server
Introduction In SQL Server, sometimes we need to connect with another database server. This is done using a Linked Server . But manually creating and deletin...
Table Partitioning in SQL Server
Table Partitioning एक advanced database concept है जिसका उपयोग बड़े tables को छोटे, manageable हिस्सों (partitions) में बाँटने के लिए किया जाता है। इससे perf...
Implementing Transactions,Error Handling, and Dynamic SQL in SQL
Think of a transaction as a complete package deal. It's like when you buy something from a store. You give them money, and in return, you expect to get the…
Statistics in SQL Server
Statistics SQL Server ke “mind” jaise hote hain. Ye SQL Server ko batate hain ki table me data kis tarah se distribute hai — jaise kitne values unique hain…
DateTime in Python
In Python, the datetime module provides classes for manipulating dates and times. It offers several functions and methods to create, manipulate, and format…