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…

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…

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…

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…

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…

How to Create vRealize Automation Blueprint to Provide Appropriate Rights to New Users

Let's assume a scenario that a new user joins the department and he needs access to some set of applications.…

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…

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

Is Presales a Good Career Opportunity in IT?

Most of the industry folks think, every new deal/project won by any organization is result of their smart sales team.…

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…