Tags » AlwaysOn

Microsoft announced SQL Server 2016 - New features and enhancements

On Monday, 4th May 2015 Microsoft at Ignite event announced the new version of SQL Server i.e. SQL Server 2016, which will be available for Public Preview this summer. 373 more words

SQL Server New Features

Configuring SQL Server 2014 AlwaysOn Availability Group using PowerShell

Introduction

Earlier on I was trying to search for some scenarios to implement AlwaysOn Availability Groups using PowerShell, although I was able to find some interesting post however non of them represented a complete scenario starting from a fresh windows server installation (using… 731 more words

SQL

Synchronizing Read / Write SQL Agent Jobs Across AlwaysOn Replicas

Intro

AlwaysOn availability groups are a powerful enhancement to SQLServer HA, and offer many improvements over older database synchronization techniques like mirroring and log shipping. However, there is also additional complexity involved in implementing this technology, and one of the stickiest areas for database administrators is having to deal with non-contained objects, or objects that exist at the instance level, but not the database level (logins vs users, as an example). 1,126 more words

SQL Agent

Preparing for 70-462 Exam : Administering Microsoft SQL Server 2012 Databases | Certification

I’m from a Database development background and working mostly with T-SQL code only. I passed Exam 70-461 back in Nov-2012, and now I’m planing to give… 424 more words

SQL Server 2012

Steps for Installing SQL Server AlwaysOn Availability Groups

–by Ginger Keys

After you make sure you have everything in your environment ready to go and all the prerequisites that need to be done before deployment have been done, we are ready to install the AlwaysOn Availability Group! 1,419 more words

SQL Server

AlwaysOn Availability Replica is in Resolving State

AlwaysOn is a “new” feature in SQL server and there is a little understanding on how it really works. Microsoft has set a lot of functions in a black box and even Microsoft’s help says it is complicated to explain. 367 more words

SQL Server

Prerequisites for Installing SQL Server AlwaysOn

-by Ginger Keys

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. 1,078 more words

SQL Server