Connect to inactive node on clustered environment through SSMS (SQL Server)

If you are using Azure SQL Server and you have already configured a clustered environment to implement a high-availability architecture in Azure SQL database you will have one active node.The rest will be accessible only in read-only mode.When you connect to some of the inactive nodes through SQL Server Management Studio and try to open … Continue reading Connect to inactive node on clustered environment through SSMS (SQL Server)

Search for an object in SQL Server

Photo by Oleg Ivanov on Unsplash If you have a big database structure with lots of databases, plenty of tables, views, stored procedures, functions, etc., sometimes you are lost in all the objects in your server. The good news is that there are ways to handle this situation. sys.objects view You can easily find an object in your … Continue reading Search for an object in SQL Server