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
7,383 reads
In this case, the cause of the long failover time was enabling Query Store after upgrading, for a database with a large workload of ad hoc queries, meaning there was 100GB of Query Store data to load.
2019-05-31
2018-11-15
673 reads
2018-07-16
679 reads
2018-06-11
757 reads
In SQL Server 2016 the availability group automatic seeding functionality is implemented. This article will detail the steps to use of SSMS with automatic seeding and its limitations.
2018-03-27
842 reads
Transparent Data Encryption on an Availability Group and Automatic Database Seeding
2018-03-08
772 reads
In this tip, Manvendra Singh will cover how to add another database to an existing Always On Availability Group.
2018-02-05
2,385 reads
Set up and use the automatic databases seeding feature for Availability Groups.
2018-01-22
1,913 reads
There is already a template on the Azure marketplace for setting up an AlwaysOn Availability Group. In just a few easy steps you can get a working AlwaysOn Availability Group setup, configured and running - this post describes the steps to quickly set it up.
2017-10-18
3,292 reads
By Steve Jones
This week we released SQL Prompt 10, which is an exciting milestone for us....
By Devin-Knight
Check out this new series that I’ve started on Power Platform Quick Tips. This...
Over the years I’ve seen quite a few strange things with SQL Server. This...
Comments posted to this topic are about the item Numeric and Decimal, which is...
Comments posted to this topic are about the item Learn from the Troubles of...
hello, the following query is displaying the result i want except i want it...
Ask SSC