The ‘Always On Availability Group’ feature is a high-availability and disaster-recovery solution. Since the launch with SQL Server 2012, data professionals have adopted this solution widely. Before implementing ‘Always On Availability Group’, data professionals need to make decisions about availability and failover mode. These decisions will involve discussion with business owners of the applications that […]
HA/DR Open Q&A Extravaganza is on December 10th, 2019, at 1 PM EST. This event is one of the most extensive lineups of SQL Server HA/DR experts in history, and any question goes! ! Organized by High Availability and Disaster Recovery PASS virtual group. I am honored, humbled, and super excited to be part of this panel. […]
I will explain how you can use sp_MSforeachdb stored procedure against READ_WRITE database only. There are numerous articles on the web about excluding databases using database id or name. Recently I needed a script to run against databases that are part of Always On Availability Groups and in READ_WRITE status. I used the ‘Updateability’ properties […]
I observed this behavior only in the following version of SQL Server while using Always On Availability Group feature. Version: Microsoft SQL Server 2012 (SP3) (KB3072779) – 11.0.6020.0 (X64) Oct 20 2015 15:36:27 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 (Build 9600: ) In this article by David Barbarin […]
There was a tweet that came last night from Lohit about “need guidance on how to enable a set of jobs on secondary AG as soon as failover happens from primary to secondary AG”. I have implemented a solution for most (I am using “most” literally because I have not done this for all jobs) of […]
Hey Software Engineers - we're hiring top technologists with a passion for big data solutions. Join our webinar on 1/21 ... at 12pm EST to learn about tech opportunities. #FidelityAssociate #SoftwareEngineer #TechJobs #FidelityTech
Hope and pray that our nation does not slide into more chaos. I am nervous seeing this:
"Now, as I prepare to hand power... over to a new administration at noon on Wednesday, I want you to know that the movement we started is only just beginning," he said.
Data Saturday #5 Redmond is happening on April 17th, 2021. It is an all-day virtual training in the Data field. The call... for speakers is open until March 31st.