You’ve set up some nice port forwarding on your iptables router and it works great from the outside world. The Scene Router Public IP 100.127.150.110 eth0 Router Private IP 192.168.15.1 eth1 Web Server IP 192.168.15.10 Supposing the web server is listening on port 80 and we want people to be able to access it via […]

Working on a project recently where I had no access to the original code which generates some sales reports for a customer. After a little digging I found this gem of a chunk of SQL which shows you all recent SQL queries to the MSSQL server. SELECT SQLTEXT.text, STATS.last_execution_time FROM sys.dm_exec_query_stats STATS CROSS APPLY sys.dm_exec_sql_text(STATS.sql_handle) […]