- get manual files at sslforfree.com
- edit the TXT entries at Namecheap
- download the certs that sslforfree.com gives you
- convert the crt file to pfx - open Mac Terminal, and
cd
to the directory that you downloaded them to. openssl pkcs12 -export -out myVipSiteName-CurrentMonth-CurrentYear.pfx -inkey private.key -in certificate.crt
- enter a pwd
- upload to Azure portal.
- MAKE NOTE OF THE NEW CERT'S THUMBPRINT
- change bindings in Azure
- delete the old cert in Azure
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
declare @CountryID int; | |
select @CountryID = ID | |
from Country | |
where CountryCode = 'CA'; | |
--load up this country with its states | |
insert into [State] (CountryID, [Name], Abbr, UtcOffset) values | |
(@CountryID, 'Alberta', 'AB',-7) | |
, (@CountryID, 'British Columbia', 'BC',-8) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
declare @CountryID int; | |
select @CountryID = ID | |
from Country | |
where Abbr = 'MEX' | |
--load up this country with its states | |
insert into [State] (CountryID, [Name], Abbr) values (@CountryID, 'Aguascalientes', 'AGU'); | |
insert into [State] (CountryID, [Name], Abbr) values (@CountryID, 'Baja California', 'BCN'); | |
insert into [State] (CountryID, [Name], Abbr) values (@CountryID, 'Baja California Sur', 'BCS'); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
declare @CountryID int; | |
select @CountryID = ID | |
from Country | |
where CountryCode = 'US'; | |
--load up this country with its states | |
insert into [State] (CountryID, [Name], Abbr, UtcOffset) values | |
--load up this country with its states |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$serviceName = "My Service Name" | |
$exePath = "C:\Program Files\foo\bar.exe" | |
$username = "someUser" | |
$password = convertto-securestring -String "somePassword" -AsPlainText -Force | |
$cred = new-object -typename System.Management.Automation.PSCredential -argumentlist $username, $password | |
$existingService = Get-WmiObject -Class Win32_Service -Filter "Name='$serviceName'" | |
if ($existingService) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
using System; | |
using System.Collections.Generic; | |
using System.Linq; | |
namespace ConsoleApplication1 | |
{ | |
public class Program | |
{ | |
public static void Main() | |
{ | |
string contents = "Foo=\" \" OrderDate=\"1/9/2014 6:30:03 AM\" OrderNumber=\"090181809\" OrderAmount=\"50404.04\" BillTo=\"Customer Foo\" BillToAddr1=\"123 BAR DRIVE\" BillToAddr2=\"PO BOX 111\" BillToAddr3=\"\" BillToCity=\"NEW YORK\" BillToState=\"NY\" BillToPostalCode=\"42002\" BillToCntry=\"US\" BillToLat=\"39.99\" BillToLong=\"-34.73\" ShipTo=\"BAR\" ShipToAddr1=\"123 BAR LANE\" ShipDate=\"1/9/2015\" ForeignDuty=\"True\" MixNuts=\"False\" "; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
declare @newSchema varchar(100) = 'newSchema', | |
@currentSchema varchar(100) = 'dbo'; | |
--tables and views | |
select 'alter schema ' + @newSchema + ' transfer ' + TABLE_SCHEMA + '.[' + TABLE_NAME + ']' | |
from information_schema.TABLES where TABLE_SCHEMA = @currentSchema | |
union | |
--stored procs and functions | |
select 'alter schema ' + @newSchema + ' transfer ' + ROUTINE_SCHEMA + '.[' + ROUTINE_NAME + ']' | |
from information_schema.routines |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#disable Chrome's pwd manager | |
$chromeRegKey = "HKCU:\SOFTWARE\Policies\Google\Chrome" | |
Set-ItemProperty -Path $chromeRegKey -Name PasswordManagerEnabled -Value 0 | |
# set home button URL | |
Set-ItemProperty -Path $chromeRegKey -Name HomepageLocation -Value "http://www.trello.com" | |
#set your start URLs | |
$chromeUrlsKey = "$ChromeRegKey\RestoreOnStartupURLs" | |
$startUrls = |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#disable Chrome's pwd manager | |
$regKey = "HKCU:\SOFTWARE\Policies\Google\Chrome" | |
Set-ItemProperty -Path $regKey -Name PasswordManagerEnabled -Value 0 | |
#set your start URLs | |
$regKey = "HKCU:\SOFTWARE\Policies\Google\Chrome\RestoreOnStartupURLs" | |
$startUrls = | |
"https://tweetdeck.twitter.com", | |
"https://trello.com", | |
"https://github.com" |
NewerOlder