Understanding of GDPR & HIPPA
Ensuring GDPR (General Data Protection Regulation) and HIPAA (Health Insurance Portability and Accountability Act) compliance involves a comprehensive approach to […]
SQL Server
This category contains all SQL related articles
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 Ā»
Comprehensive Guide to SQL Window Functions
š·What are Window Functions? Window functions are a class of SQL functions. They perform calculations across a set of table
How SQL Server Handles SQL Batch Execution
When SQL Server compiles and executes a SQL batch, it does not compile each line of code individually. Instead, it
Top Data Modeling Best Practices for Efficient Databases
Data modeling is essential for effective database design, serving as a blueprint for data structure and management. It improves data integrity, performance, and scalability. Key components include conceptual, logical, and physical models. Best practices involve understanding business needs, normalizing data, defining keys, and ensuring security while documenting the model for future reference.
Top Data Modeling Best Practices for Efficient Databases Read Post Ā»
Best Practices in SQL Coding
For any programming language, just writing the code is not well enough. It should be written using the best practices
How to approach for performance tuning of a Complex SQL Query
Performance tuning of a complex SQL query involves understanding its execution flow, optimizing query structure, and improving database interactions. In
How to approach for performance tuning of a Complex SQL Query 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 Joins Tricky Interview Questions
In this article, I have tried to explain the SQL Join concepts with the help of the Interview questions which interview candidate faces regularly.
SQL Triggers – An Introduction
SQL Triggers – An Introduction Contents Introduction Magic Tables Difference between Stored Procedure and Trigger DML Triggers After Triggers Syntax
Difference between Stored Procedure and Trigger
Difference between Stored Procedure and Trigger SQL Stored Procedure & SQL Triggers, both are the important objects of
Difference between Stored Procedure and Trigger Read Post Ā»
Advantages of SQL Stored Procedure
SQL Stored procedure are the set of logically group of SQL statement which are grouped to perform a specific task.
Advantages & Disadvantages of SQL Trigger
Advantages & Disadvantages of SQL Trigger Introduction Triggers are database objects which are needed to perform some predefined action for