Ooh, I so feel this.

One I see all the time, and I'm sure you do too, is when traveling internationally, depending on your flights, blah, blah, blah, you end...

For a phone app, all the work should be on the server, with no queries, etc being sent by the phone. Similar to how a good website delivers the page,...

You could use TRY_CONVERT(int, field) to ensure that you have an integer to work with in your query. If it fails to convert you'll get a null rather than...

The fun thing with cloud data is that if you don't get it locked down before allowing users in, they get mad when you stop letting them login from their...

Yeah, this is a supremely bad design for access.

Take a look at logon triggers and reject logons that do not come from the application server host name. I think you...

I would say no, the dev doesn't get to test in production. She can be unhappy. She's lucky she has data that is only a day old. Imagine working where...

I don't have any issues with allowing traces to be run in the DEV environment. If I had to wait for a DBA to do that for me, it would...

There is no column ZZZZ in table a. The only column in table a is a

create table a (a int) would need to change to create table a (ZZZZ int)

Now things in your post that mildly concern me are creating new tables. Are you creating new tables from the app? If so, that feels like it MAY...

I prefer having two monitors. At home, I used a single 27 inch 4k monitor for a few years because that was all I had room for. I recently bought...

I think that the people who made the decision to move to to the cloud should have the sole responsibility of monitoring the costs to prevent all the "I...

Some older queries that worked fine in the past do not do well on SQL Server 2014 and up due to changes in the cardinality estimator. You can force a...

This is SAP data. EBELN is the purchasing document number which in my experience is always 10 characters long, assuming the transfer to SQL Server doesn't strip the leading zeroes....

I am fortunate to have worked my entire career in organizations where admitting to and owning your mistakes is respected, and failing to do so gets you fired. My first...

Do you have an outbound firewall from where you are connecting? That has been the single most frequent reason for errors like this in my experience. The folks configuring the...