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
SQL Server
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
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
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 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