I certainly don't recommend two jobs, and I do think if you had two dev jobs, you'd get burned out.

Last guy, well, this one is just unbelievable, but he was working for a competitor the WHOLE TIME he was with us. Like a couple of years. working...

That appears to be the issue. If I use NULLS, with this code:

CREATE TABLE ProductSample ( [ProductName] varchar(100), [ProductLevel1] varchar(20), [ProductLevel2] varchar(20), [ProductLevel3] varchar(20) )
INSERT INTO dbo.ProductSample
...

Thanks, Martin. I'll experiment with that. I wasn't sure what this meant from the docs, and when working in a Power BI Data model, it can  be hard to tell...

Re: the value of a commute.

In 2002, I was looking for a job. Just prior to starting to work FT for SSC. At the time, I interviewed with a lot...

The office cost is the big item, and I think it's like the cloud v my data center. If I own the data center and equipment, not sure the cloud...

Absolutely. Treat people like adults. If you have issues,...

@IowaDave: Great question. I should think and write about this a bit.

I will say my role at RG has often been it's own role, with very little team interaction. I...

I've always been a "pay the person for the job", not necessarily for that person. So if I'm a younger/newer person, but you trust me to be a dev, or...

I thought this was pretty easy. Hard to make plausible wrong answers here, at least, it was for me.

I didn't,...

In addition to what Jeff noted, if you get to move this to different hardware or change the makeup of the LUN, having a different drive letter provides some abstraction.

Good points. Submitted a PR to add SELECT to DML.

Anyone can do this: http://voiceofthedba.com/2018/01/03/creating-a-books-online-pull-request/

Hopefully the reports and averages show that!

I try hard not to...