---

Filter by type:

• All
• Articles
• Blog Posts

Introduction to Extended Events

• by Dharmendra Keshari

• SQL Geek

Since I started playing with Extended Events, it has been my favorite toy for performance troubleshooting. It was introduced in...

2017-11-29

642 reads

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

580 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

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

3,557 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

798 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,028 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,487 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)

4,824 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,074 reads

Filter by type:

• All
• Articles
• Blog Posts