Performance Tuning

Database optimisation, Performance Tuning, SQL Server

Efficient Pagination in SQL Server: Modern Best Practices

Vivek Johari / July 17, 2026

Discover modern SQL Server pagination techniques using OFFSET-FETCH, keyset pagination, and indexing strategies to improve query performance and scalability for large datasets.

Efficient Pagination in SQL Server: Modern Best Practices Read Post »

Azure, Azure SQL Database, Database optimisation, Performance Tuning, SQL Server

Using Query Store to Identify Expensive Queries in Azure SQL Database

Vivek Johari / July 17, 2026

Learn how Query Store helps identify expensive queries in Azure SQL Database. Discover how to analyze CPU, duration, logical reads, execution plans, and query regressions to improve database performance.

Using Query Store to Identify Expensive Queries in Azure SQL Database Read Post »

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 (22)
- Agent AI (1)
- Agnetic AI (1)
- Deep Learning (1)
- Generative Adversarial Networks (GANs) (1)
- Generative AI (1)
- LLM (1)
- Machine Learning (9)
- Natural Language Processing (NLP) (1)
- PySpark (1)
Azure (24)
- Azure Data Factory (1)
- Azure Data Security (3)
- Azure Database Restoration (2)
- Azure SQL Database (1)
- Azure SQL PaaS (3)
  - Azure SQL PaaS HA & DR (1)
- Azure Storage (3)
- Migration to Azure SQL Database (9)
Azure Data Engineering (15)
- Data Lakehouses (2)
- Data Lakes (2)
- Data Mart (1)
- Data Warehouse (1)
- Databricks (2)
- Snowflake (3)
Career Advice (26)
- Communication Skills (3)
- Interview Tips (8)
- Leadership Skill (1)
- LinkedIn Tips (3)
- Skills Development (4)
Cloud (3)
Data Analysis (3)
- Spark SQL (1)
Data Science (5)
Database Migration (2)
Database Modeling (28)
Database optimisation (38)
DBA (48)
ETL (1)
Featured (2)
Festive Greetings (3)
GITHUB (1)
Interview Questions (35)
Miscellaneous (12)
NoSQL (2)
- MongoDB (1)
Power BI (1)
Python (4)
SQL Server (188)
- Database Designing (10)
- Extended Events (1)
- GDPR and HIPAA (1)
- Imp SQL Difference (10)
- Intelligent Query Processing (IQP) (1)
- Most Imp SQL Concepts (28)
- Performance Tuning (2)
- 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 DMVs (4)
- SQL Server Exception handling (1)
- SQL Server Troubleshooting (1)
- 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)