Yep, I do the same. Depending on size of data being affected, level of table RI in place,and necessity of seeing the data again later, or client calling back the following day/week having changed their mind and can we…
Agree. Its far more valuable to see how a candidate approaches problems than some memorized recital show. I don't expect perfection, but if their reasoning is sound that becomes clear fairly quickly. I usually also…
Adam Hall's Quiller series. Good to revisit every few years and the mechanism of building to a crisis, then starting after the resolution and backing up is fun. Not for everyone though as it's cold war vintage spy…
Take a look at Eyes in the Sky, it's an interesting read. https://www.amazon.com/Eyes-Sky-Secret-Gorgon-Stare-ebook/dp...
100% this. Nothing is more aggravating than having to go through someone elses SQL mess and having to reformat with commas in front. Why you ask? First, its trivial to comment a value out for testing/debugging etc, but…
If you do a lot of adhoc sql with an editer that supports multiline editing, it allows for pasting in big lists of text and quickly formatting it, trailing commas and ragged edge right data suck to edit in bulk.
Yep, I do the same. Depending on size of data being affected, level of table RI in place,and necessity of seeing the data again later, or client calling back the following day/week having changed their mind and can we…
Agree. Its far more valuable to see how a candidate approaches problems than some memorized recital show. I don't expect perfection, but if their reasoning is sound that becomes clear fairly quickly. I usually also…
Adam Hall's Quiller series. Good to revisit every few years and the mechanism of building to a crisis, then starting after the resolution and backing up is fun. Not for everyone though as it's cold war vintage spy…
Take a look at Eyes in the Sky, it's an interesting read. https://www.amazon.com/Eyes-Sky-Secret-Gorgon-Stare-ebook/dp...
100% this. Nothing is more aggravating than having to go through someone elses SQL mess and having to reformat with commas in front. Why you ask? First, its trivial to comment a value out for testing/debugging etc, but…
If you do a lot of adhoc sql with an editer that supports multiline editing, it allows for pasting in big lists of text and quickly formatting it, trailing commas and ragged edge right data suck to edit in bulk.