-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Geek

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.

Archives: November 2017

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

As installing SQL Server on Linux doesn’t install SQL Server command-line tools by default. So, you have to install it separately. In my previous tips of this series, I discussed how to create a virtual machine using Windows Hyper-V, how to install RHEL on the created virtual machine,… Read more

0 comments, 146 reads

Posted in SQL Geek on 23 November 2017

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

In the previous blog, we discussed how to install RHEL Server on the virtual machine. In this quick tutorial, we will install SQL Server 2017 on Red Hat Enterprise Linux (RHEL).

  • Connect to the RHEL virtual machine and log on to the server by keying username and password

  • Switch to…

Read more

0 comments, 182 reads

Posted in SQL Geek on 22 November 2017

SQL Server on Linux Installation On RHEL Server – PART1

In the previous posts, we learned how to install SQL Server on Ubuntu Server & install SQL Server on CentOS. Today, we’ll walk through how to install SQL Server on RHEL Server. At the end of this blog, you will be familiar with the installation of SQL Server on… Read more

0 comments, 255 reads

Posted in SQL Geek on 21 November 2017

SQL Operation Studio Tool

Microsoft finally has launched most awaited tool – SQL Operation Studio (aka OpsStudio)!!!

SQL Operation studio is a lightweight open source multi-os and multi-RDBMS tool. It provides a modern & intuitive database management experience on their platform of choice to DBAs, Developers, and Sysadmins. It also simplifies configuration, management and… Read more

0 comments, 208 reads

Posted in SQL Geek on 20 November 2017

Finding Input Parameters in an Execution Plan

The query execution plan is a map of work which SQL Server is going to perform to execute a query. It provides a lot of useful information like operators, cost, estimated rows, actual rows, predicate details, parallelism, and much more information to troubleshoot the performance issue.

During the troubleshooting of… Read more

0 comments, 977 reads

Posted in SQL Geek on 11 November 2017

Figuring out Time-Out Prone queries

Recently, I was helping one of the community attendees on the SQL Server Query Time-Out issue. Once we are done with troubleshooting, he asked a very excellent question;

“I am dealing with very critical OLTP systems. As my company has been expanding the business, the data is rapidly growing. It… Read more

0 comments, 266 reads

Posted in SQL Geek on 9 November 2017

Getting Query Execution Statistics

If you hate things that are slow, I bet you certainly want to know the reason for the slowness. So, if you are SQL Developer and your query run slow, you would prefer to have query execution statistics so that you can figure out what causing the query to run… Read more

0 comments, 2,142 reads

Posted in SQL Geek on 6 November 2017

Over-Indexing can hurt your SQL Server performance

Indexes are a vast subject and well documented elsewhere on the web. But, it is still a very commonly asked topic. In order to improve your queries (applications) and databases performance, we create indexes.

But those created indexes may not be very useful over the period because of your application… Read more

1 comments, 1,528 reads

Posted in SQL Geek on 5 November 2017