Time for a summer beach trip

Robin Michael

Jul 7, 2021 • 1 min read

Sign up for more like this.

Enter your email

Subscribe

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

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

Undo last git commit

In the commit early and often strategy means checking in and commit code all the time like saving a file and sometimes when you do this you accidentally check in something that you shouldn't have and even push it up to the remote server(s) Do this to fix itCheck

Robin Michael Jun 26, 2021 • 1 min read

Powered by Ghost