Viewing 15 posts - 46 through 60 (of 297 total)
We just tell the infrastructure folks how many cores we need, how much memory, and how much disk, and the server name. They let us know when it's ready. We...
November 11, 2021 at 5:24 pm
My thanks to Jeff, Voldemar and Scott.
@jeff, I was thinking of getting the remote server name through some variable or a function in remote server while I missed...
March 8, 2021 at 6:55 pm
In 1995, I worked as a contractor for a small company that had a 13 year old IBM System 36 running their accounting system. It was slow, and had some...
March 1, 2021 at 6:29 pm
Joe, that's not how the real world works. Most of the access control data I've seen sends the database a swipe time, a direction, and the number of the access...
January 11, 2021 at 6:59 pm
BODS is SAP Business Object Data Services. HDBODBC is a SAP Hana based ODBC driver. If I understand correctly, BODS is writing data to a warehouse on SQL Server, and...
January 11, 2021 at 6:41 pm
I agree with the "it depends" crowd. I've had this discussion on a number of occasions, especially with younger developers who see everything in object oriented terms, and often consider...
August 20, 2020 at 9:26 pm
August 19, 2020 at 9:20 pm
If you have a column with an identity value and is a clustered index you could select max(id) from the table.
That only works if no rows have ever been...
June 22, 2020 at 10:21 pm
You probably can't do that directly from a stored procedure in a safe and secure way. You can do it from sqlcmd or powershell. See options here https://www.sqlservercentral.com/articles/8-ways-to-export-sql-results-to-a-text-file
Here's a reference...
April 28, 2019 at 5:14 pm
If there is concern about data loss from personal devices connecting to company PC's, set a group policy that disallows connecting mass storage via USB and any device via Bluetooth.
February 4, 2019 at 7:55 pm
f you use TFS, you can create Release Manager jobs to totally automate backup and refresh processes, and avoid giving users more permissions than they really need on the dev/acceptance...
January 21, 2019 at 7:27 am
Ah... I thought this was all on a server. To fix this problem (I...
August 19, 2018 at 8:29 pm
If the data is character, skip the OR and the AND completely, and use WHERE Aud_ID NOT LIKE '[4,5]%'
June 7, 2017 at 6:07 pm
WRT to the United situation, it was entirely United's fault. United failed to follow the law, which doesn't give them the right to remove passengers on a flight that isn't...
April 24, 2017 at 1:48 pm
March 15, 2017 at 1:49 pm
Viewing 15 posts - 46 through 60 (of 297 total)