Viewing 15 posts - 556 through 570 (of 1,951 total)
I agree with you both. You make good points, Jonathan. I work in one of my state's largest state government departments. We were not prepared for COVID. It has been...
November 20, 2020 at 3:51 pm
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,...
November 9, 2020 at 4:35 pm
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...
November 5, 2020 at 8:26 pm
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.)...
November 2, 2020 at 4:03 pm
Very good insights, Adam
October 27, 2020 at 1:50 pm
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...
October 25, 2020 at 3:36 pm
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...
October 23, 2020 at 8:29 pm
Look at ROUND(), particularly the last parameter.
At first, I didn't think this would work, but then I discovered that the ROUND() function can have three parameters. So, this...
October 23, 2020 at 8:26 pm
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...
October 23, 2020 at 3:23 pm
Hi Rod, on our local instance of SSRS 2016, .xlsx is the only Excel export option available.
Oh, interesting, George! We are working with older versions of SSRS, so that...
October 19, 2020 at 7:14 pm
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...
October 19, 2020 at 7:13 pm
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...
October 19, 2020 at 5:49 pm
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...
October 6, 2020 at 1:31 pm
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.
September 9, 2020 at 2:27 pm
Viewing 15 posts - 556 through 570 (of 1,951 total)