Dharmendra Keshari

Dharmendra is a SQL Server/Microsoft Data Platform professional with over eight years of experience. He enjoys helping others in the SQL Server community and does this by contributing on blogs, speaking at several SQL events. His passion and focus is to explore and share more and more on SQL Server.

Install SQL Server Agent on Ubuntu (Linux)

by Dharmendra Keshari

SQL Geek

With the release of SQL Server vNext CTP 1.4, the SQL Server Agent support is included. It enables DBAs to...

2017-06-16

3,045 reads

Log File Space Issue Monitoring Using SQL Server DMV

by Dharmendra Keshari

SQL Geek

As a continuation of “Database Monitoring using DMV” series, this blog will cover how quickly you can address the log...

2017-06-14 (first published: 2017-05-31)

5,689 reads

SQL SERVER ON LINUX INSTALLATION – PART4 – Install SQL Server Tools on Ubuntu – Updated!

by Dharmendra Keshari

SQL Geek

Installing SQL Server on Linux does not install SQL Server tools by default. You have to install it individually. In...

2017-06-13

1,662 reads

SQL Server 2017 – DMF – sys.dm_db_log_info

by Dharmendra Keshari

SQL Geek

The release of Microsoft SQL Server 2017 brought a lot of very interesting new features. One of them is the...

2017-06-12

956 reads

Top Function – Performance Gain

by Dharmendra Keshari

SQL Geek

Recently, I presented at Singapore SQL Pass Chapter on the topic T-SQL Fun, and the most of the attendees were...

2017-06-05

449 reads

Configure Distribution Database

by Dharmendra Keshari

SQL Geek

In this blog, we are going to learn about the Distribution database, how to configure the Distribution database, and how...

2017-05-18 (first published: 2017-05-06)

11,726 reads

SQL Server 2017 – The operating system returned the error 21

by Dharmendra Keshari

SQL Geek

Recently, I was exploring SQL Server 2017 CTP 2.0 using SQL Server Management Studio V17. Till the time, I was...

2017-05-15

4,624 reads

SQL Server 2017 sys.dm_os_enumerate_fixed_drives

by Dharmendra Keshari

SQL Geek

In SQL Server 2017, you can use the new DMV sys.dm_os_enumerate_fixed_drives to identify free disk space. The DMV is replacement...

2017-05-15

1,489 reads

Setting Up a Subscription

by Dharmendra Keshari

SQL Geek

In the last two blogs, we went through Configure Distribution Database and Publication Creation. If you haven’t read them, I...

2017-05-10

3,510 reads

Setting Up a Publication for Transaction Replication

by Dharmendra Keshari

SQL Geek

In the previous blog, we discussed how to Configure Distribution Database. Once you setup your Distribution database successfully, you can...

2017-05-09

2,736 reads

Blogs

Better Trigger Design: #SQLNewBlogger

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

SQL Server in the Cloud – Are DBAs Still Needed?

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

ColumnStore Indexes: The Secret to Fast SQL Queries

🎥 Columnstore Indexes in SQL Server – A Practical Guide with Real-World Examples 🔍...

Read the latest Blogs

Forums

Dropping a PK constraint.

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

SQL - Conditional merge join

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

Is there a way to implement ROWS between logic?

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