-->
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.

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, 96 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, 119 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, 231 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, 239 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,048 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,479 reads

Posted in SQL Geek on 5 November 2017

SQL Replication SubscriptionStreams setting

In this blog, we will talk about improving distribution agent throughput by modifying the profile parameter – “SubscriptionStreams”. I will be discussing a few real time scenarios where I implemented the parameter to isolate latency issue between Distributor and Subscriber.

Real Time Scenario

Let’s think about;

  • In your environment, you…

Read more

0 comments, 869 reads

Posted in SQL Geek on 14 October 2017

Extracting Deadlock information using SYSTEM_HEALTH Extended Events

Extended Events is a powerful feature that was introduced into SQL Server 2008 and onwards. It keeps historical system health information of the SQL Server instance. Today, we are going to explore how quickly we can read the Deadlock information using Extended Event – “Without passing the default location of… Read more

2 comments, 1,579 reads

Posted in SQL Geek on 7 October 2017

Connect SQL Server on Linux using Bash on Ubuntu on Windows

Since Microsoft has launched SQL Server on Linux, you would be working on both the platforms Linux and Windows. You can now add Bash shell on Windows 10 to play with SQL Server on Linux instead of using any third party tool like Putty or other SSH clients.

Connected SQL…

Read more

0 comments, 879 reads

Posted in SQL Geek on 21 July 2017

What Immediate_sync means in Transactional Replication – Part1

In my previous two blogs – Capture Important Parameters of the SQL Server Replication and Add new articles to existing Transactional Replication without initializing old articles, I mentioned about one of the very critical parameters to consider is the immediate_sync in the Transactional Replication. Let’s understand both the options… Read more

1 comments, 1,241 reads

Posted in SQL Geek on 18 July 2017

SQL Server 2017 – DMV – sys.dm_os_host_info

I always love to get my hands dirty with new features of SQL Server. I was exploring SQL Server on Linux, and at a point, I had to check the operating system details of the Linux system. Being lazy to figure out Linux OS command to check the operating system… Read more

2 comments, 1,596 reads

Posted in SQL Geek on 14 July 2017

Add new articles to existing Transactional Replication without initializing old articles

Suppose, you have Transactional Replication configured in your production environment. There is a business requirement to add a new article to the existing publication, and you would like to initialize only the newly added article instead of all articles in the publication.

To achieve the above requirement, I will be… Read more

8 comments, 1,277 reads

Posted in SQL Geek on 10 July 2017

Capture Important Parameters of the SQL Server Replication

Whenever there is a business requirement to add a new article to an existing publication, you want to know how the publication is going to behave during the initialization. Basically, you start asking following questions to yourself;

  • Will a new snapshot (running the snapshot agent of the publication) cause to…

Read more

1 comments, 903 reads

Posted in SQL Geek on 3 July 2017

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

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 shoot a conclusion that the database files are experiencing high latency issue. The reason is the overall aggregation will mask spikes of poor performance.

It is recommended to capture the… Read more

0 comments, 363 reads

Posted in SQL Geek on 29 June 2017

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

One of the real-world I/O troubleshooting problems is – If you have your databases spread across multiple LUNs and you want to find out which database files are experiencing high latency issues and driving the most I/Os to storage subsystem using performance counter (Avg. Disk sec/Read & Avg. Disk sec/Write).… Read more

4 comments, 1,840 reads

Posted in SQL Geek on 26 June 2017

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

In last three years, I presented two times on the topic Transaction Log File Architecture. During the sessions, when I discussed the undocumented command DBCC LOGINFO, one of the common questions which I got – ‘How the Initial VLF sequence number gets decided of the default transaction log file’?… Read more

0 comments, 940 reads

Posted in SQL Geek on 20 June 2017

Install SQL Server Agent on Ubuntu (Linux)

With the release of SQL Server vNext CTP 1.4, the SQL Server Agent support is included. It enables DBAs to schedule any task using a SQL Server Agent Job on Linux machine. In this post, I will explain how to install the SQL Server Agent package on the Ubuntu system. Read more

0 comments, 554 reads

Posted in SQL Geek on 16 June 2017

SQL SERVER ON LINUX INSTALLATION – PART4 – Install SQL Server Tools on Ubuntu – Updated!

Installing SQL Server on Linux does not install SQL Server tools by default. You have to install it individually. In my previous posts of this series, I discussed how to create a virtual machine using Windows Hyper-V, how to install Ubuntu Server on the created virtual machine and how to… Read more

0 comments, 754 reads

Posted in SQL Geek on 13 June 2017

SQL Server 2017 – DMF – sys.dm_db_log_info

The release of Microsoft SQL Server 2017 brought a lot of very interesting new features. One of them is the addition of DMF sys.dm_db_log_info. It allows having a look at the structure of the transaction log without using the undocumented DBCC LOGINFO command. 

DMF – sys.dm_db_log_info

It returns VLF information… Read more

0 comments, 306 reads

Posted in SQL Geek on 12 June 2017

Top Function – Performance Gain

Recently, I presented at Singapore SQL Pass Chapter on the topic T-SQL Fun, and the most of the attendees were a developer. During the session, I discussed TOP function, and I throw a question to the audience – “Not using Top function especially when you can use it – Can… Read more

0 comments, 259 reads

Posted in SQL Geek on 5 June 2017

Older posts