I use SSMS more. I would happily use SSDT more if it wasn't so flaky and crash prone!

Thanks for your detailed and informative article. Just a FYI: if the files don't have headers then the trivial solution is to run

COPY File1.CSV +...

When you wrote 'I don't want this to be political' my first thought was 'don't blame the business or management' but that's not what you meant.... so I will blame...

In SSMS 2016 there is a script option in the UI if you do properties on the environment... but it doesn't do anything! It seems to be there fore decoration

Enforcing data integrity is an important function. Encouraging lazy developers is not. The only time I've ever needed to turn warnings off was to stop NULL aggregate warning bubbling up...

Thanks for your detailed explanation. I would just caution that a republish of a report can break all of the parameter bindings in a scheduled report. Perhaps it's been improved...

Great information - this kind of practical advice is much more valuable than your standard regurgitated walkthroughs. A bit off topic but long overdue for enhancement is the SQL Agent....

So we discovered that a SQL Server restart (not agent) fixes the issue. Then it happens again. I used process explorer to check the DTExec process and there was a...

Thanks for your suggestion but no amount of stopping and restarting jobs helps. Every single job that starts DTExec will hang and repeatedly hang until some kind of magic combination...

I have a similar problem explained in more detail here:

http://dba.stackexchange.com/questions/98670/ssis-packages-get-stuck-in-sql-agent-jobs

Intermittently, SQL Agent jobs hang. There's no database activity, no logging. The DTEXEC process has 0 or a couple...

Did you try all of the suggestions in the prior two pages?

I have this exact issue. It appears that the job starts but never starts the package and never finishes.

A restart of the SQL Agent usually fixes it but not this...

I can't believe I haven't found this earlier. Despite all the comments of 'you should use store procedures' etc., in the real world, a tool that can show me SSRS...

Thanks for an interesting article.

From a more theoretical approach, constraints are the things enforcing business logic, not indexes.

As you have observed, indexes are for performance. Unique vs non-unique...

We are a SQL Server\Visual Studio\TFS shop and I am searching for a DB source control guide using these tools. I'm curious as to why TFS is excluded from your...