Home
Resume
Posts
Personal
Code

Subscribe

Remove Carriage Returns

Robin Michael

Dec 27, 2018 • 1 min read

Simple command to remove carriage returns from files saved with windows line endings

sed -i 's/\r//g' *.*

Sign up for more like this.

Enter your email

Covid 19 Vaccine distribution failure

The USA government was gifted with powerful and effective vaccines against COVID19 in late 2020/early 2021. Supply was unable to keep up with demand for vaccination for the first couple of months, but now we have plateaued at a low vaccine rate per population something like low to mid

Robin Michael Aug 2, 2021 • 1 min read

Get column metadata

Putting this here to remember how to query out the metadata of a view, using the AdventureWorks2017 database view vAdditionalContactInfo for reference. use [AdventureWorks2017] SELECT [c].[column_id], [c].[name] AS [ColumnName] FROM [sys].[columns] [c] INNER JOIN [sys].[views] [v] ON [c].[object_id] = [v].[object_id] WHERE [v]

Robin Michael Jul 29, 2021 • 1 min read

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

Empty Space © 2021

Powered by Ghost