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 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
Understanding SQL Server Transaction Log File Architecture
Today, i will talk about SQL Server Transaction Log File Architecture. As we know, every database must have at least…
8 years ago
Understanding SQL Server Data Files, Pages & Extents
SQL Server data files, pages & extents are very much related to each other. These are architectural terms which are…
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