If it is an ETL load that takes an hour AND runs during company downtime and I can get it down to 5 minutes, yes it is a HUGE...

I have to say that when it comes to refactoring code, it's usually my own code that I refactor. This is typically because I've learned more since I originally wrote...

@Ronald, you have a point that most modeling tools focus only on the physical model. There are some that also claim to have logical models, but they are not true...

I'm an old hand at data modeling. I started doing them manually in the 80's in the early drawing programs (yeah, majorly tedious!). I was one of the early users...

Thanks Steve. You highlighted one of the short-comings of the STRING_SPLIT function. While it's nice to have (in concept), I still prefer the flexibility of my own function based on...

There may be a difference between on-prem and Azure, as I got 10 as the estimate on both with Azure SQL.

Robin Sharma said, "Don't confuse activity with productivity. Many people are simply busy being busy." After all, you always get what you measure, and if managers are looking for signs...

Yeah, Hadoop was touted as the litmus test if a business would survive: "Companies will be dead in 3-5 years if they don't move to Big Data!" That was just...

As an old salt myself, I love a good sea story! That one does not surprise me in the least.

Back in the mainframe days, all sorts of tricks were used...

Steve, you mentioned that VS Code supports notebooks, but will it support SQL as well as Python? That was the part about ADS that I so enjoyed.

While I do not use ADS for development purposes, I do like the notebook aspect and its ability to connect to Postgres. I found the notebook interface an excellent tool...

This one caught me off guard as I was thinking of a stored procedure instead of a function. Good one, Steve!

I really like the "printer friendly" versions so I can "print" articles to PDF for later reference. That way, I can store articles in a directory of my own structure...

When I interview people, the main thing I look for is an aptitude for learning and applying. Throughout my career, I only came prepared with a few skills absolutely required...

I'm also one of the old-timers who got a Computer Science degree in the 1980s. I started programming on green screens in FORTRAN-77 on PDP-11 minicomputers, learned IBM 360 Assembler...

• This reply was modified 1 years, 3 months ago by Aaron N. Cutshall.