Tags » AlwaysOn

sql dba alwayson interview questions

One of the best known feature introduced in SQL Server 2012 is “AlwaysOn” which makes use of existing HA/DR features and provide additional features like Availability Groups. 6,644 more words


I Rule the World

My heart is happy because of the technology to which I have access. I am entertained (and distracted) by Facebook and Netflix. My TV has this nifty option called “On Demand”. 423 more words


SQL Connections – Finding what fixed port SQL is listening on

— by Lori Brown  @SQLSupahStah

While trying to add a database to an existing AlwaysOn Availability Group (AG), I was having difficulty making a connection from the primary replica to the secondary replica. 378 more words

SQL Server

Manual Failover error on SQL Server 2014SP1 AlwaysOn

I implemented AlwaysOn Availability groups solution on SQL Server 2014 SP1.

During the testing of a manual failover (via the GUI), I encountered the following error: 239 more words


There have been lots of requests from community in Delhi to talk about HADR with SQL Server. Finally, we managed to get the event organized based on the theme of HADR using SQL 2016 AlwaysON. 524 more words

SQL DB Engine

Build your own SQL Server Playground Part 1 (Intro)

When I first started working with SQL server it was as a BI developer. This was fine and I learned a lot. But after a few years I wanted to learn more about performance of and high availability and so started my journey to DBA. 463 more words


Setup LAB: 06 Installing Windows Failover Cluster to setup AlwaysOn

In the last post, I had configured the iSCSI target service to share the disk between two servers. I am going to use those two servers as Windows server Failover Cluster nodes and setup AlwaysOn availability group using that. 291 more words

How To