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
2,988

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...
6,315

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
3,634

HADR_SYNC_COMMIT Wait Updates (In Progress)

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

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,724

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.4K

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...
62.6K

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...
588

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.
769

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.
422

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.
636

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.
390

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...
347

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.
522

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...
891

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...
836

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,441

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,442

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...
511

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,...
920

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.
1,794

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...
866

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,256

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,154

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...
1,867

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,209

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,612

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

GontranHarvey
in SQL Server 2022 Release Candidate 1 is now available on Dec 11 2023 02:38 AM
Hi, I ask you in October 2022 if I install the RC1 if I would be able to upgrade it to standard without reinstall it.You told me YES.Now i try to upgrade to the standard version and it seems impossible because whatever I do sql server tells me it's an evaluation edition.Based on some research, I thi...
0 Likes
DanrCarollo
in Temporal: Encountering Error 13535 Data modification failed on system-versioned table... on Dec 07 2023 10:55 AM
We just deployed Temporal Tables (SQL Server 2019) and didn't even make it out of our DEV environment without running into this error! I did find a workaround using TRY/CATCH logic. Unfortunately, the client code is using SQL Alchemy, generating SQL on the fly, which means we can't just wrap this in...
0 Likes
Ken_Morley
in Step by Step Guide to Setup LDAPS on Windows Server on Dec 06 2023 03:03 PM
While this article is well-written, it doesn't appear to achieve the goal of enabling LDAPS in Windows Server. The first issue is the article ignores servers which happen to be Domain Controllers, which is *probably* the majority of servers that users need to enable for LDAP and LDAPS. On Windows Se...
0 Likes
amvin87
in Always on Availability Groups for SQL Server containers on Kubernetes - The DH2i's DxOperator way!! on Dec 06 2023 12:57 AM
Yes, this is true even now. The above operator deploy's SQL Server Linux based containers available on MCR and cataloged here: Microsoft Artifact Registry.
0 Likes
in Always on Availability Groups for SQL Server containers on Kubernetes - The DH2i's DxOperator way!! on Dec 05 2023 03:44 PM
I thought per https://github.com/microsoft/mssql-docker/tree/master/windows that SQL Server is not supported on Windows in containers for production environments. "Note: These images are provided AS-IS. Microsoft currently does not support running SQL Server on Windows Containers in a production sce...
0 Likes