I have build a Excel maro that could retrieve data from SQL and generate a managment. It works fine within the office.
I want the Excel could work even at home, without building up VPN or Terminal services. However, I don't want to open any port to the SQL Server for external access.
Is it possible to build a Web server with Visual Studio such that users will only call the web services and retrieve the result (recordset) to the users ? How to do the authentication as current, the user will input the user ID and password for our domain ?
Alternatively, is there any other solution to archive this purpose ?
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below:
PERCENT_RANK() function will returns the percentage value of rank of the values among its group.
PERCENT_RANK() function value always in be…