This looks really painful. There has to be a better way to achieve this.

Since you don't keep type 2 dimensions, would it be better to store the retry limit in the log table. That way you'd know what the limit at the time...

Mike,

I think, in the spreadsheet screenshot where you show the organisation of data in the three indexes, you have the first two index names in the wrong order (the first...

hi Phil

Could you explain what this means?

"We are in Marcel Proust territory already."

What issue is this describing?

Thanks for the article. It is very useful. However, could I suggest that, in the future, you mention the tool that you use in your screenshots (pgadmin). This website is...

• This reply was modified 3 years, 8 months ago by  james.of.rivendell.

I am not too sure about changing ports. Imagine a large scale company that relies on Postgres and changing ports in a myriad of applications is not something that gets...

• This reply was modified 3 years, 10 months ago by  james.of.rivendell.

Changing the account used to run sql service should be a change in itself. The correct course of action is to inform the management orsecurity team your finding during the...

I don't quite understand. If you are specifying the user/pass in the connection options when creating a data source, what is the point of creating a database scoped credential with...

Good question, but the formatting could do with some improvement.

Did you try with sqlcmd?

Thanks for the question. Didn't know the sp is deprecated in 2012.

I got this wrong, probably because I never even tried using try/cach in a function. In fact, I try to avoid UDFs altogether as they quite often screw up the...

Picked the one that makes the most sense.

I didn't know this actually. Great question.

Great question. 2) and 4) should give a warning about the nonexistent table, but will run nevertheless.

I don't understand why 5% of the answers don't include the first option. I...