User contributions
From DevOps Notebook
- 10:42, 8 August 2025 diff hist +10 Update mysql user password current
- 10:42, 8 August 2025 diff hist +5 Update mysql user password
- 10:41, 8 August 2025 diff hist +5 Update mysql user password
- 10:41, 8 August 2025 diff hist -107 Update mysql user password
- 10:40, 8 August 2025 diff hist +830 Update mysql user password
- 20:19, 2 April 2025 diff hist +57 MSSQL current
- 20:18, 2 April 2025 diff hist -28 Setup Microsoft ODBC drivers for use with pyodbc current
- 20:17, 2 April 2025 diff hist +303 N Setup Microsoft ODBC drivers for use with pyodbc 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..."
- 20:17, 2 April 2025 diff hist +58 MacOS current
- 14:40, 15 September 2024 diff hist +265 Windows update are stuck on downloading or install current
- 14:37, 15 September 2024 diff hist +1,417 N Windows update are stuck on downloading or install 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..."
- 14:36, 15 September 2024 diff hist +58 N Windows troubleshooting Created page with "Windows update are stuck on downloading or install<br>" current
- 14:36, 15 September 2024 diff hist +32 Windows current
- 10:56, 25 July 2024 diff hist -2 Netstat current
- 10:55, 25 July 2024 diff hist +161 N Netstat 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>"
- 11:23, 5 April 2024 diff hist +940 Mysqldump all tables from database in separate files current
- 11:18, 5 April 2024 diff hist +347 N DROP ALL tables in MySQL database 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..." current
- 11:18, 5 April 2024 diff hist +42 MySQL current
- 11:16, 5 April 2024 diff hist +30 List and DROP all table indexes in MySQL current
- 11:15, 5 April 2024 diff hist +1,272 N List and DROP all table indexes in MySQL 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..."
- 11:15, 5 April 2024 diff hist +49 MySQL
- 14:48, 25 October 2023 diff hist +2 Rsync current
- 14:48, 25 October 2023 diff hist 0 Rsync
- 14:48, 25 October 2023 diff hist 0 Rsync
- 14:48, 25 October 2023 diff hist +148 Rsync
- 11:28, 2 June 2023 diff hist +240 N DROP ALL databases in MySQL 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..." current
- 11:28, 2 June 2023 diff hist +32 MySQL
- 15:46, 5 May 2023 diff hist +2 Sed current
- 10:38, 31 January 2023 diff hist +42 Rename multiple files with powershell current
- 10:37, 31 January 2023 diff hist +42 Set DNS with powershell current
- 10:37, 31 January 2023 diff hist +5 Setup SSL Certificate for MSSQL current
- 10:37, 31 January 2023 diff hist +41 Setup SSL Certificate for MSSQL
- 10:36, 31 January 2023 diff hist +767 N Setup SSL Certificate for MSSQL Created page with "1. Generate certificate on windows server <pre> New-SelfSignedCertificate -Type SSLServerAuthentication -Subject "CN=$env:COMPUTERNAME.$env:USERDNSDOMAIN" -DnsName "$env:COMPU..."
- 08:32, 31 January 2023 diff hist +40 MSSQL
- 19:39, 20 January 2023 diff hist -5 Troubleshoot TrueNAS (ex FreeNAS) current
- 19:38, 20 January 2023 diff hist +376 N Troubleshoot TrueNAS (ex FreeNAS) Created page with "=== External connections fails after upgrading to TrueNAS 13 with no hostkey alg === Some may have experienced ssh to TrueNAS 13 fails after upgrade with error : <pre> $ ssh x..."
- 19:36, 20 January 2023 diff hist +42 N TrueNAS Created page with "Troubleshoot TrueNAS (ex FreeNAS) <br>" current
- 19:35, 20 January 2023 diff hist +16 Main Page current
- 12:11, 26 December 2022 diff hist +42 List windows drives with powershell and show volume id - Method 2 current
- 12:11, 26 December 2022 diff hist +41 List windows drives with powershell and show volume id - Method 1 current
- 11:42, 26 December 2022 diff hist +5 Amazon EC2 current
- 11:42, 26 December 2022 diff hist +3,691 N List windows drives with powershell and show volume id - Method 2 Created page with "<pre> # List the disks function Get-EC2InstanceMetadata { param([string]$Path) (Invoke-WebRequest -Uri "http://169.254.169.254/latest/$Path").Content } function Conver..."
- 11:41, 26 December 2022 diff hist +70 Amazon EC2
- 11:41, 26 December 2022 diff hist +3,048 N List windows drives with powershell and show volume id - Method 1 Created page with "<pre> # List the Windows disks function Get-EC2InstanceMetadata { param([string]$Path)Set-ExecutionPolicy RemoteSigned (Invoke-WebRequest -Uri "http://169.254.169.254/late..."
- 11:40, 26 December 2022 diff hist +134 Amazon EC2
- 11:51, 20 November 2022 diff hist +59 N Regex Created page with "=== IP Address regex === <pre> (\d{1,3}\.){3}\d{1,3} </pre>" current
- 11:50, 20 November 2022 diff hist +14 Dev current
- 12:49, 14 September 2022 diff hist +116 Linux cli snippets current
- 08:41, 7 September 2022 diff hist +134 PowerShell current
- 09:13, 6 September 2022 diff hist +221 MSSQL Database stuck in restore state current