Updated to add multi-column index. Thanks for  the note.

I'd do what's suggested above, likely Python or PoSh for me. Schedule this to run, secure credentials somehow

Don't forget to truncate the staging table before or after the process.

If you need updates, the easiest thing is to make a simple flat file import to a staging table. Then a query that inserts/updates based on the values in the...

You can stop some of the Google stuff, and they tend not to sell it because they use it themselves. At least you know when where the evil is.

That's strange. I use Chrome and it works fine. This is a CNAME redirect, which should be working.

Try this: https://sqlmemorialstorage.z22.web.core.windows.net/

Ugh, I'm torn on this. On one hand, this might make things cheaper for some people, but...

Re: file import, I contacted the individual about their behavior and language. We do not tolerate that type of discussion.

There should be a link in the profile. I just realized it wasn't there. I usually get an email and click on it, and don't look back at old ones,...

what I don't like about system generated names is that it makes deployments from dev systems dicey. Depending on the tool, it might try to rebuild those constraints, which isn't...

I have no idea. AFAIK, I only have 3 devices connected with my account, so not sure. I did text the family to ask if someone was using my account.

However,...

For me, I'm woefully inconsistent. I'd have:

create table dbo.Sale
( SaleID int not null constraint SalePK primary Key
, SaleDate date
)
go
create table auditing.Sale
( SaleID int not null constraint AuditingSalePK...

I tend to want grouping of objects, so I'll do tablenamePK or tablenameAK for an alternate unique key.

Thanks, good to know about other solutions.

One question. If you want things to change, do you have a separate config for each instance that you update? Do you store this...

You are welcome. It was one of those that just struck me. I know I've seen the error, but seeing that this is a real object was something I wanted...