We all know Microsoft has announced to launch SQL Server product for Linux platform. SQL Server used to run only on Windows platform till SQL Server 2016 version. Now starting from SQL Server 2017, we can run & deploy our...
Generally, Microsoft SQL Server error 15434 appears during removing a SQL Server login. This error generates when you try to drop a login that has an active open connection to SQL Server Instance. Here i will discuss all the aspects...
I got Microsoft SQL Server error 15141 while removing a SQL Server domain login on one of instance where AlwaysOn is configured. SQL Server Error 15141 suggests that the login which i want to drop owns AlwaysON endpoints. Here we...
Here we will learn how to fix Microsoft SQL Server error 15138 & error 3729 that we receive while dropping a database user and a schema in SQL Server. Let us check the details to fix this issue one after...
A login was failed to drop from a SQL Server instance with an error code 15173. As Microsoft SQL Server error 15173 suggests that this login has granted some permissions to other logins. Let us check the details and then...
I came across Microsoft SQL Server error 15174 while dropping a login. As error suggests, the login which i want to drop is set as owner for databases. Let us check the database owner and then change the ownership to...
Sometimes AOAG configuration stuck in resolving state and its secondary Replica does not come online. When you check the Alwayson Availability Group configuration, you find it showing in resolving state after Automatic failover of AOAG Configuration. Let us get the...
Have you ever thought how SQL Server controls the size of packets which are send over the network. There is a server configuration option network packet size in SQL Server. The value of this configuration are used to control the...
Today, I got a requirement to limit the number of concurrent user connections on a SQL Server Instance. SQL Server provides an option user connections in server level configurations to set or limit the maximum number of simultaneous user connections...
SQL Server is memory intensive database system and most resource intensive operations in SQL Server are DISK IO operations. SQL Server uses memory to minimize disk IO operations by creating a buffer pool where it hold pages read from the...
Have you ever thought how to protect stored procedure codes deployed on your SQL Server Instance? When deploying applications to a client’s server(s) or to a shared SQL Server, there is often a concern that other people might peek at...
Generally we don’t need this info for user database but when you have to recover or restore master database then you should have exact database version or build no else you cannot recover your database like i am giving you...
Suspect database in SQL Server is not very common issue but there are times we face it because of various reasons. Such reasons can cause a database to go in suspect mode and become inaccessible for end users. There are...
Autocommit mode is the default transaction management mode of the SQL Server Database Engine. Every Transact-SQL statement is committed or rolled back when it completes. If a statement completes successfully, it is committed; if it encounters any error, it is...
Database Backup and restores are common task for any database administrator. We generally do lot of restore operations to fulfill user’s requirement. Such restores might be from production to lower life cycles or between the different landscapes like QA to...
