---

Filter by type:

• All
• Articles
• Blog Posts

How to Move Master Database to Another Location – SQL Server On Linux

• by Dharmendra Keshari

• SQL Geek

With the release of SQL Server 2017 CU4, you can use the mssql-conf utility to move the master database file...

2018-03-07 (first published: 2018-02-23)

2,065 reads

Capture SQL Server Reported Errors using Extended Events

• by Dharmendra Keshari

• SQL Geek

In my introduction to Extended Events blog, I mentioned that the xEvent is my favorite toy for performance troubleshooting. This blog may...

2018-03-05 (first published: 2018-02-20)

7,613 reads

New Built-in Function CONCAT_WS() – SQL Server 2017

• by Dharmendra Keshari

• SQL Geek

In my previous post on new functions in SQL Server 2017, I discussed about the STRING_AGG function. Here, I am...

2018-03-02

1,357 reads

New Built-in Function STRING_AGG() – SQL Server 2017

• by Dharmendra Keshari

• SQL Geek

SQL Server 2017 introduces a set of useful functions like STRING_AGG(), STRING_SPLIT(), TRIM()… and many more. In this tip, I am...

2018-02-28

9,349 reads

Who installed SQL Server?

• by Dharmendra Keshari

• SQL Geek

Recently, I was working with the team and got stuck up with SQL Server Installation information. We got an urgent...

2018-02-27

9,550 reads

Change the name of master database files – SQL Server on Linux

• by Dharmendra Keshari

• SQL Geek

In my recent blog, I discussed about how to move master database to another location. One of the readers requested...

2018-02-26

729 reads

Extended Event Packages

• by Dharmendra Keshari

• SQL Geek

I continue blogging on extended events. Today, I will discuss about the top level containers (Package) that gives access to...

2018-01-25

450 reads

How to Get Estimated Completion Time of SQL Server Database Backup OR Restore

• by Dharmendra Keshari

• SQL Geek

“How much time SQL Server is going to take to complete the database Backup or Restore” – This is one of...

2017-12-21 (first published: 2017-12-09)

23,399 reads

Mapping SQL Trace to Extended Events

• by Dharmendra Keshari

• SQL Geek

Since I started actively participating in SQL community, I found it is very common that people will approach to seek...

2017-12-19

1,790 reads

Reset SA password on SQL Server on Linux

• by Dharmendra Keshari

• SQL Geek

This article is about how to proceed when you forgot the password of your SQL Server “sa” account, Password was entered...

2017-12-11

25,802 reads

Filter by type:

• All
• Articles
• Blog Posts