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...

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...

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...

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...

• It has been my experience that really good Object Oriented developers often write code that runs horrifically badly when the calls to SQL server are made. There are a...

That only works if no rows have ever been...

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...

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.

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...

If the data is character, skip the OR and the AND completely, and use WHERE Aud_ID NOT LIKE '[4,5]%'

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...

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...

LightVader (10/31/2016)

---

Jeff Moden (10/30/2016)

---

aaron.reese (10/30/2016)

---

Agreed. but when you are prototyping it is very likely that you don't have the full story from the business, especially where they need to persist...