Viewing 15 posts - 16 through 30 (of 1,769 total)
Depends on the configuration of the app.
In ssms you have options to not to encrypt or to trust the servers certificate (even if it is invalid)
March 8, 2022 at 9:37 am
Different connection settings? (ansi nulls, ...)
March 3, 2022 at 10:01 am
Have a look how's it done in dbatools https://dbatools.io/xevents/
March 1, 2022 at 2:24 pm
Even if it is a dedicated SQL box, I would configure sql server max memory to ensure there is some ram left for OS , Antivirus, ...
February 18, 2022 at 9:46 am
I don't see an issue in using randomly generated PK names for temp tables
February 1, 2022 at 9:53 am
I'm also using SCOM 2019 and run into discovery problems. Usually when the DB is disabled.
Haven't the time for a full discussion but this may be a start.
https://docs.microsoft.com/en-us/troubleshoot/system-center/scom/troubleshoot-sql-database-discovery
The required...
February 1, 2022 at 9:48 am
Could be. Didn't got notified of your reply "are-the-posted-questions-getting-worse"
January 21, 2022 at 3:31 pm
The second will be better by skipping unneccessary data modifications / triggers. No point in updating billions of 999 rows to 999 rows where there are only 3 <> 999...
January 21, 2022 at 3:28 pm
Answers without samples
#1: joinorder doesn't matter. SQL Optimizer permutates join order in order to get the lowest cost plan. You can switch the join order in your statement. Beware Left...
January 21, 2022 at 3:17 pm
I haven't experienced major delays with Microsoft Authenticator sofar
January 20, 2022 at 12:51 pm
C# . It's mostly used by our devs. ( it helps translating ORM implementations ). Investing R / ML is on hold as you need quite a statistical background
January 14, 2022 at 10:11 am
I welcome the free toolset and hope it gets a place next to sp_WhoIsActive, FirstResponder.
Are there real world examples where the tool was used?
January 14, 2022 at 10:07 am
You may also try configure HTTP first and then switch to https
January 13, 2022 at 10:45 am
Not really.
Currently I have the following in PowerBI rsreportserver.config
<URLReservations>
<Application>
<Name>ReportServerWebService</Name>
<VirtualDirectory>ReportServer</VirtualDirectory>
<URLs>
<URL>
<UrlString>https://+:443</UrlString>
<AccountSid>....../AccountSid>
<AccountName>NT SERVICE\PowerBIReportServer</AccountName>
</URL>
</URLs>
</Application>
<Application>
<Name>ReportServerWebApp</Name>
<VirtualDirectory>Reports</VirtualDirectory>
<URLs>
<URL>
<UrlString>https://+:443</UrlString>
<AccountSid>........</AccountSid>
<AccountName>NT SERVICE\PowerBIReportServer</AccountName>
</URL>
</URLs>
</Application>
</URLReservations>
January 13, 2022 at 10:23 am
Viewing 15 posts - 16 through 30 (of 1,769 total)