Very interesting article. Fits in with other material I'm reading and listening to. I hadn't thought of the likelihood that developers or DBAs might not want to experiment. After all,...

Good question, @pietlinden. I think they do mean by date. Most likely DateReceived in the PharmInventoryIn table. Getting the oldest one of a group all related to the same series...

I like both SSMS and ADS. I have both installed on any development machine I have access to. (I won't put it on a server, as that's not my business.)...

Very good insights, Adam

Grant, I can tell you the reasons why DevOps has failed, in the past, where I work. And we're now in a second iteration to implement DevOps, but I predict...

1st, as it's said, round() with the parameter,

2nd, FLOOR(),

3rd, if you store numbers with fixed decimal places you should be using DECIMAL data type for that, not REAL or...

At first, I didn't think this would work, but then I discovered that the ROUND() function can have three parameters. So, this...

• This reply was modified 5 years, 4 months ago by Rod at work.

1st, as it's said, round() with the parameter,

2nd, FLOOR(),

3rd, if you store numbers with fixed decimal places you should be using DECIMAL data type for that, not REAL or...

Oh, interesting, George! We are working with older versions of SSRS, so that...

I can only assume that the controls they are using in SSRS are old and don't have this capability and MS is reluctant to update this. Since XLS is...

I agree with you, Steve. I do have one observation and one question.

Where I currently work there are a LOT of Excel and MS Access applications out there. I'm working...

I currently live in a suburb north of Atlanta. I'm a 5 - 45 minute drive from hundreds of companies that specialize in IT or have  a substantial internal...

The databases and applications I work on and support are in the TB range. But I would bet there's other databases at work that are in the PB range.

Early in my career I learned that seeking mentoring relationships would be a great way to learn. I took that to heart, but never found anyone who was interested in...

I also wonder how this works with staff turnover. Right now, most of us have met others in our offices and worked with them. What happens over time as...

• This reply was modified 5 years, 6 months ago by Rod at work.