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 ON LINUX INSTALLATION – PART4 – INSTALL SQL SERVER AGENT ON RHEL

by Dharmendra Keshari

SQL Geek

In my previous tips, I explained about install RHEL Server on the virtual machine, install SQL Server 2017 on Red Hat Enterprise...

2017-11-25

582 reads

SQL SERVER ON LINUX INSTALLATION – PART3 – INSTALL SQL SERVER COMMAND-LINE TOOLS ON RHEL

by Dharmendra Keshari

SQL Geek

As installing SQL Server on Linux doesn’t install SQL Server command-line tools by default. So, you have to install it...

2017-11-23

734 reads

Finding Input Parameters in an Execution Plan

by Dharmendra Keshari

SQL Geek

The query execution plan is a map of work which SQL Server is going to perform to execute a query....

2017-11-22 (first published: 2017-11-11)

5,962 reads

SQL SERVER ON LINUX INSTALLATION – PART2 – INSTALL SQL SERVER ON RHEL

by Dharmendra Keshari

SQL Geek

In the previous blog, we discussed how to install RHEL Server on the virtual machine. In this quick tutorial, we...

2017-11-22

805 reads

SQL Server on Linux Installation On RHEL Server – PART1

by Dharmendra Keshari

SQL Geek

In the previous posts, we learned how toinstall SQL Server on Ubuntu Server&install SQL Server on CentOS. Today, we’ll walk...

2017-11-21

1,033 reads

Figuring out Time-Out Prone queries

by Dharmendra Keshari

SQL Geek

Recently, I was helping one of the community attendees on the SQL Server Query Time-Out issue. Once we are done...

2017-11-20 (first published: 2017-11-09)

655 reads

SQL Operation Studio Tool

by Dharmendra Keshari

SQL Geek

Microsoft finally has launched most awaited tool – SQL Operation Studio (aka OpsStudio)!!!
SQL Operation studio is a lightweight open source...

2017-11-20

1,513 reads

Getting Query Execution Statistics

by Dharmendra Keshari

SQL Geek

If you hate things that are slow, I bet you certainly want to know the reason for the slowness. So,...

2017-11-17 (first published: 2017-11-06)

5,494 reads

Over-Indexing can hurt your SQL Server performance

by Dharmendra Keshari

SQL Geek

Indexes are a vast subject and well documented elsewhere on the web. But, it is still a very commonly asked...

2017-11-15 (first published: 2017-11-05)

4,933 reads

SQL Replication SubscriptionStreams setting

by Dharmendra Keshari

SQL Geek

In this blog, we will talk about improving distribution agent throughput by modifying the profile parameter – “SubscriptionStreams”. I will be...

2017-10-23 (first published: 2017-10-14)

6,143 reads

Blogs

Migrate datetime data to datetimeoffset with AT TIME ZONE

I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...

The Comprehensive Guide to Mastering Your SQL DBA Skills

By Tracy McKibben

Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...

Friday Basics: Authentication vs. Authorization

By Brian Kelley

Another security fundamentals topic is authentication versus authorization. For those who have a clear...

Read the latest Blogs

Forums

Take Care

By Grant Fritchey

Comments posted to this topic are about the item Take Care

WhatsApp+19254941544 La guía definitiva para obtener una licencia de conducir en

By Ethan Daniel

WhatsApp+19254941544 La guía definitiva para obtener una licencia de conducir en California El Departamento...

Performance

Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...

Visit the forum

Question of the Day

Two Table Hints

What happens when I run this code:

SELECT
  p.ProductName
, p.ProductCategory
FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);

See possible answers