My opinion - this would be better suited on a C++ forum, or even a general coding forum, and not on a SQL Server specific forum... but I can try...

I would look at the logs on your db2 server.  The error is being thrown on that server, so that should tell you what is wrong.  Could be something like...

My opinion, this type of question is usually better asked on web-based development forums.  The database has no idea what field is selected by default at the application side based...

I am not sure if that is 1 error or 2, but I would try to solve the first error first:

The component metadata for "Power Query Source, clsid {7CDF593F-DE06-4ABD-B356-7976EF7AC8E0}" could...

I am not 100% sure on what you are trying to do, but I have a guess.  I think what you are going to want to do is for that...

I would say give it a shot and see what happens.

Clone your system to a test/dev box and do some performance testing after cloning to get some baseline numbers. ...

Personally, I'm not a huge fan of that "fix". My approach would be to change the SQL Server Service and SQL Agent Service to run as an AD account...

I agree with Ant-Green - this sounds like a homework question. And it is very vague and I am a bit confused what you mean by your first statement...

I have never heard of or used flexbox, but a quick google makes it look like it is a CSS tool?

If my findings are correct, then I think that this...

I think part of the problem is how you are defining "first" and "group by". Since you have no ORDER BY in your query, you have no "first"....

To add to what ratbak said, if you have a lot of schemas, you MAY not have a default set to dbo for a specific user. This is configurable,...

Certificates are backed up along with the database, so when you restore, all certificates are restored along with the database. You will likely need to re-map the master key...

In the example you gave, the reason you are NOT seeing a duplicate when you have mother in there twice instead of father is because you used UNION.  UNION will...

My advice - post the error message.  I have a feeling it doesn't say the literal words "INSERT is wrong".

Now, I am also not 100% familiar with PostgreSQL, but I...

The query being executed for those curious and not wanting to click the link:

insert into [ExtractReports].[dbo].[TradeCodesDelete](PartID,Code,CodeTypeID,SourceTypeID,RevisionID,ZPLID,PartLevel,CreatedDate,FlagDelete)
   ----select count(1) from [ExtractReports].[dbo].[TradeCodesDelete]
 ---update [ExtractReports].[dbo].[TradeCodesDelete] set FlagDelete=2 where...