cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

SQL Server Blog
Options
3,173

Announcing General Availability of Azure Portal Experience to Deploy Multi-Subnet Availability Group

TarynPratt on Aug 29 2023 08:31 AM
Today, we are excited to announce general availability (GA) of the end-to-end experience to deploy a multi-subnet Availa...
7,574

What’s New in Visual Studio Extensions for SSAS and SSRS

subhojitbasak on Dec 19 2022 05:35 AM
Learn more about the latest enhancements in Analysis Services Projects 2022 and Reporting Services Projects 2022
4,226

HADR_SYNC_COMMIT Wait Updates (In Progress)

BobDorr on Oct 03 2022 03:27 PM
HADR_SYNC_COMMIT Wait Updates (In Progress)
3,922

SQL Server Always on Availability Group Scalability Experiment and Result on Azure VM

zimwang_1993 on Feb 23 2021 08:42 AM
Today to meet the demands of fast business growth, many Tier 1 customers need to configure their Always On Availability ...
3,955

Released: Support for Distributed Network Names (DNN) Listeners for Always On Availability Groups

Kevin Farlee on Oct 19 2020 10:49 AM
We are pleased to announce support for Distributed Network Name based listeners in Availability Groups. As of SQL Server...
21.8K

Lift and Shift Always On SQL Server Failover Cluster Instance (SQL FCI) to Azure VMs

