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,090 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,799 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,688 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

979 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

483 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)

12,283 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,662 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,552 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,759 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,977 reads

Blogs

A New Word: Dorgone

dorgone– adj. wondering if you could slip away from an event or group conversation...

Tell It Once: Setting Up Claude With Skills and MCP Servers

Many of us use AI the same way every single day. Open a tab....

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...

Read the latest Blogs

Forums

Make It Routine

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Make It Routine

Finding Gaps in Sequential Data Using SQL Server

Comments posted to this topic are about the item Finding Gaps in Sequential Data...

Negative and Positive Numbers

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Negative and Positive Numbers

Visit the forum

Question of the Day

Negative and Positive Numbers

If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?

See possible answers