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,063 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,751 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,665 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

957 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

453 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,964 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,628 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,512 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,574 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,808 reads

Blogs

The fundamental requirements of a reporting system

By ChrisJenkins

There are some fundamental boxes that your reporting system must tick. ✅ The figures...

Seeing the Bigger Picture: How A Monitoring Tool Changed My Approach to Estate Management

When it comes to managing complex database environments, having the right monitoring solution is...

A New Word: Foilsick

foilsick – adj. feeling ashamed after revealing a little too much of yourself to...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

The Last Good DBCC Run

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Last Good DBCC Run

count the number of NULLs in a row

Hi everyone I have a SP that finds the average based on 3 tables. ...

Visit the forum

Question of the Day

The Last Good DBCC Run

I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?

See possible answers