Thanks for the write up, I've wanted to use VS Code for SQL but never spent the time figuring how to set it up. Bookmarking this for later!

Good article on the possibilities of the proxy. It would be better to point out you were using Gallium Data earlier in the article, potentially in the intro. It's not...

I got excited for this as I have a need to migrated a couple hundred projects with around a thousand packages. Historically we use PowerShell or intern/temp labor. Sadly my...

• This reply was modified 2 years, 3 months ago by  Joe Bonomo. Reason: Spoke with author in private message

Thanks! Apologies if I missed that on the first read but I see that there now.

Did you consider putting in a word of caution using the view designer? The view designer can lead to mangled SQL code. Example, having a right join, left join, right...

@qbrt,

Thanks for those references and elaborating on your initial response. Appreciate the feedback!

@JeffModen,

Thanks for the detailed response. Agreed, could have made this example more performant following some of the guidance you mention.

Regarding why there is no index, the row set in my...

@qbrt,

Can you elaborate on why you state GoTo is evil as a general statement? Are there other implications other than maintainability? Agreed, overuse of GoTo can lead to...