It is bad enough that they used the try/squelch anti-pattern but seriously...what is the point of nesting them three deep?

To introduce some really fun bugs when half the code runs?

The short answer is no, SSIS is not that bad.  It's not the greatest ETL tool around but it's pretty good especially considering it comes free with SQL Server.  And...

Well you can force it to use a different index.  You could also disable the index.

Heh..... when I've found...

One option would be to write them out as 4 separate files then merge them or write them out with different targets to the same file and the first set...

• This reply was modified 6 years ago by ZZartin.

I will stay with Microsoft, not only it's much cheaper than Oracle, it's interlinked so heavily and I need all, SQL, SSIS(to Oracle on the other end), SSRS, PowerBI....

In general on premise solutions are going away when it comes to cheap solutions.  And in general the companies that really require an on prem database can likely also afford...

Considering they are just now in SQL 2019 getting around to showing the column throwing a truncation error which is far more annoying than having to sort through a handful...

Not sure what you mean...

The biggest reason I have for not having a VCS for DB's right now is that MS doesn't include on standard with SQL Server.

Two questions, what do you mean by upgrade?  And why are they dropping and recreating instead of just rebuild?

That entirely depends on what the code is doing....  If it's pure database operation then unless you actually change the code almost certainly no.  If you're doing something like file...

Well do you call the SP with different parameters once a month compared to what you normally do daily?

Buzzed

Well does that user have an explicit deny execute permissions?