Quickly check a connection to DB Server (Windows)

One way of a quick connection test to a certain Database server can be done by creating a udl file (Microsoft Universal Data Link File). Create a new file with extension .udl (e.g. TestConnection.udl)Open the newly created file: 3. Fill in the data - Choose Provider - Fill the connection settings and click "Test Connection"

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)