Availability databases hosted on SQL Server Always On Availability Groups (AG) can be connected using a unique Virtual Network Name (VNN), called the Availability Group Listener. When an Availability Group is enabled, clients can connect to databases in both primary and secondary replicas without explicitly specifying the SQL Server instance name. You don’t even need […]
2019-07-02
19,377 reads
By Andy Warren
I’ve gathered a bunch of notes from conversations and time reflecting, thought I’d write...
By Will Assaf
Thanks for the 90+ who joined today's PASS Professional Development Virtual Group webinar on...
By Daniel Janik
Recently I ran into an error when trying to copy a small database bacpac...
Hi sql gurus, I am currently doing some R&D on MERGE statement and as...
In the past couple months, I have helped people understand a handful of topics...
Please share your thought about advantages and disadvantages for processing using temp table or...
Ask SSC