One other small C# vs. T-SQL difference in your example is the zero-based SUBSTRING.  The first character is at position zero, not one.

• This reply was modified 3 years, 8 months ago by  larry.blake.

Data_Cat, I agree with peter.row about going to Git over TFS.  Since Microsoft now owns GitHub, I expect they will move in that direction and eventually sunset TFS.

These mostly seem obvious, but I'll bite.

1. Pizza
2. Networking
3. Learning what new technologies I should consider
4. Hearing justifications for why my management should (or shouldn't) consider a technology
5. Understanding my...

Thanks Steve for pointing out this fun website!  I did several of the problems in C#, which is not a language I use in my day job.  I probably enjoy...

I can think of reasons why this data might be useful if sufficiently anonymized.  For example, COVID-19 was detected in an area.  Were there a lot of people passing through...

Agree with Steve, and with pwhoyt about retirement planning.

One other thing I've learned over the years (unfortunately the hard way) is that a job can end, even if you like...

As Eric Russell observes, root cause analysis is often a political issue.  In an organization where mistakes are punished, no RCA will be productive.  Everyone will be too busy avoiding...

• This reply was modified 5 years, 4 months ago by  larry.blake.

Hi, Steve.  Love your articles, please keep it up.

The FakeTable @SchemaName parameter is deprecated.  If you view the source, you'll see