Mine Tokus on Jul 06 2020 09:51 AM
Today, we are announcing two new features enabling lift and shift of Always On SQL server Failover Cluster instances (SQ...
67.9K

SQL Server Licensing: High Availability and Disaster Recovery benefits

Amit Banerjee on Mar 05 2020 11:38 PM
Learn about how the new SQL Server High Availability and Disaster Recovery Software Assurance benefits can help you arch...
627

AlwaysOn Availability Groups: Comparing On-Premises Deployments and Azure VM Deployments

SQL-Server-Team on Mar 23 2019 01:24 PM
First published on MSDN on Feb 05, 2014 Cross posting from SQLCAT blog:http://blogs.
809

AlwaysOn Availability Groups, Listener, Named Instances, Port Numbers, etc.

SQL-Server-Team on Mar 23 2019 01:23 PM
First published on MSDN on Feb 05, 2014 Cross posting from SQLCAT blog:http://blogs.
453

AlwaysOn Availability Group in Windows Azure VM: Client Connectivity Scenarios

SQL-Server-Team on Mar 23 2019 01:23 PM
First published on MSDN on Feb 05, 2014 Cross posting from SQLCAT blog:http://blogs.
702

Published: Troubleshooting Guide for Availability Group Listener in Windows Azure

SQL-Server-Team on Mar 23 2019 01:23 PM
First published on MSDN on Jan 06, 2014 Before the holidays, this article was quietly published: http://msdn.
434

More Windows Azure E2E Scripts!

SQL-Server-Team on Mar 23 2019 01:22 PM
First published on MSDN on Dec 05, 2013 In case you're not already aware, I've written additional scripts for Windows Az...
389

Availability Group Listener in Hybrid IT: End-to-End PowerShell Script Published

SQL-Server-Team on Mar 23 2019 01:22 PM
First published on MSDN on Nov 22, 2013 Hello,Please check out the script at http://gallery.
584

Availability Group Listener in Windows Azure Now Supported! (And Scripts for Cloud-Only Configuration)

SQL-Server-Team on Mar 23 2019 01:21 PM
First published on MSDN on Aug 06, 2013 If you haven't noticed, AlwaysOn Availability Groups in Windows Azure now suppor...
976

AlwaysOn Availability Groups Troubleshooting and Monitoring Guide published!

SQL-Server-Team on Mar 23 2019 01:20 PM
First published on MSDN on Jun 06, 2013 AlwaysOn Availability Groups Troubleshooting and Monitoring Guide provides infor...
1,026

Upgrade and Update Guide for AlwaysOn Availability Groups published!

SQL-Server-Team on Mar 23 2019 01:19 PM
First published on MSDN on May 30, 2013 The upgrade/update guide for availability group servers is now live on MSDN.
1,653

Connecting to Availability Group Listener in Hybrid IT

SQL-Server-Team on Mar 23 2019 01:18 PM
First published on MSDN on Feb 14, 2013 In this blog, I'd like to explore client connectivity strategy when you have an ...
4,876

Test Lab: Create an AlwaysOn Availability Group in Windows Azure End-to-End

SQL-Server-Team on Mar 23 2019 01:15 PM
First published on MSDN on Jan 23, 2013 In this blog, you will learn how to configure AlwaysOn Availability Groups end-t...
567

HADR Tutorials for SQL Server in Windows Azure VMs

SQL-Server-Team on Mar 23 2019 01:01 PM
First published on MSDN on Dec 18, 2012 Hi Folks,For those interested in how to do SQL Server HADR in Windows Azure VMs,...
967

WSFC Cluster Configuration on Windows Azure Virtual Machines

SQL-Server-Team on Mar 23 2019 12:59 PM
First published on MSDN on Dec 03, 2012 Windows Azure Virtual Machines (VMs) are currently in preview at www.
2,052

How To: Migrate to AlwaysOn from Prior Deployments Combining Database Mirroring and Log Shipping – Part 2

SQL-Server-Team on Mar 23 2019 12:58 PM
First published on MSDN on Oct 16, 2012 Writer: Cephas Lin (Microsoft) Contributors: Oleg Bulanyy (Microsoft), Jimmy May...
1,057

How To: Migrate to AlwaysOn AlwaysOn from Prior Deployments Combining Database Mirroring and Log Shipping – Part 1

SQL-Server-Team on Mar 23 2019 12:57 PM
First published on MSDN on Oct 16, 2012 Writer: Cephas Lin (Microsoft) Contributors: Oleg Bulanyy (Microsoft), Jimmy May...
4,608

How To: Migrate from Failover Cluster Instances and Database Mirroring to SQL Server AlwaysOn – Part 3

SQL-Server-Team on Mar 23 2019 12:56 PM
First published on MSDN on Sep 28, 2012 Writer: Cephas Lin (Microsoft) Contributors: Oleg Bulanyy (Microsoft), Jimmy May...
1,328

How To: Migrate from Failover Cluster Instances and Database Mirroring to SQL Server AlwaysOn – Part 2

SQL-Server-Team on Mar 23 2019 12:55 PM
First published on MSDN on Sep 28, 2012 Writer: Cephas Lin (Microsoft) Contributors: Oleg Bulanyy (Microsoft), Jimmy May...
2,158

How To: Migrate from Failover Cluster Instances and Database Mirroring to SQL Server AlwaysOn – Part 1

SQL-Server-Team on Mar 23 2019 12:55 PM
First published on MSDN on Sep 28, 2012 Writer: Cephas Lin (Microsoft) Contributors: Oleg Bulanyy (Microsoft), Jimmy May...
1,336

Migration Guide: Migrating to AlwaysOn Availability Groups from Prior Deployments Combining Database Mirroring and Log Shipping

SQL-Server-Team on Mar 23 2019 12:50 PM
First published on MSDN on Aug 20, 2012 Writer:Cephas Lin (Microsoft)Contributors: Sanjay Mishra (Microsoft)Technical Re...
1,946

AlwaysOn Architecture Guides

SQL-Server-Team on Mar 23 2019 12:49 PM
First published on MSDN on Jul 03, 2012 Newly published: two new architecture guides:AlwaysOn Architecture Guide: Buildi...

Latest Comments

erinstellato
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 17 2024 11:54 AM
@DavidYorkshire Following up on your statement that WSUS isn't consistently for updates, with the example that new versions of Windows OS have been available through WSUS for years. Correct. You can update from Windows 8 -> 8.1 ->10 -> 11, or Windows Server 2016 -> 2019 -> 2022 and presumably -> 202...
0 Likes
erinstellato
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 17 2024 07:13 AM
@sgtmango333 We don't overwrite settings with any upgrade (minor or major). You have to import settings from a previous version to update them. We understand there is additional effort related to connection settings with SSMS 20 - that is why we shared information about the release in advance and no...
0 Likes
sgtmango333
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 17 2024 06:48 AM
I understand the intent, but that makes life a difficult for those using a Central Management Server with hundreds of instances. That means that every one on my team must now connnect to every server and update this setting just to maintain functionality after installing version 20. So next question...
0 Likes
SivertSolem
in Announcing GA of enhanced patching for SQL Server on Azure VM with Azure Update Manager on Apr 17 2024 04:16 AM
@TarynPratt wrote:At this point, patching SQL Server on Azure VMs through Azure Update Manager or Automated Patching via the SQL IaaS extension is not aware if the SQL Server is a part of an Always On availability group. It is important to keep this in mind when scheduling your updates with an autom...
1 Likes
erinstellato
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 16 2024 06:15 PM
@sgtmango333 I missed your question, apologies. It is not possible to set the default value for the Encryption property to optional. With SSMS 20 we upgraded to MDS 5.x, which sets Encryption to Mandatory (true) by default. We intentionally decided to stay with the default, to encourage folks toward...
1 Likes