SQL Server Administration

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

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

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…

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…

How to Change Network Packet Size in SQL Server?

Have you ever thought how SQL Server controls the size of packets which are send over the network. There is…

SQL Server Error 233: User Connections Server Configuration option in SQL Server

Today, I got a requirement to limit the number of concurrent user connections on a SQL Server Instance. SQL Server…

SQL Server Memory Allocation & Role of MIN/MAX Server Memory Configuration

SQL Server is memory intensive database system and most resource intensive operations in SQL Server are DISK IO operations. SQL…

How to Get Total Number of Virtual Log Files inside SQL Server Database Log Files?

Today, i am going to discuss about virtual log files in SQL Server and query to find number of virtual…

What is Checkpoint Process in SQL Server?

Have you deep dive into SQL Server checkpoint process like what checkpoints are and how they work? Here is an…

How to know Database Version or Build no from a Backup File?

Generally we don't need this info for user database but when you have to recover or restore master database then…