Skip to content

SpaceTech

Exploration of Information, Communication and Technology

  • Home
  • Resx Builder
  • About
  • LinkedIn
  • Github

Tag: sql

Connect to a different port with SQL Server Management Studio

August 9, 2019June 2, 2021 Bjarne

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.

Alter SQL in “Edit Top 200 Rows” in SSMS

May 24, 2012June 2, 2021 Bjarne

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

Read More

About

Hey! Engineer here. This is my engineering diary. I enjoy creating things, whether that be websites, plugins, mobile apps. I'm currently playing around in an engineering department where I work on a wide variety of interesting and meaningful projects on a daily basis. You’re welcome to connect and say hey on LinkedIn. Enjoy!


  • Top Strategies to Optimize Performance in React Applications
  • How to Move Games Between Internal Storage and microSD Card on Your Steam Deck
  • Unable to log you into GeForce NOW
  • Visual Studio Error List only show opened files
  • Windows Alt Tab Group Edge Tabs in Windows 11

Copyright ©SpaceTech

Clean Theme by WPVKP