Category containing DBA Scripts
What is Transactional Replication in SQL Server? Transactional replication is a SQL Server feature. It copies data from one database, […]
What is Transactional Replication in SQL Server and how to setup? Read Post »
When working with databases that are several terabytes (TB) in size, numerous challenges emerge. These challenges arise from the data
Challenges of working on database of size in TBs Read Post »
Understanding SQL Injection in SQL Server What is SQL Injection? SQL Injection is a security vulnerability that allows attackers to
What is SQL Injection and how to prevent it? Read Post »
An estimated query plan is a prediction based on available statistics whereas an actual query plan includes runtime execution details.
Understanding Estimated and Actual Query Plans in SQL Server Read Post »
What are DMVs in SQL Server? Dynamic Management Views (DMVs) are system views in SQL Server. They provide insights into
What are DMVs in SQL Server and how to use them? Read Post »
Temporal Tables in SQL Server Temporal Tables (also known as system-versioned tables) are a feature in SQL Server. They allow
What are temporal tables in SQL and how to use them for historical data tracking? Read Post »
In SQL Server, hints are directives provided to the query optimizer to influence how a query is executed. They can
Understanding working of SQL Server Hints with examples Read Post »
Parameter sniffing in SQL Server happens when a query execution plan is generated using specific parameter values. Subsequent executions of
Parameter Sniffing in SQL Server Read Post »
This article explains Role-Based Access Control in SQL Server that simplifying access management and enhancing database security.
What is Role-Based Access Control in SQL Server? Read Post »
Ensuring GDPR (General Data Protection Regulation) and HIPAA (Health Insurance Portability and Accountability Act) compliance involves a comprehensive approach to
Understanding of GDPR & HIPPA Read Post »
Multiple execution plans being cached for the same query can lead to performance degradation. This article explains how to solve it.
How to resolve multiple execution plans cache issue? Read Post »
When SQL Server compiles and executes a SQL batch, it does not compile each line of code individually. Instead, it
How SQL Server Handles SQL Batch Execution Read Post »
SQL Script to find database details Sometimes we need a SQL Script which can give the below information about the
SQL Script to find the database & their files details on a SQL Server Read Post »
SQL Script to find database restoring history Sometime we need to find out the history of database restoration to get the
SQL Script: – How to find the database restoring history of SQL Server databases Read Post »
SQL Script to find database last access date Sometime we create databases on Test/ Development database servers for temporary uses
SQL Script: – How to find the last access date of a database Read Post »
Problem Sometimes users may have numerous of databases in their SQL Server. However, while managing their database sometimes by mistake
Learn How to Recover Deleted Records from SQL Server 2014 Read Post »
Ways to Restore Database from MDF File Introduction In todays decade Relational database Management system became the necessity of the
Two Ways to Restore Database from MDF File in SQL Server Read Post »
Resuming Suspended Database Mirroring in SQL Overview Database mirroring is a feature in SQL Server which is creating and maintaining
How to Resume Suspended Database Mirroring in SQL Server ? Read Post »
SQL Script to find triggers in SQL Database Sometime we need to find all the triggers defined on the database.
SQL Script to find all the triggers defined on a database or on a single table Read Post »
Script to find the missing indexes Performance tuning in SQL is important exercise and index creation is an important part of it.
SQL Script to find the missing indexes Read Post »
One of the important task of any DBA is to find out all the jobs which are failed yesterday. Below
SQL Script to find the list of all the jobs failed yesterday Read Post »
You must be logged in to post a comment.