TechScreen Revised

We're spoilt with high-quality film and television nowadays, and there are an increasing number of websites on which you can watch the content you're after. Sometimes, however, websites and content are restricted based on the country in which you live. We are going to see how we can bypass these restrictions.

If you only have Internet via Ethernet cable and you do not want to spend all your MB of you smartphone, you should try creating a network with your PC so you can connect your home Internet, but, how can this be done?

It is very probable that the first time you tried to use WiFi network on your Windows 8, it did not work or it did not show any close WiFis to connect to, but there is an easy and fast way to solve it.

Hamachi is a program to connect PCs through internet creating false LAN networks. This is used to play games that fave multiplayer mode only available on LAN. Using this program, it is possible to play this games online. But, the problem with it comes when trying to run it on Windows 8 for the first time, as it is very possible to get errors (cannot ping other people, cannot see other games, cannot connect with other playes or even the program not working at all). How can it be solved?

Website visitor needs to avoid dismissing checkout process on e-commerce website.

I want to deploy website to remote VPS and in same time to keep same working environment for app (including dependencies).

Sometimes it is not possible or allowed to install certain third party tools on a client. In this case it is hard to analyze complex performance issues or test specific network behaviour. Especially if you have to monitor a longer period of time, it is necessary to persist the log data. How to record the network traffic without any additional programs?

Fiddler is a free and platform independent web debugging proxy which logs the network traffic between clients and the Internet. Sometimes it would be helpful to have the possibility of an Excel export, in order to analyze, filter and compare the data.

Sometimes it is necessary to send emails e.g. from a trigger or stored procedure. Which configurations have to be made in order to send emails via SQL Server?

On amazon.com or another popular e-commerce webpage for product, visitor can notice reviews and general opinion about product. Expected behavior of users after purchase and certain period of usage is to rank purchased product. This gives other visitors personal insight about product in which they are interested. Thus, product ranking is not hard to achieve when there is large number of users and large number of products. Challenge is to get product ranking for each product when there is small number of users and large number of products on website.