Viewing 15 posts - 1,816 through 1,830 (of 39,720 total)
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...
August 3, 2021 at 8:39 pm
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,...
August 3, 2021 at 3:26 pm
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
Viewing 15 posts - 1,816 through 1,830 (of 39,720 total)