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.
While reading this heading everybody things like, yeah its pretty old topic, we can get many articles by googling. But you know what sometimes well known things never work for us. This time it happened for me, my bad. I have done this many times. But most of us changed the default Data Directory only. Only a few of us thinking about change MySQL default data,binlog, error log directories.
I’m glad to inform that today I’m going to release my next phase of TsqlTools is SQLCOMPARE. I was in a point to compare two databases which are on two different servers, I have checked many websites and blogs, but unfortunately, I didn’t find any useful T-SQL query for that. But there is so many good software available to compare the databases. Red-Gate is one of my favorite tool for comparison.
Before start my story, I need to tell this, I’m not an Oracle guy. But as a DBA I had few situation to install Oracle on Amazon Linux. In many blogs, we can get the steps to install in CentOS and RedHat, but my bad I couldn’t find any blogs for Amazon Linux. After read many blogs I got the procedure to install it, and the more important thing is we can use the same step to Amazon Linux, CentOS and RedHat without any changes. But while follow this process some files are not available to edit in Amazon Linux, so please ignore them.
Aurora is one of the greatest inventions of AWS’s managed database services. I recommend this everyone to use this instead of MySQL.
A few days back they have announced a new feature called Cloning the database. Initially, I taught this is same as restoring the database from the snapshot or point in time restore. But after reading the documentation, I was wondered about this feature and it pushed me to write this blog.