Tag Archives for " AlwaysOn "

Aug 18

AlwaysOn 2016 – New and Improved

By Ginger Daniel | Beginner , Miscellaneous , SQL Administration , SQL Server

–by Ginger Keys   AlwaysOn Availability Groups made its debut in SQL Server 2012 as a new feature that enhanced the existing technologies of database mirroring and failover clustering to provide an option for high availability and disaster recovery. AlwaysOn gives you the ability to scale out several secondary Servers (replicas) for high availability or […]

Continue reading
Feb 12

SQL Connections – Finding what fixed port SQL is listening on

By Lori Brown | Intermediate , Miscellaneous , SQL Administration , SQL Server

— 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. The availability group was functioning but as I tried to add a database to it, my connection to the secondary replica was […]

Continue reading
Oct 08

AlwaysOn Availability Groups – Enable or Disable Jobs on Failover

By Lori Brown | Helpful Scripts , Intermediate , SQL Administration , SQL Server

— By Lori Brown  @SQLSupahStah After reading up on AlwaysOn Monitoring and Alerting (http://blog.sqlrx.com/2015/08/27/alwayson-monitoring-and-alerting/), I was asked to come up with a way to automatically enable jobs that may only need to run on the primary replica of an availability group. Requirements were that on failover of an AlwaysOn Availability Group some jobs should be […]

Continue reading
Apr 23

Prerequisites for Installing SQL Server AlwaysOn

By Ginger Daniel | Installation , SQL Administration , SQL Server

Before implementing your AlwaysOn Availability Group, make sure you have everything in your environment ready to go. There are several prerequisites that need to be done to ensure a successful deployment. These prerequisites focus on your Windows environment, the SQL instances, and the databases to be included in your AlwaysOn group. Windows: Windows Server 2008 […]

Continue reading
Jan 23

What’s new in SQL Server 2014?

By SQLRx Admin | SQL Server

This article excerpt, by Johan Åhlén, originally appeared here: http://bit.ly/1dARmgI Just when we thought that nothing could get any better than SQL Server 2012, Microsoft announced news around SQL Server 2014. There’s even a SQL Server 2014 website where you can get a free trial. So, what’s new and cool? Hekaton In-memory Database Capabilities Hekaton makes it […]

Continue reading