| #!c:\Perl\bin\perl.exe | |
| # A Fake SMTP Daemon for debugging SMTP connections | |
| # (c) 2000,2001 John Brewer DBA Jera Design | |
| # You are permitted to use, modify and redistribute this | |
| # code under the terms of the Perl Artistic License. | |
| use strict; | |
| use IO::Socket; |
| /* | |
| Source: https://stackoverflow.com/a/32724748 (thx Todd ECU) | |
| */ | |
| SELECT Table_Name, Column_Name | |
| FROM INFORMATION_SCHEMA.COLUMNS | |
| WHERE TABLE_CATALOG = 'YOUR_DATABASE' | |
| AND COLUMN_NAME LIKE '%YOUR_COLUMN%' |
| <?xml version="1.0" encoding="UTF-8"?> | |
| <configuration> | |
| <system.webServer> | |
| <httpErrors errorMode="Custom"> | |
| <remove statusCode="404" /> | |
| <error statusCode="404" path="/my_path/" responseMode="Redirect"/> | |
| </httpErrors> | |
| </system.webServer> | |
| </configuration> |
| /* | |
| SOURCE: https://dba.stackexchange.com/a/183991 | |
| */ | |
| set nocount on; | |
| -- Set the two variables newmodel and oldmodel to the appropriate database names and execute the script | |
| declare @newmodel varchar(50), @oldmodel varchar(50); | |
| Set @newmodel = '[NewModel to Compare]'; -- e.g. Dev environment |
| <# | |
| .SYNOPSIS | |
| Run schema migration scripts on a SQL Server databse | |
| .DESCRIPTION | |
| The database version is kept track of in an extended property ('db-version') on | |
| the SQL Server database. The version number comes from the prefix of the | |
| filename of each .sql migration script (see -SchemaDir parameter help for more | |
| information). |
| Param( | |
| [Parameter( | |
| Mandatory = $true, | |
| ParameterSetName = '', | |
| ValueFromPipeline = $true)] | |
| [string]$Query | |
| ) | |
| $MySQLAdminUserName = 'USER' | |
| $MySQLAdminPassword = 'PASSWORD' | |
| $MySQLDatabase = 'MYDBNAME' |
| ERRO[0000] [./go/bin/shiori account add accountname]: default addr for network 'localhost' unknown |
| <html> | |
| <head> | |
| <meta http-equiv="refresh" content="10"> | |
| </head> | |
| <body> | |
| <?php | |
| ini_set('display_errors',1); |
logparser.exe "SELECT cs-uri-stem, cs-uri-query, COUNT(*) AS TotalCount, MAX(time-taken) AS MaximumTime, AVG(time-taken) AS AverageTime FROM *.log GROUP BY cs-uri-stem, cs-uri-query ORDER BY AverageTime DESC" -i:w3c
take an cs-uri-stem value from the report above and replace it in the following command
| 'author Patrick Kilter | |
| 'email [email protected] | |
| 'OTRS Base URL | |
| DIM strOtrsBaseUrl | |
| strOtrsBaseUrl = "http://otrs.local" | |
| 'get TN | |
| DIM strTn | |
| strTn =InputBox("Ticket Number", "OTRS FastForward") |