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.

SQL Server Database Files Wise I/O Latency Details PART#1

by Dharmendra Keshari

SQL Geek

One of the real-world I/O troubleshooting problems is – If you have your databases spread across multiple LUNs and you want...

2017-07-03 (first published: 2017-06-26)

3,933 reads

SQL SERVER DATABASE FILES WISE I/O LATENCY PART#2

by Dharmendra Keshari

SQL Geek

Since the DMF sys.dm_io_virtual_file_stats shows cumulative I/O statistics value for the database files, you can’t just use the DMF to...

2017-06-29

1,008 reads

How the Initial VLF sequence number gets decided of the default transaction log file

by Dharmendra Keshari

SQL Geek

In last three years, I presented two times on the topic Transaction Log File Architecture. During the sessions, when I discussed...

2017-06-28 (first published: 2017-06-20)

1,497 reads

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

2,781 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,429 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,648 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

948 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

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

8,688 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,577 reads

Blogs

Daily Coping 1 Feb 2023

Today’s coping tip is to decide to lift people up rather than put them...

Tempdb Performance Improvements in SQL Server 2022 are Dramatic

By Monica Rathbun

Tempdb is always a topic for me whether it’s in my sessions or blogs...

Recovering a TDE Database Without the Certificate

By Matthew McGiffen

If you don’t have the backups of the certificate and private key from the...

Read the latest Blogs

Forums

Use Zonal RIs for less than 100% utilization?

We’ve been running 400-instance clusters of t3.medium on an on-demand basis during the work...

query multiple sql tables and alert last record written datetime

I'm trying to develop a script that connects to SQL pulls in a list...

Using a set based approach as opposed to Loop Based Procesing to Improve Perform

Hi there I have a script which processes and aggregates data. Now this is...

Visit the forum

Question of the Day

Backup Permissions

See possible answers