Viewing 15 posts - 1,906 through 1,920 (of 39,804 total)
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...
August 3, 2021 at 3:25 pm
I tend to want grouping of objects, so I'll do tablenamePK or tablenameAK for an alternate unique key.
August 2, 2021 at 5:48 pm
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...
August 2, 2021 at 3:22 pm
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...
August 2, 2021 at 3:21 pm
Just spotify temp files in the $userdata%\spotify folder.
It was crazy.
August 2, 2021 at 3:20 pm
At least it's Friday.
Enjoy the coffee and glad you figured it out.
July 30, 2021 at 5:39 pm
Likely you are missing some data here. If you run this, what do you get?
SELECT id, SUM(n.amount) FROM dbo.negsum AS n
GROUP BY id
If you have the ID...
July 30, 2021 at 2:31 pm
I think CD can be incredibly efficient for application code. For db code, it's more complex. A change in the db is a fundamental one that could cause more problems...
July 28, 2021 at 3:09 pm
I do like YAML for the most part, but I'd never considered that a truncated file might not be noticed. If you upload something manually for config, might not be...
July 26, 2021 at 5:15 pm

I'm in our LA office for a couple days. We actually have about 12 people here today, 4 yesterday. We're WFH through the end of 2021, but...
July 22, 2021 at 6:45 pm
I'll completely disagree. Not to get into a debate here, but different people write in different voices, and the way that this author, or some other, might present a topic...
July 22, 2021 at 6:41 pm
There is a REST API, but as you mentioned, likely this is a permissions issue you don't want to grant.
Typically what I'd do here, since anything that is direct requires...
July 21, 2021 at 10:23 pm
There are various APIs: https://docs.microsoft.com/en-us/azure/azure-sql/database/recovery-using-backups
I might think about Az or PoSh here to automate this and get a copy at a point in time.
July 21, 2021 at 10:01 pm
Do you mean a copy as of a point in time? Typically this is the same as a restore of a backup of one database. Typically you would backup and...
July 21, 2021 at 9:44 pm
Viewing 15 posts - 1,906 through 1,920 (of 39,804 total)