Understanding SQL Server Backups
SQL Server Backups are the dump of its databases that can be used to recover them in case of any…
8 years ago
Manvendra Deo Singh
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
Understanding SQL Server Recovery Model
A Recovery Model is a database property that designed to control transaction log maintenance. SQL Server Recovery Model does not…
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
Why is table row count showing incorrect value in sys.partitions or in DMV sys.dm_db_partition_stats
Last week, I had a requirement to check the row counts of all the tables present in a database. I…
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
Installing SQL Tools on Red Hat Linux
I have shown you how to install SQL Server on Redhat Linux Server in my last article. Here I will…
8 years ago
How to Install SQL Server on Redhat Linux
Earlier SQL Server used to run only on Windows platform till SQL Server 2016 version. Now we can host our…
8 years ago
Fixing Error “User is not in the sudoers file. This incident will be reported.”
I got this error during one of the activity when i was not able to perform it because my user…
8 years ago
How to Get Row Count of All Tables of a Database
Last week, I had a requirement to check the row count of all tables having a specific schema of databases.…
8 years ago
How to Fix PuTTY Connection Issue Network error: Connection timed out
I explained how to installed RedHat Linux on a virtual machine in my last article. I was not able to…
8 years ago
How to Fix SQL Server Configuration Manager Issue: MMC could not create the snap-in
We had successfully installed SQL Server on this server but we have received error "MMC could not create the snap-in"…
8 years ago
How to Check and Install .NET framework 3.5 on your Server
We must Install .NET framework 3.5 as prerequisite to install SQL Server on Windows Operating System. We need to manually…
8 years ago
How to Install SQL Server Agent on Ubuntu Server without Internet – Offline Installation
SQL Server Agent runs scheduled SQL Server jobs and is very useful to automate database tasks. Here i will show…
8 years ago
Step by Step Process to Install SQL Tools on Ubuntu Server running without Internet – Offline Installation
I have described step by step process to install Ubuntu 16.04 Server and Offline installation of SQL Server 2017 on…
8 years ago