×

High Availability

Panelist at HA/DR Open Q&A Extravaganza

December 6, 2019

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. […]

How to Exclude Read_Only Databases Using sp_MSforeachdb

March 28, 2017

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 […]

SQL Server Fullscan Statistics Being Overwritten with Sample Statistics

March 3, 2017

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 […]

Schedule SQL Agent Job With Availability Group

January 28, 2016

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 […]

Which Node SQL Cluster was Running

February 20, 2015

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 […]


profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook

In an hour I will be presenting at room - 2

New features in Management Studio -- Performance Troubleshooting made ... easier!

https://www.sqlsaturday.com/1016/en-us/Sessions/Details/sid/108130

Hope to see you there.
#sqlsatSaoPaulo #sqlsat1016 #sqlpass #MVPBuzz

During my career at sea we called Vitoria, Rio Grande do Sul, Santos and Rio de Janeiro many times.
Who knew one day I ... will be speaking at #sqlsatSaoPaulo
Life is strange.

Good morning.
Reviewing my presentation for #sqlsat1016 in 2 hours.
Good luck to all speakers, organizers and ... volunteers. Appreciate attendees taking time out for advancing their career.
#sqlsat1016 #sqlsatsaopaulo #SQLPass

Republicans didn’t want the #TrumpUniversity deposition getting out. I guess this really is the video they don’t ... want you to watch and retweet. So let’s all watch and retweet! 😲

#TrumpTrainwreck #TrumpIsALaughingStock
cc @motherjones @DavidCornDC @donwinslow #Demcast

Load More...