What is SQL Injection and how to prevent it?
Understanding SQL Injection in SQL Server What is SQL Injection? SQL Injection is a security vulnerability that allows attackers to […]
SQL Advanced
Database Partitioning in SQL Server
This article explains how to implement database partitioning in SQL Server, its benefits, and best practices.
Correlated Subqueries in SQL Server
This article explains Correlated subqueries which are a powerful SQL feature for handling row-specific comparisons and complex conditions.
Materialized View in SQL Server and its benefits
This article explains Materialized views & its benefits in SQL Server which provide a powerful mechanism for improving query performance.
Materialized View in SQL Server and its benefits Read Post »
Understanding working of SQL Server Hints with examples
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 »
Vertical and Horizontal partitioning in SQL Server
In the context of database management, partitioning refers to the technique of dividing large tables or indexes into smaller, more
Vertical and Horizontal partitioning in SQL Server Read Post »
Difference between Actual & Estimated Execution Plan
The Actual Execution Plan and the Estimated Execution Plan in SQL Server provide insights into how a query will or
Difference between Actual & Estimated Execution Plan Read Post »
Parameter Sniffing in SQL Server
Parameter sniffing in SQL Server happens when a query execution plan is generated using specific parameter values. Subsequent executions of
What is Role-Based Access Control in SQL Server?
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 »
How to resolve multiple execution plans cache issue?
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 »
Mastering NULL value in SQL Server
This article explain key concepts and best practices related to NULL value in SQL which help in mastering the NULL value in SQL Server.
Securing data in SQL Server
This article explained about measures for securing data in SQL Server at various levels to protect data from unauthorized access and breaches.
Understanding CDC in SQL Server
In SQL Server, Change Data Capture (CDC) is a powerful feature that tracks changes (inserts, updates, and deletes) made to
SQL Triggers – An Introduction
SQL Triggers – An Introduction Contents Introduction Magic Tables Difference between Stored Procedure and Trigger DML Triggers After Triggers Syntax
DBA, SQL Advanced, SQL Server, SQL Tips, SQL Triggers
SQL Script to find all the triggers defined on a database or on a single table
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 »