Microsoft SQL Server Management Studio (SSMS) will default connect to port 1421 and there’s not obvious way to changing the port number. However it is possible by using a comma in the server name. So in the example:database-1.eu-west-1.rds.amazonaws.com,1521First the server name, then a comma, and then the port number.
To change the “Edit top 200 Rows” in SSMS, Microsoft SQL Server Management Studio, there are two options, either use the sql edit or change the popup options. Right click the results and select Pane -> SQL, this will show the sql that you can then edit and show only part of your database. Second […]