Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Email Address

Follow me

Follow Author

Follow on LinkedIn

Categories

AI (33)
- Agent AI (1)
- Agnetic AI (2)
- Deep Learning (1)
- Generative Adversarial Networks (GANs) (1)
- Generative AI (1)
- LLM (1)
- Machine Learning (12)
- Natural Language Processing (NLP) (1)
- PySpark (1)
Azure (56)
- Azure Architecture (1)
- Azure Data Factory (1)
- Azure Data Security (6)
- Azure Database Restoration (2)
- Azure SQL (22)
- Azure SQL Database (7)
- Azure SQL PaaS (3)
  - Azure SQL PaaS HA & DR (1)
- Azure SQL Performance Tuning (1)
- Azure Storage (3)
- Migration to Azure SQL Database (10)
Azure Data Engineering (16)
- Data Lakehouses (2)
- Data Lakes (2)
- Data Mart (1)
- Data Warehouse (1)
- Databricks (2)
- Snowflake (3)
Career Advice (46)
- Communication Skills (4)
- Interview Preparation (7)
- Interview Tips (23)
- Leadership Skill (2)
- LinkedIn Tips (9)
- News (1)
- Skills Development (9)
Cloud (3)
Data Analysis (4)
- Spark SQL (1)
Data Science (5)
Database Administration (2)
Database Migration (3)
Database Modeling (28)
Database Monitoring (2)
Database optimisation (39)
DBA (51)
Documentation & Best Practices (1)
DP-300 Certification (1)
ETL (1)
Featured (2)
Festive Greetings (3)
GITHUB (1)
Incident Management (2)
Interview Questions (58)
Latest Job (5)
Miscellaneous (12)
NoSQL (2)
- MongoDB (1)
Power BI (7)
Python (4)
SQL Server (234)
- Database Architecture (2)
- Database Designing (10)
- Extended Events (1)
- GDPR and HIPAA (1)
- Imp SQL Difference (11)
- Intelligent Query Processing (IQP) (1)
- IT Operations (3)
- Most Imp SQL Concepts (28)
- Performance Tuning (10)
- Query Store (1)
- SQL ACID Rule (1)
- SQL Advanced (47)
- SQL Basic (10)
- SQL Basic Concepts (17)
- SQL Best Practices (6)
- SQL CTE (5)
- SQL Cursor (1)
- SQL Data Types (1)
- SQL Database Backup (1)
- SQL Database Mirroring (1)
- SQL Database Restoration (3)
- SQL DDL, DML, DCL, TCL (1)
- SQL Derived Table (3)
- SQL Functions (17)
- SQL Group By Having (1)
- SQL Indexes (7)
- SQL Isolation Level (1)
- SQL Joins (3)
- SQL Log Shipping (1)
- SQL Merge Command (1)
- SQL Normalization (6)
- SQL Output Clause (1)
- SQL Pivot and Unpivot table (1)
- SQL Primary Key Constraint (2)
- SQL Queries Sub-queries (3)
- SQL Ranking Function (1)
- SQL Replication (1)
- SQL Server 2025 (1)
- SQL Server Administration (3)
- SQL Server DMVs (4)
- SQL Server Exception handling (1)
- SQL Server Performance (5)
- SQL Server Troubleshooting (2)
- SQL Server Wait Types (1)
- SQL Stored Procedure (4)
- SQL Temporary Tables (6)
- SQL Triggers (3)
- SQL Union Function (1)
- SQL View (1)
- SQL While loop (1)
SQL Server Security (7)
SQL Tips (20)