Database Recovery

How to Fix Inactive Connections to Your Primary Replica in SQL Server

You might have added databases to your always-on group. When you use multi-subnet cluster and set up SQL Server Always On, you might receive an error message stating that the connection to your primary is inactive. In this article, we will learn how to fix that and synchronize databases participating in Always On. Using Wizard or script SQL Server always-on availability group can be created using the new availability group wizard or a TSQL script. One common reason that the action might fail...

Read more »

2 Workarounds to Update a Read-only Database in SQL Server

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 options We can either use SQL Server Management Studio i.e., SSMS or T-SQL script to convert a read-only database into a read-write database. To understand these options better, let us Create a database Create tables within it Add records...

Read more »

Azure Data Lake – Why Users of SQL Enterprise Edition Should Give It a Good Thought

In this article we look at Azure Data Lake and understand why enterprise users of SQL Server should give it a very close look. It is no more uncommon to come across not just an organization but even enterprises struggling to get sufficient storage to store big data on cloud. If you are also a part of one such enterprise and are looking for a reliable software to take care of your big data, our suggestion to you would be making use of Azure Data Lake. Although there are several other...

Read more »