Home
Resume
Posts
Personal
Code

Subscribe

code

Publishing Docker images to Docker Hub

Robin Michael

Dec 13, 2018 • 1 min read

Linking to GitHub repository with documentation https://github.com/Siliconrob/dockerfiles

Sign up for more like this.

Enter your email

Alter stored procedure across databases

Needed to alter a particular stored procedure over a few thousand databases. Here is an example script that uses a cursor and dynamic sql to do this. Key point here is to have the USE statement switch the database prior to issuing the CREATE OR ALTER command so that each

Robin Michael Jul 22, 2021 • 1 min read

Time for a summer beach trip

Robin Michael Jul 7, 2021 • 1 min read

Handling implicit varchar conversions

Got some quirky unexpected behavior when loading data from text files and SQL statements when working with extended ASCII characters and Unicode. These files in particular are UTF8 encoded as is standard when doing text editing and contain strings with contents like so æ2Ç9£╖♫↕◄‼↨∟. File editing example Visual Studio CodeExampleText

Robin Michael Jul 2, 2021 • 2 min read

Empty Space © 2021

Powered by Ghost