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 eth0 Router Private IP eth1 Web Server IP 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) […]