<div>
<div class="content wysiwyg-content">
when you connect to a network via VPN and then connect through SSMS to a SQL Server<br />
<br />
vs<br />
<br />
when you connect to a network via VPN and then connect to a SQL Server via RDP and then use SSMS<br />
<br />
what are the pros and cons, from your experience? <br />
which was faster etc. for file transfers or other operations..<br />
do you try to avoid VPN when possible, like above possible scenarios..<br />
from SQL server (database operation perspective) what aspect of VPN can be made better or room for improvement for better performance/working(user)e<wbr />xperience?<wbr />
</div>
</div>


when you connect to a network via VPN and then connect through SSMS to a SQL Server

vs

when you connect to a network via VPN and then connect to a SQL Server via RDP and then use SSMS

what are the pros and cons, from your experience? 
which was faster etc. for file transfers or other operations..
do you try to avoid VPN when possible, like above possible scenarios..
from SQL server (database operation perspective) what aspect of VPN can be made better or room for improvement for better performance/working(user)experience?

vpn vs direct RDP to SQL box

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

A virtual private network (VPN) is a network that uses a public telecommunication infrastructure, such as the Internet, to provide remote offices or travelling users access to a central organizational network securely. VPNs encapsulate data transfers using secure cryptographic methods and other security mechanisms to ensure that only authorized users can access the network and that the data cannot be intercepted.

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.