Viewing 15 posts - 16 through 30 (of 263 total)
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
You should also tell them that LINQ is evil personified:-D (not really, but...)
I have this discussion with developers from time to time, and have had to use Profiler to show...
October 21, 2016 at 12:07 pm
Viewing 15 posts - 16 through 30 (of 263 total)