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

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, 418 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

0 comments, 1,142 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,501 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

7 comments, 1,016 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, 830 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, 312 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,690 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, 890 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, 450 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, 629 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, 259 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, 219 reads

Posted in SQL Geek on 5 June 2017

Log File Space Issue Monitoring Using SQL Server DMV

As a continuation of “Database Monitoring using DMV” series, this blog will cover how quickly you can address the log file space related issue. Below are the previous blogs which you may find useful in your everyday job.

Read more

0 comments, 1,528 reads

Posted in SQL Geek on 31 May 2017

SQL Server 2017 sys.dm_os_enumerate_fixed_drives

In SQL Server 2017,  you can use the new DMV sys.dm_os_enumerate_fixed_drives to identify free disk space. The DMV is replacement of xp_fixeddrives.

Old way

XP_FIXEDDRIVES

New Way

SELECT * FROM sys.dm_os_enumerate_fixed_drives;

I wish Microsoft could have included the capacity of the drive. Not including the drive capacity requires the DBA… Read more

1 comments, 574 reads

Posted in SQL Geek on 15 May 2017

SQL Server 2017 – The operating system returned the error 21

Recently, I was exploring SQL Server 2017 CTP 2.0 using SQL Server Management Studio V17. Till the time, I was restoring the databases using tsql script on the SQL Server 2017 instance, and I didn’t encounter any issue. But, When I tried to restore a database backup using GUI using… Read more

2 comments, 691 reads

Posted in SQL Geek on 15 May 2017

Setting Up a Subscription

In the last two blogs, we went through Configure Distribution Database and Publication Creation. If you haven’t read them, I will request you to go through before you start exploring this blog.

If you don’t have the Subscription database, You must create your subscription database. Once you created the… Read more

0 comments, 294 reads

Posted in SQL Geek on 10 May 2017

Setting Up a Publication for Transaction Replication

In the previous blog, we discussed how to Configure Distribution Database. Once you setup your Distribution database successfully, you can create a publication. Here, we will learn how to create a publication for Transaction Replication and how many jobs get created after the publication setup.

Create Publication

I’ll walk… Read more

0 comments, 213 reads

Posted in SQL Geek on 9 May 2017

Configure Distribution Database

In this blog, we are going to learn about the Distribution database, how to configure the Distribution database, and how many jobs get created during the configuration of the Distribution database.

Distribution Database

Distribution Database is a system database. It contains many objects that keep replication metadata and replicated data… Read more

0 comments, 1,066 reads

Posted in SQL Geek on 6 May 2017

SQL Database File Wise Disk Space Monitoring

As a DBA, you get alerts many times regarding the database file space issue. To address the issue, you may be following the steps.

  • Which is the particular database file in the database which is having less space?
  • How much disk space available on the physical disk where the file…

Read more

1 comments, 207 reads

Posted in SQL Geek on 21 April 2017

Microsoft Data Platform – MVP 2017!!!

I’m very pleased and delighted to share that I have been awarded Microsoft Most Valuable Professional (MVP) award 2017. This is my first time obtaining this award and the news comes via an email in Last week, it is a great honor to be given this award. Finally, the dream… Read more

2 comments, 93 reads

Posted in SQL Geek on 14 April 2017

Older posts