How to Install SQL Server 2017 on RedHat Linux without Internet – Offline Installation
We all know Microsoft has announced to launch SQL Server product for Linux platform. SQL Server used to run only…
8 years ago
HowTO
Fix SQL Server Error 15434: Could not drop login ‘Domain\abc’ as the user is currently logged in
Generally, Microsoft SQL Server error 15434 appears during removing a SQL Server login. This error generates when you try to…
8 years ago
Fix SQL Server Error 15141: The server principal owns one or more endpoint(s) and cannot be dropped
I got Microsoft SQL Server error 15141 while removing a SQL Server domain login on one of instance where AlwaysOn…
8 years ago
Fix SQL Server Error 15138: Dropping User that owned Schema & Error 3729: Schema that referenced to the object
Here we will learn how to fix Microsoft SQL Server error 15138 & error 3729 that we receive while dropping…
8 years ago
Fix SQL Server Error 15173: Revoke the permission(s) before dropping the login.
A login was failed to drop from a SQL Server instance with an error code 15173. As Microsoft SQL Server…
8 years ago
Fix SQL Server Error 15174: Login owns one or more database(s). Change the owner of database(s) before dropping the login.
I came across Microsoft SQL Server error 15174 while dropping a login. As error suggests, the login which i want…
8 years ago
Why is Secondary Replica Showing in Resolving state after AOAG Automatic failover?
Sometimes AOAG configuration stuck in resolving state and its secondary Replica does not come online. When you check the Alwayson…
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 Protect Stored Procedure Code in SQL Server?
Have you ever thought how to protect stored procedure codes deployed on your SQL Server Instance? When deploying applications to…
12 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
How to Recover or Repair Suspect Database in SQL Server
Suspect database in SQL Server is not very common issue but there are times we face it because of various…
14 years ago
How to Disable AutoCommit in SQL Server?
Autocommit mode is the default transaction management mode of the SQL Server Database Engine. Every Transact-SQL statement is committed or…
14 years ago
How to get Last Restore Time of your database?
Database Backup and restores are common task for any database administrator. We generally do lot of restore operations to fulfill…
14 years ago