Hi Phil,

what kind of connector are you using to communicate with the SQL database when writing c#?

System.Data.SqlClient?

I am asking, because I am wondering how you are calling the stored procedures...

it is especially useful, if you need a table to be online all the time, but want to load lots of data to it (e.g. full reload). Then you can...

Hey Jeff,

Indeed, we deploy empty copies of prod instances via VS. Typically, we are not copying instances containing user data regularly. And if we need to move them to another...

I use the aforementioned 3-part schema if I query a foreign table from a stored procedure. As said, staging and DWH is a good example for this scenario. Here I...

Hi Jeff,

in our case as an automatically generated 3-part name (I guess even no linked server is supported with this model, but not sure). It is important to know, that...

We once used to utilizing them, but with the advent of database projects in VS, we abandoned them again from our development. This due to the reason, that VS itself...