I used this method, but I am still unable to connect using private end
point ip and useraname as username@servername to my managed instance. My
username looks like email address removed for privacy reasons. Also I
able to connect to port 1433 using IP from destination. Please let me
know what else i...
In brief the error happens when trying to create a dacpac/bacpac from a
database or database project (or build the database project) that has
one of the following situations:1. SELECT * : using star(*) in a SELECT
statement in a view2. 3 Part names: Including database name when
referencing a table (...
Great lesson and something one would not even think about.Suggestion to
change code @line 21 to
:STRING_AGG(CONVERT(VARCHAR(max),sc1.StatisticName),'', '') WITHIN GROUP
(ORDER BY sc1.StatisticName) AS StatisticsNames,This will prevent error
when the comma delimeted statistics names exceed 8000 chara...
Hi, I'm facing a high CPU consumption on Named Replica, does rebuilding
indexes and update statistics for the primary database also execute on a
named replica?
@FonsecaSergio great article! we have intermittent issues with on-prem
VM to SQL PE by using Azure DNS private resolver. can this article be
updated with some best practices for trouble shooting with the Azure DNS
private resolver architecture?
Latest Comments