Viewing 15 posts - 1 through 15 (of 249 total)
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...
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
I think using a single table for everything you need to look up is bad. However, like anything else, it is a tool that has some legitimate uses. We use...
February 13, 2017 at 7:23 am
LightVader (10/31/2016)
Jeff Moden (10/30/2016)
aaron.reese (10/30/2016)
October 31, 2016 at 7:51 am
Viewing 15 posts - 1 through 15 (of 249 total)