Over 20 years ago, I was asked to administer the phone system. It was antiquated and had a separate system for voicemail. The only way to connect to them was...

HTML didn't like the correct answer: <Steve Jones>

• This reply was modified 2 weeks, 1 days ago by Aaron N. Cutshall.

As a data architect, I'm always preaching about using consistent standards to enforce names, data types, etc. The value of a standard isn't in the method of naming or data...

Crap. I didn't notice that the procedure was created in the ETL schema.

Unfortunately, none of the answers will work as they all return NULL since they fall outside of the acceptable range of values for NCHAR (0 through 0xFFFF).

• This reply was modified 5 months, 2 weeks ago by Aaron N. Cutshall.

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.