Viewing 15 posts - 2,641 through 2,655 (of 39,818 total)
Haven't seen that. I did run across this item on learning BigQuery
July 10, 2020 at 6:48 pm
Bug filed. Not sure why the revisions appear here.
July 10, 2020 at 6:41 pm
I'm jumping in early, as I haven't yet read Leonard Lobel's blog post. As a developer I am very interested in NoSQL databases, and in particular CosmosDB. However, there's...
July 10, 2020 at 5:59 pm
I'd assume that the NoSQL data model fits better for very specific approaches, where you can encapsulate a bigger part of data and assign it to a specific user...
July 10, 2020 at 5:57 pm
Open a case with MS or call a consultant like sqlSkills. I've had similar issues, and what really happens is you have broken pages that the query engine cannot read...
July 9, 2020 at 3:43 pm
Don't use alias, unless this is defined in the Native client (https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/create-or-delete-a-server-alias-for-use-by-a-client?view=sql-server-ver15)
A DNS entry is a particular type of lookup. Usually this is an A record, which is for...
July 8, 2020 at 11:08 pm
It's often a SAN driver/hardware/etc that can cause this, but it could be memory module issues, so movement of the VM an be a pain to diagnose. Get the SAN...
July 8, 2020 at 4:45 pm
You can't dynamically join all <db name>.sys.database_files for all databases with master.sys.master_files. You can join for a particular db and easily get the sizes that way.
If you want to try...
July 8, 2020 at 4:09 pm
In a SELECT, there is no late binding of columns. You have to use dynamic SQL, as Phil noted, but there are all sorts of security problems here. You are...
July 8, 2020 at 4:04 pm
If you have extra spaces, once you substring, you can also use TRIM to clear things out.
July 8, 2020 at 4:02 pm
First, I'm not an expert here and conservative. When I have doubts, I open a CSS case with MS to work through issues. I'd also immediately restore the oldest backup...
July 8, 2020 at 3:55 pm
It all depends on your smartwatch. Apple watches need a charge most every day. My wife's Samsung needs it every 2-3 days. Mine has GPS, music via BT, and other...
July 8, 2020 at 3:21 pm
I'd actually write a job to do this. I'd allow a user to put a name into a table somewhere. I'd have a job that looked in this table, and...
July 7, 2020 at 10:25 pm
Thanks for the notes and good luck. I think you're on the right track with verify PIT.
Be sure you can do this within your RPO/RTO, and give numbers to the...
July 7, 2020 at 6:00 pm
So, don't use DNS alias. This is the FQDN as a CNAME or A entry. You have one set for the current server, like
myserver.mydomain.com 192.168.0.111
Users use this to connect, assuming...
July 6, 2020 at 7:05 pm
Viewing 15 posts - 2,641 through 2,655 (of 39,818 total)