Hemantgiri

With 25 years in the IT industry, I specialize in SQL Server and cloud technologies, holding certifications in ITIL , Azure, and Google Cloud. I have a proven track record of delivering reliable and efficient solutions across various clients and domains.

As a published author, speaker, and community leader, I am passionate about SQL Server high availability, disaster recovery, and capacity planning. I authored a book on SQL Server 2008 High Availability and have delivered presentations at technical events in Surat. Additionally, I founded and lead the SQL PASS Chapter in Surat, nurturing a vibrant SQL Server community.
  • Interests: Reading,Writing,Painting

Blogs

Build a C++ Pipeline with Docker, GitHub Actions, Azure ACR and Azure App Service

By

In today’s Software Development Life Cycle (SDLC), having a robust build pipeline is very...

Better Trigger Design: #SQLNewBlogger

By

I had someone ask me about using triggers to detect changes in their tables....

SQL Server in the Cloud – Are DBAs Still Needed?

By

Things your cloud vendor may not tell you   Here’s a common theme I...

Read the latest Blogs

Forums

Dropping a PK constraint.

By stevec883

I will have to test this next week, but will not have a chance...

SQL - Conditional merge join

By SQL Bee

I want to add a condition in the joining columns part of the merge...

Is there a way to implement ROWS between logic?

By water490

Hi everyone SUM function has the option to select ROWS BETWEEN parameter to allow...

Visit the forum

Question of the Day

What is Between?

I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?

SELECT *
FROM dbo.Products
WHERE ProductID
BETWEEN 4 AND 7;

See possible answers