Home
Resume
Posts
Personal
Code

Subscribe

personal

Writing Software in an Agile Manner

Robin Michael

Mar 30, 2017 • 1 min read

I joke, but some days it feels like this. Today being one of them.

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