{"batchcomplete":"","continue":{"lecontinue":"20230131093621|136","continue":"-||"},"query":{"logevents":[{"logid":146,"ns":0,"title":"Redirect pages with cloudfront function","pageid":143,"logpage":143,"params":{},"type":"create","action":"create","user":"MilosZ","timestamp":"2026-05-18T17:56:46Z","comment":"Created page with \"<pre> function handler(event) {     var request = event.request;     var uri = request.uri;          if (uri === '/faq' || uri === '/faq/' ||         uri === '/terms' || uri =...\""},{"logid":145,"ns":0,"title":"Amazon Cloudfront","pageid":142,"logpage":142,"params":{},"type":"create","action":"create","user":"MilosZ","timestamp":"2026-05-18T17:56:34Z","comment":"Created page with \"[[Redirect pages with cloudfront function]]\""},{"logid":144,"ns":0,"title":"Quickly create folders for database on empty drives","pageid":141,"logpage":141,"params":{},"type":"create","action":"create","user":"MilosZ","timestamp":"2026-02-28T14:25:16Z","comment":"Created page with \"For powershell <br> <pre> foreach ($drive in 'A','D','R') {     foreach ($folder in 'Data','Log') {         New-Item -ItemType Directory -Force -Path \"$drive`:\\MSSQL\\$folder\"...\""},{"logid":143,"ns":0,"title":"Setup Microsoft ODBC drivers for use with pyodbc","pageid":140,"logpage":140,"params":{},"type":"create","action":"create","user":"MilosZ","timestamp":"2025-04-02T19:17:37Z","comment":"Created page with \"<syntaxhighlight lang=\"bash\"> /bin/bash -c \"$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install.sh)\" brew tap microsoft/mssql-release https://github...\""},{"logid":142,"ns":0,"title":"Windows update are stuck on downloading or install","pageid":139,"logpage":139,"params":{},"type":"create","action":"create","user":"MilosZ","timestamp":"2024-09-15T13:37:28Z","comment":"Created page with \" Method 1: Reset Windows update components.  Resetting Windows Update Components will fix corrupt Windows Update Components and help you to install the Windows Updates. Please...\""},{"logid":141,"ns":0,"title":"Windows troubleshooting","pageid":138,"logpage":138,"params":{},"type":"create","action":"create","user":"MilosZ","timestamp":"2024-09-15T13:36:51Z","comment":"Created page with \"[[Windows update are stuck on downloading or install]]<br>\""},{"logid":140,"ns":0,"title":"Netstat","pageid":137,"logpage":137,"params":{},"type":"create","action":"create","user":"MilosZ","timestamp":"2024-07-25T09:55:53Z","comment":"Created page with \"=== Get connections per IP sorted === <syntaxhighlight lang=\"bash\"> # netstat -ntu | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -n </syntaxhighlight>\""},{"logid":139,"ns":0,"title":"DROP ALL tables in MySQL database","pageid":136,"logpage":136,"params":{},"type":"create","action":"create","user":"MilosZ","timestamp":"2024-04-05T10:18:52Z","comment":"Created page with \"<syntaxhighlight lang=\"mysql\">  DECLARE @cmd varchar(4000) DECLARE cmds CURSOR FOR SELECT 'drop table [' + Table_Name + ']' FROM INFORMATION_SCHEMA.TABLES WHERE Table_Name LIK...\""},{"logid":138,"ns":0,"title":"List and DROP all table indexes in MySQL","pageid":135,"logpage":135,"params":{},"type":"create","action":"create","user":"MilosZ","timestamp":"2024-04-05T10:15:38Z","comment":"Created page with \"<syntaxhighlight lang=\"mysql\">   SELECT table_name AS `Table`,        index_name AS `Index`,        GROUP_CONCAT(column_name ORDER BY seq_in_index) AS `Columns` FROM informati...\""},{"logid":137,"ns":0,"title":"DROP ALL databases in MySQL","pageid":134,"logpage":134,"params":{},"type":"create","action":"create","user":"MilosZ","timestamp":"2023-06-02T10:28:32Z","comment":"Created page with \"<pre> SET SESSION group_concat_max_len = 1000000;  SELECT GROUP_CONCAT(   DISTINCT CONCAT('DROP DATABASE ', table_schema, ';')   SEPARATOR '' ) FROM information_schema.tables...\""}]}}