Viewing 15 posts - 1,921 through 1,935 (of 39,720 total)
bperry's comment made me smile. My son, a few years ago, had an issue with his laptop. We had to go into the cli to restore things and I was...
May 24, 2021 at 4:36 pm
I'll add that while I thought R would be way better, a lot of the same modules and packages from R have been ported to Python, so I find the...
May 21, 2021 at 3:31 pm
Not an error. A warning. This still works:
> i <- c(1,2,3)
> j <- c(4,5)
> k <- i * j
Warning message:
In i * j : longer object length...
May 19, 2021 at 10:03 pm
Thanks, good catch. You are correct.
this is fixed.
May 19, 2021 at 2:12 pm
I'd think your "AND" is a problem here, as an event doesn't have all 3.
May 18, 2021 at 7:19 pm
I'm not entirely sure what you want to do here. You can do this in SQL Server (https://www.sqlservercentral.com/articles/geocode-addresses-in-t-sql), directly by using the spatial types. Or you could call the...
May 18, 2021 at 7:15 pm
Can you connect to the container instance in SSMS/ADS?
Can you post the C++ code and actual error? Not sure I can help here, but a few things I found:
May 18, 2021 at 7:05 pm
good advice, Eric. Certainly we've seen MS, Google, etc. make changes. I dislike some of these companies making a far reaching decision quickly without really knowing the effects.
At Redgate, we've...
May 18, 2021 at 6:06 pm
xevents is very lightweight, but since jobhistory is going to get this, not sure you querying text is better than a table.
May 17, 2021 at 3:35 pm
I would lean towards Jeff's idea here if possible. There is an audit event on restore start, but that won't stop anything. At best, you'll get a chance to kill...
May 17, 2021 at 3:31 pm
If the vendor doesn't want to allow changes. I'd build a process to "scrub" entries every minute. Index the column if you can and search for problem strings. Then decide...
May 17, 2021 at 3:17 pm
ISDATE() isn't perfect (https://stackoverflow.com/questions/32755924/isdate-in-not-working-as-expected-in-sql-server)
You may need some other guard clauses or checks to be sure the value is a date. Unfortunately, dates are just not stored in a consistent...
May 17, 2021 at 3:08 pm
For TDE, the symmetric encryption key, the DEK, is in the database. This is always the case. The certificate that is used to encrypt/decrypt this is stored in Azure Key...
May 17, 2021 at 3:05 pm
Viewing 15 posts - 1,921 through 1,935 (of 39,720 total)