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 […]
While troubleshooting unplanned SQL cluster failover few questions are asked commonly. When did the last failover occur? How frequently you failover (planned and unplanned)? Did this happen recently? All these questions can be answered by this query. Your output will depend on how frequently you recycle error log and retention of the error log. You […]
I wish @khanacademy had a structured #BlackHistory curriculum. Similar to "US history".
A big thanks to @SQLPedro for speaking to us tonight at @NESQL! It was a great session and we all learned a lot. Thank ... you!
Ready to listen to @SQLPedro talking about intelligent database.
Organized by @NESQLServer .
Hosted by @vivanovich
@BornSQL Randolph certainly is speaking to Edmonton PASS Chapter next Thursday. We had @SqlWorldWide talk to us about ... SSMS and now we get to compare Azure Data Studio to SSMS. Go to http://www.edmapss.pass.org to find out the details and register
by end of today I will be comfortable with Intelligent Query Processing feature.
Listening to @SQLBek for 2 hours ... starting at 11am.
Then hosting @SQLPedro for our UG @NESQLServer on the same topic.
