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

Quickly Setup SQL Server AlwaysOn Failover Cluster Instance (FCI) in Hyper-V

SQL-Server-Team on Mar 23 2019 12:49 PM
First published on MSDN on Jun 05, 2012 Author: Cephas LinContributors: Oleg Bulanyy Applies to: SQL Server 2008, SQL Se...
1,582

Configure Windows Failover Clustering for SQL Server (Availability Group or FCI) with Limited Security

SQL-Server-Team on Mar 23 2019 12:48 PM
First published on MSDN on Jun 05, 2012 Author: Cephas LinReviewer: Jimmy May Windows Server Failover Clustering (WSFC) ...
335

Concurrent ADD NODE operation yields unexpected results in a SQL Server Failover Cluster Instance

SQL-Server-Team on Mar 23 2019 12:45 PM
First published on MSDN on Mar 30, 2012 Please read: http://sqlcat.
475

DO NOT use Windows Failover Cluster Manager to perform Availability Group Failover

SQL-Server-Team on Mar 23 2019 12:45 PM
First published on MSDN on Mar 30, 2012 Please read: http://sqlcat.
5,221

Quorum vote configuration check in AlwaysOn Availability Group Wizards (Andy Jing)

SQL-Server-Team on Mar 23 2019 12:43 PM
First published on MSDN on Mar 13, 2012 Quorum vote configuration check in AlwaysOn Availability Group WizardsBy Andy Ji...
328

Install the latest AlwaysOn features for ADO.NET(Matt Neerincx)

SQL-Server-Team on Mar 23 2019 12:42 PM
First published on MSDN on Feb 29, 2012 Matt Neerincx from the SQL Server Data Programmability team discusses installing...
2,327

Dealing With an Unjoined Database On a Primary Replica

SQL-Server-Team on Mar 23 2019 12:42 PM
First published on MSDN on Feb 28, 2012 Suppose you force your availability group to failover to a secondary replica, an...
464

Supporting SQL Server 2012 AlwaysOn® in .NET Framework 4 (by Luiz Fernando Santos)

SQL-Server-Team on Mar 23 2019 12:40 PM
First published on MSDN on Feb 17, 2012 One of the most common questions I get from customers is which version of .
1,869

Monitoring AlwaysOn Health with PowerShell - Part 4 : Integration with SQL Server Agent

SQL-Server-Team on Mar 23 2019 12:40 PM
First published on MSDN on Feb 15, 2012 Part 4 – Scheduling and Notification with SQL AgentIn Part 3, we introduced the ...
1,501

Monitoring AlwaysOn Health with PowerShell - Part 3 : A Simple Monitoring Application

SQL-Server-Team on Mar 23 2019 12:39 PM
First published on MSDN on Feb 14, 2012 Part 3 – A Simple Monitoring Application for AlwaysOnIn Part 1 and Part 2 of thi...
6,147

Monitoring AlwaysOn Health with PowerShell - Part 1: Basic Cmdlet Overview

SQL-Server-Team on Mar 23 2019 12:39 PM
First published on MSDN on Feb 13, 2012 IntroductionThe AlwaysOn Dashboard is a very useful tool for determining the ove...
1,097

Monitoring AlwaysOn Health with PowerShell - Part 2: Advanced Cmdlet Usage

SQL-Server-Team on Mar 23 2019 12:38 PM
First published on MSDN on Feb 13, 2012 Part 2 – Advanced Usage of AlwaysOn Health CmdletsIn this part, I’ll cover some ...
592

The AlwaysOn Health Model Part 2 -- Extending the Health Model

SQL-Server-Team on Mar 23 2019 12:38 PM
First published on MSDN on Feb 13, 2012 In the first part of this series, we gave a general overview of the AlwaysOn Hea...
652

The AlwaysOn Health Model Part 1 -- Health Model Architecture

SQL-Server-Team on Mar 23 2019 12:37 PM
First published on MSDN on Feb 08, 2012 After successfully deploying a high availability solution using SQL Server 2012 ...
16.1K

How to create multiple listeners for same availability group (Goden Yao)

SQL-Server-Team on Mar 23 2019 12:36 PM
First published on MSDN on Feb 03, 2012 Blog : How to create multiple listeners for the same availability groupAs the PM...
990

Configuring AlwaysOn with SQL Server PowerShell

SQL-Server-Team on Mar 23 2019 12:35 PM
First published on MSDN on Feb 03, 2012 In this post, I’ll give examples of PowerShell scripts for configuring your SQL ...
384

Add a Log Shipping Primary Database and Secondary Database(s) to an Existing Availability Group

SQL-Server-Team on Mar 23 2019 12:34 PM
First published on MSDN on Feb 01, 2012 Add a Log Shipping Primary Database and Secondary Database(s) to an Existing Ava...
471

NOW AVAILABLE: Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery

SQL-Server-Team on Mar 23 2019 12:33 PM
First published on MSDN on Jan 26, 2012 Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster...
316

Introduction to the Availability Group Listener

SQL-Server-Team on Mar 23 2019 12:32 PM
First published on MSDN on Jan 16, 2012 Matt Neerincx from the SQL Server Connectivity team introduces the AlwaysOn Avai...
289

Who is using AlwaysOn

SQL-Server-Team on Mar 23 2019 12:31 PM
First published on MSDN on Jan 09, 2012 Several dozen customers are already running SQL Server 2012 AlwaysOn in producti...
644

Converting a logshipping configuration to Availability Group

SQL-Server-Team on Mar 23 2019 12:30 PM
First published on MSDN on Jan 09, 2012 Converting Log Shipping Configurations to a New Availability GroupLet's take a s...
589

Prepare SQL Server for using AlwaysOn feature

SQL-Server-Team on Mar 23 2019 12:30 PM
First published on MSDN on Jan 09, 2012 Prepare SQL Server for using AlwaysOn featureTo support AlwaysOn Availability Gr...
303

SQL Server 2012 AlwaysOn High Availability and Disaster Recovery Design Patterns

SQL-Server-Team on Mar 23 2019 12:30 PM
First published on MSDN on Jan 04, 2012 SQL Server 2012 AlwaysOn provides flexible design choices for selecting an appro...
326

AlwaysOn: Value Proposition of Readable Secondary

Sunil_Agarwal on Mar 23 2019 12:30 PM
First published on MSDN on Jan 04, 2012 Please refer to the following blogshttp://blogs.
272

AlwaysOn: Value Proposition of Readable Secondary

Sunil_Agarwal on Mar 23 2019 12:29 PM
First published on MSDN on Dec 22, 2011 This series of blogs is targeting AlwaysON Readable Secondary.

Latest Comments

mbourgon_optum
in Announcing GA of enhanced patching for SQL Server on Azure VM with Azure Update Manager on Apr 23 2024 07:24 AM
Yeah, double+ agree on the whole "without AG awareness, both are pretty useless". Sounds amazing, but practically I can't use it. Dammit.
0 Likes
skusen
in Announcing GA of enhanced patching for SQL Server on Azure VM with Azure Update Manager on Apr 22 2024 08:27 AM
@SivertSolem I built out a bunch of automation around this using functions from dbatools. As far as automatic like this, I don't know of anything that exists.
1 Likes
AnabilSaha
in SQL Server Licensing: High Availability and Disaster Recovery benefits on Apr 20 2024 11:36 AM
Hello Mr Banerjee. It's a really very helpful video. I have a real time scenario can you please suggest me what is your view on that ?In my current production server an architecture was decided that is going to have 2 vms for db server where 1 will be primary and 2nd will be secondary. But suddenly ...
0 Likes
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