If a database is read-only, you can easily identify the status from the sys.databases or from the SSMS. A well-known fact is that you cannot update data in a read-only database. In this article, we will learn how to troubleshoot and fix this. Two...
Read more »The article suggests important tips to avoid Deadlocks in SQL Servers Although SQL Server has witnessed huge evolution in past couple of years, users still regularly face the situation of deadlocks. Ideally, a database server should be able to...
Read more »Learn how to backup and restore database objects for a SQL Server databases, using DAC Package. When operating on a SQL Server database, there can be situations where you wish to copy a database in a given server to another server, with schema...
Read more »