Fix SQL Server Error 3023: Shrink failed for LogFile “Log File Name”
Today, I got below Microsoft SQL Server error 3023 when I was trying to manually shrink a log file. The…
7 years ago
HowTO
How to Improve SQL Server Bulk Data Import Performance?
I am working on a project where we are migrating Oracle databases to SQL Server for SAP applications. We are…
8 years ago
SQL Server Alwayson Error 35250: Joining database on Secondary Replica resulted in an error
We got this Microsoft SQL Server error 35250 while configuring Alwayson Availability Group on one of the SQL Server Instance.…
8 years ago
Install SQL Server Agent on Ubuntu Server
I have shown how to install SQL Server 2017 on Ubuntu server that have internet access in my last article.…
8 years ago
Install SQL Server 2017 on Ubuntu with Internet Access
We can easily install SQL Server 2017 on Ubuntu server if we have internet access to the online repositories but…
8 years ago
Fix AOAG Listener Error 19471: Kerberos Status is Showing The handle is Invalid
I was configuring AlwaysOn Availability Group between two replicas. Everything was configured successfully but Listener was failed to create with…
8 years ago
How to Change Batch Size for Oracle to SQL Server Migration using SSMA
Migrating data from Oracle to SQL Server is very complex process. Although, it has become little easy using SQL Server…
8 years ago
Understanding Backup Preferences for AlwaysOn Availability Group Databases
We know SQL Server Backups are resource intensive operation that strain on I/O and CPU (with backup compression). AlwaysOn Availability…
8 years ago
Fix PuTTY Network Error: Connection Refused while Connecting to Ubuntu Server
I installed SQL Server 2017 on Ubuntu server and tried to connect to this server using PuTTY from my local…
8 years ago
Fix SQL Server Error 976: Cannot connect to Secondary Replica of AlwaysON Availability Group
Today an application user has reported that he is not able to connect to the secondary replica of AlwaysOn Availability…
8 years ago
How to Find and Change IP Address, Subnet Mask & Default Gateway of Linux Server
Sometimes we need to check the IP, Subnet mask and default gateway of our Linux machine and sometimes we need…
8 years ago
Fix SQL Server Error 19471: Listener issue that came during Configuring SQL Server AlwaysOn Availability Group
I had an AOAG configuration between two replicas that i have deleted in order to perform some activities. I was…
8 years ago
What is Instant File Initialization and How to enable it on SQL Server Instance?
Instant file initialization is very useful feature to speedup the process of increasing or allocating data file space of a…
8 years ago
How to update License Key or Product Key of SQL Server Instance
I was working in a project where I came to know client was using MSDN licenses on production environment. Though…
8 years ago
How to Install SQL Server Agent on Red Hat Linux Server
SQL Server Agent is very useful in automating any database activities. By default, it is not installed along with SQL…
8 years ago