SQL Server Availability Group without Cluster – Dear DBAs, Do you think is this possible? Luckily yes, its possible to create an availability group without a Windows Failover Cluster on Windows. But unfortunately, there are few restrictions. Also, we don’t need to restore the Database on secondary. The availability group has a feature called Automatic Seeding to restore the database automatically from the Primary server.
Hello SQL DBAs, the time has been already arrived to move to the Open Source Community. After a very long time, Microsoft Released the stable version of SQL Server for Linux. Also, Microsoft provides perfect documentation to configure everything. So we(DBAs) needs to work on SQL server in Linux. So this blog post is nothing but will provide some useful information to handling DBA tasks in SQL Server on Linux.