Viewing 15 posts - 361 through 375 (of 2,756 total)
Something to note about Ken's reply, you will want to make sure that the "evaluation" license allows you to do what you are trying to do. I know the visual...
September 20, 2023 at 4:23 pm
I would take Jeff's advice here. Plus, the question about if logical or physical reads are more important to performance tuning can be found by doing a google for "performance...
September 20, 2023 at 2:12 pm
Apart from the advice above, I'd check all of the disks and any place that the backup file sat for any period of time to make sure that you aren't...
September 19, 2023 at 10:07 pm
I think the easiest way to do it would be to script out all of the stored procedures that do cross-database communication, drop them, generate the bacpacs, import the bacpacs,...
September 18, 2023 at 4:28 pm
That is a bit scary and odd... have you reported this to MS? If they are aware of it and it is a limitation of the function, they should document...
September 18, 2023 at 3:59 pm
Did it work better when run outside of Visual Studio?
September 14, 2023 at 8:09 pm
I think this depends on the P2V tools and VM host. But this is more of a server question than a SQL question. My advice would have been to not...
September 14, 2023 at 7:01 pm
First step is to review the error message. Without seeing the EXACT error message (and any associated errors) it is hard to say what the problem is. If I had...
September 14, 2023 at 6:55 pm
To add to what Jeff said, DBA in the cloud is a VERY similar skill set to DBA on premise. On the back end, it is all the same thing...
September 12, 2023 at 9:08 pm
Step 1 - check the docs:
things to note:
ODBC data sources are not supported for multidimensional solutions
AND if you want to connect to other databases, you need an "An...
September 12, 2023 at 5:41 pm
I'm still thinking this is either:
A - expected behavior <-- that is there is an error message being sent in the email notification
B - bug in Visual Studio or SSDT...
September 12, 2023 at 5:29 pm
The ONLY reason I see to use powershell for a backup process would be if you needed to move the file to a location that the SQL agent service didn't...
September 11, 2023 at 8:14 pm
According to the MS docs, that shouldn't be happening. As a really random thought - is it possible that an error did occur, just not the way you were thinking?...
September 11, 2023 at 8:11 pm
As a random guess, does the SQL Agent Service account have access to the file you are trying to rename? If I had to guess I would say It is...
September 11, 2023 at 3:12 pm
My opinion, I would ask them to do basic troubleshooting to validate that the disk is good. Just because other systems are running fine now, doesn't mean they will continue...
September 11, 2023 at 3:07 pm
Viewing 15 posts - 361 through 375 (of 2,756 total)