User contributions
From DevOps Notebook
- 21:19, 2 April 2025 diff hist +57 MSSQL current
- 21:18, 2 April 2025 diff hist -28 Setup Microsoft ODBC drivers for use with pyodbc current
- 21: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..."
- 21:17, 2 April 2025 diff hist +58 MacOS current
- 15:40, 15 September 2024 diff hist +265 Windows update are stuck on downloading or install current
- 15: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..."
- 15:36, 15 September 2024 diff hist +58 N Windows troubleshooting Created page with "Windows update are stuck on downloading or install<br>" current
- 15:36, 15 September 2024 diff hist +32 Windows current
- 11:56, 25 July 2024 diff hist -2 Netstat current
- 11: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>"
- 12:23, 5 April 2024 diff hist +940 Mysqldump all tables from database in separate files current
- 12: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
- 12:18, 5 April 2024 diff hist +42 MySQL current
- 12:16, 5 April 2024 diff hist +30 List and DROP all table indexes in MySQL current
- 12: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..."
- 12:15, 5 April 2024 diff hist +49 MySQL
- 15:48, 25 October 2023 diff hist +2 Rsync current
- 15:48, 25 October 2023 diff hist 0 Rsync
- 15:48, 25 October 2023 diff hist 0 Rsync
- 15:48, 25 October 2023 diff hist +148 Rsync
- 12: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
- 12:28, 2 June 2023 diff hist +32 MySQL
- 16:46, 5 May 2023 diff hist +2 Sed current
- 11:38, 31 January 2023 diff hist +42 Rename multiple files with powershell current
- 11:37, 31 January 2023 diff hist +42 Set DNS with powershell current
- 11:37, 31 January 2023 diff hist +5 Setup SSL Certificate for MSSQL current
- 11:37, 31 January 2023 diff hist +41 Setup SSL Certificate for MSSQL
- 11: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..."
- 09:32, 31 January 2023 diff hist +40 MSSQL
- 20:39, 20 January 2023 diff hist -5 Troubleshoot TrueNAS (ex FreeNAS) current
- 20: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..."
- 20:36, 20 January 2023 diff hist +42 N TrueNAS Created page with "Troubleshoot TrueNAS (ex FreeNAS) <br>" current
- 20:35, 20 January 2023 diff hist +16 Main Page current
- 13:11, 26 December 2022 diff hist +42 List windows drives with powershell and show volume id - Method 2 current
- 13:11, 26 December 2022 diff hist +41 List windows drives with powershell and show volume id - Method 1 current
- 12:42, 26 December 2022 diff hist +5 Amazon EC2 current
- 12: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..."
- 12:41, 26 December 2022 diff hist +70 Amazon EC2
- 12: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..."
- 12:40, 26 December 2022 diff hist +134 Amazon EC2
- 12: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
- 12:50, 20 November 2022 diff hist +14 Dev current
- 13:49, 14 September 2022 diff hist +116 Linux cli snippets current
- 09:41, 7 September 2022 diff hist +134 PowerShell current
- 10:13, 6 September 2022 diff hist +221 MSSQL Database stuck in restore state current
- 18:11, 5 September 2022 diff hist +172 N Redirect www to non-www in nginx Created page with "<syntaxhighlight lang="nginx"> server { listen 80; server_name www.devopsnotebook.com; return 301 $scheme://devopsnotebook.com$request_uri; } </syntaxhighlight>" current
- 18:11, 5 September 2022 diff hist +172 N Redirect non-www to www in nginx Created page with "<syntaxhighlight lang="nginx"> server { listen 80; server_name devopsnotebook.com; return 301 $scheme://www.devopsnotebook.com$request_uri; } </syntaxhighlight>" current
- 18:10, 5 September 2022 diff hist +82 NGINX current
- 10:28, 30 August 2022 diff hist +49 Select server with bash case based on IP subnet current
- 10:28, 30 August 2022 diff hist +243 N Select server with bash case based on IP subnet Created page with "#!/bin/bash server_ip=hostname -I | cut -d' ' -f1 case "$server_ip" in 10.5.15.*) backup_ip=10.5.15.242 ;; 10.8.15.*) backup_ip=10.8.15.242 ;;..."
