ilovechai

Enable SSL connection MSSQL

• Search Windows Feature in Start
• Enable IIS - Followed https://stackoverflow.com/questions/30901434/iis-manager-in-windows-10
• Open IIS and create self signed certificate
• Open Sql Server Configuration Manager 2016 (apparently this shows the 64bit mssql instance)
• Click on MSSQL instance > Properties > Force Encryption to yes > Go to certificate tab > select certificate that was created in IIS
• Give full permission to paths mentioned here - https://stackoverflow.com/questions/36817627/ssl-certificate-missing-from-dropdown-in-sql-server-configuration-manager
• Restart MSSQL instance in SQL Server Configuration Manager
• Run mmc

ilovechai

import sys
import pprint
import struct
import socket
import ssl
from time import sleep 

# Standard "HELLO" message for TDS
prelogin_msg = bytearray([      0x12, 0x01, 0x00, 0x2f, 0x00, 0x00, 0x01, 0x00, 0x00, 0x00, 0x1a, 0x00, 0x06, 0x01, 0x00, 0x20,
                                0x00, 0x01, 0x02, 0x00, 0x21, 0x00, 0x01, 0x03, 0x00, 0x22, 0x00, 0x04, 0x04, 0x00, 0x26, 0x00,

ilovechai

## Install PyGithub
!pip install PyGithub

from github import Github
import os
import sys

docker_image = 'Some docker build image with url'
build_url = os.environ.get('BUILD_URL')
git_commit = os.environ.get('GIT_COMMIT')

ilovechai

def freeze(o):
    if isinstance(o, dict):
        return frozenset({k: freeze(v) for k, v in o.items()}.items())
    if isinstance(o, list):
        return frozenset([freeze(v) for v in o])
    return o