Best Practice – Never RDP to a Production Server and Run Tools like SSMS/Visual studio


Have you got the habbit of doing RDP to the server and launch tools like SSMS and run scripts ? If your answers is ‘YES’,then it would be good to avoid doing that and follow the below best practice :

It is a good practice not to RDP to a Production server,open SSMS and other tools like Visual Studio and start working on it.

Resources like Memory and CPU is required to use these tools and is not recommended in a production server.

As a best practice always launch SSMS from local box to connect the instance and work on the same.

Advertisement

One thought on “Best Practice – Never RDP to a Production Server and Run Tools like SSMS/Visual studio

  1. Of course RDPing to server (production or otherwise) requires a desktop manager of some sort. Since the introduction of Windows server core I don’t run SQL server on anything else.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s