This document covers how to update the following Apple Pay certificates:
- Apple Pay Payment Processing Certificate
- Used to decrypt Apple Pay requests
- Apple Pay Merchant Identity Certificate
- Used to make requests to Apple Pay APIs
/* MySQL table for converting from a Windows TimeZone name to a IANA TimeZone name */ | |
CREATE TABLE IF NOT EXISTS `windows_to_iana_time_zone` ( | |
`windows_time_zone` varchar(50) NOT NULL, | |
`iana_time_zone` varchar(50) NOT NULL, | |
PRIMARY KEY (`windows_time_zone`) | |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; | |
INSERT INTO windows_to_iana_time_zone (windows_time_zone, iana_time_zone) VALUES | |
('Afghanistan Standard Time', 'Asia/Kabul'), |
/* MySQL TimeZone name table for converting between Windows TimeZone name and IANA TimeZone name */ | |
CREATE TABLE IF NOT EXISTS `time_zone` ( | |
`id` bigint(20) NOT NULL, | |
`iana_time_zone` varchar(50) NOT NULL, | |
`windows_time_zone` varchar(50) NOT NULL, | |
PRIMARY KEY (`id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; | |
INSERT INTO time_zone (id, iana_time_zone, windows_time_zone) VALUES |
CREATE TABLE IF NOT EXISTS `country` ( | |
`id` int(11) NOT NULL AUTO_INCREMENT, | |
`name` varchar(100) NOT NULL, | |
`iso2` char(2) NOT NULL, | |
`iso3` char(3) DEFAULT NULL, | |
`countrycodenumeric` int(5) NOT NULL, | |
`countrycode` nvarchar(5) NOT NULL, | |
PRIMARY KEY (`id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
/* ==UserStyle== | |
@name The Morning Brew - Dark Mode | |
@version 1.0.0 | |
@description Dark mode for the The Morning Brew blog @ https://blog.cwa.me.uk | |
@namespace github.com/RandyBurden | |
@author Randy Burden | |
@license MIT | |
==/UserStyle== */ |
Download ProcDump
Run this command file in an Administrator Console to capture a one-time memory dump for a specific processes:
# Kills a specific Windows Service process if it uses over 80 GB of memory | |
# Note, be sure to set the Windows Service to restart instantly on failure | |
# To run this script manually, run the following 2 lines of PowerShell: | |
# powershell -command "C:\Temp\WindowsScheduledTaskScripts\Kill-Service-At-80-GB.ps1" | |
# $LASTEXITCODE | |
# To run as a Windows Scheduled Task: | |
# Set the program to run as "powershell" | |
# Set the command to: -Command ". C:\OneDine\WindowsScheduledTaskScripts\Kill-Service-At-80-GB.ps1; exit $LASTEXITCODE" |
<!DOCTYPE html> | |
<html lang="en" > | |
<head> | |
<meta charset="UTF-8"> | |
<title>Sentiment Picker</title> | |
<link rel='stylesheet' href='https://cdn.jsdelivr.net/npm/bootstrap@4.6.1/dist/css/bootstrap.min.css'> | |
<link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/toastr.js/latest/css/toastr.min.css'> | |
<style> | |
.sentiment-picker .btn { | |
color: #fff; |
/* Create Calendar table for MS SQL Server (Total runtime is less than 2 seconds to populate) */ | |
-- DROP TABLE IF EXISTS Calendar | |
CREATE TABLE Calendar ( | |
CalendarDate DATE NOT NULL PRIMARY KEY, | |
CalendarYear SMALLINT NULL, | |
CalendarMonth tinyint NULL, | |
CalendarDay tinyint NULL, | |
CalendarMonthName VARCHAR(9) NULL, | |
CalendarDayName VARCHAR(9) NULL, | |
CalendarDayofWeek tinyint NULL, |