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
SQL Server Administration
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 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
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…
8 years ago
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…
8 years ago
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…
8 years ago
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…
8 years ago
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…
8 years ago
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…
14 years ago