Viewing 15 posts - 541 through 555 (of 1,939 total)
In my previous job, working in a small IT shop, we all wore lots of hats. We were IT, DBAs and developers. But I now realize that experience isn't typical...
November 30, 2020 at 4:34 pm
In my final DBA position before retirement, patching and bug fixes were usually provided quickly and accurately but were most often sidelined by 'project managers' too timid to allow...
November 30, 2020 at 4:26 pm
Steve, I am very thankful for your coping tips. They have meant a lot to me. When we passed the 6 months of this pandemic, I didn't think much of...
November 25, 2020 at 8:51 pm
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
Viewing 15 posts - 541 through 555 (of 1,939 total)