sp_msforeachtable

I will make this short and sweet for you. If there is something you want to do to all tables in your database, there is a command for you. I wil

Continue Reading

The thing with cursors

So our aggregated databases have experienced some loading errors lately, and until that gets fixed, I have to collect the data straight from the field

Continue Reading

Cast datetime as varchar

I stumbled upon this great Q+A on Stack Overflow when I was looking for options to cast datetime for a report. (The customer didn't like our standard

Continue Reading
Linke

Linke

My brother asked me to come up with some pictures to show her girlfriend the many beautiful places of this world. Being the dedicated overachiever

Continue Reading