Nice Video Mr.Amit. I worked with you long ago when you visited Hyderabad ICICI bank client.

how do find which table transactions are pending delivery to the subscriber .. we have seen transaction replication latencies with log reader agent ..can you plz explore more about the log reader agent troubleshooting

Great explanations

This is an awesome presentation on Transactional Replication. Thank you so much.

so helpful, every time I scared because every time I repair the production database in downtime, sometime without clean backups.

very good video, goes to the deep, really worthy of watching!

Please republish it with screen (it is blackscreen all the time)

thanks for this video, how about for Availablilty group on multi subnet always on? it do not hearbeat isn't it?

I have now uploaded my presentation to my github project located here: github.com/TrayceJ/AlwaysOnScripts/blob/main/Presentations/Troubleshooting%20AlwaysOn_20150714.pptx Please feel free to watch my other presentation from 2017 on Finding Root cause AG failovers located here: kzbin.info/www/bejne/j2jSq6ewetGJh7c I have uploaded the scripts and training scenarios mentioned in my 2017 presentation. Scripts are located here: github.com/TrayceJ/AlwaysOnScripts/tree/main/Diagnostic Training scenarios are located here: github.com/TrayceJ/AlwaysOnScripts/blob/main/Presentations/TroubleshootingScenarios.zip

I have now located the scripts, presentation, and scenarios up to my github project located here: github.com/TrayceJ/AlwaysOnScripts The link to the scenarios is: github.com/TrayceJ/AlwaysOnScripts/blob/main/Presentations/TroubleshootingScenarios.zip The link to the scripts is: github.com/TrayceJ/AlwaysOnScripts/tree/main/Diagnostic Please let me know if you have any questions or problems. [email protected]

Thank you so much....

I have a question how " Kubernetes cluster is relate to Ansible Cluster" mean Kubernetes cluster vs Ansible cluster.

Very nice explanation

FYI, make sure to enable trace flag 1800. We ran into issues on this

Any where to get the script

It was a really interesting video. Thanks

The best explanation of Kubernetes Architecture! Anthony Nocentino is the best! Thank you for fantastic job!

Hi Help us with ag replica lag script

Hii.... Trayce it is a great explanation..... wonderful diagnosing Do we have any option to get the scripts please?

can't we estimate the issues without power BI?

thanks a lot for this intresting info and for your effort in order to explain all this concepts !!!

Speed talks through concepts and terms that should be paused over to let sink in Some simple things are presented with an overcomplicated blizzard of words Be pretty familiar with k8s before you give this a listen Sounds as though it is tuned for landing repeat corporate training engagements The CNCF talks are MUCH more worth the time, eg. kzbin.info/www/bejne/kKasgqioncSees0

Great AG video! Do you have scripts posted anywhere?

Thanks Jordan, Do you have more information about the scripts?

Starts at 4:45

Great 👍 thank you

I am using SQL Serve Enterprise Edition (64-bit) and in this i am using transactional-replication with on Publisher , one Replication Distribution Agent with four Subscriber. everything was going smoothly but now when i am seeing my replication in SQL server through replication monitor and clicking on 'subscription watch list' all subscribers status are showing as 'Expiring soon/Expired' and i am not sure why and when i am double clicking on subscriber error message are 'no replicated transactions are available'.please suggest me what to do

I am in an enterprise that has never deployed a windows failover cluster and our windows team/ad team is scratching their heads with my HA request. My understand is that I as a DBA cannot deploy a HA solution without them first building up the failover cluster. Yes or no? If yes, do you have a video on building this part of the architecture for the purposes of a SQL HA solution? I have watched a few already but they seem to focus on pre-2012 architecture and most of it seems irrelevant now. (eg., multi-node witness vs shared storage, quorum, etc).

This isn't 2017 specific. This seems to be a rebroadcast of the SQL 2016 presentation.

Excellent presentation. Appreciate the slides and examples

Good one. I have a video on configuring the AlwaysOn setup in Azure . It will brief you about the ateps and requiremebts and walk you through my setup. Do visit if it interests you 😊

is a distributed AG a recommended DR approach for production ?

Hello Jordan, thanks for this video please any link to the script.

Have a question. When I completed the Always-on high availability Wizard. All the server(s) database(s) are all showing (Restoring...) I know I can use scripts to fix this RESTORE DATABASE MyDatabase WITH RECOVERY or RESTORE LOG [MyDatabase] FROM DISK = N'c:\sql\MyDatabase.bak' This is my question? Why does it do this for, and why can't it complete the (Recovering...) on its on? Thanks. Wayne

What is replication latency

This is one of the valuable video out on the internet on Transnational Replication. Cheers Drew you killed it!!

Hi!, seeing this video gives me a vision of how big "The Database worlds" is !! :D . Also this gives me a reason to learn more. I'm a noob in regards to Database Management and I want to be DBA at the end of the day.. Thanks, PS. Looking for MENTOR's in regards to DBA, willing to learn, but don't have that funds From: Philippines !! God bless !! I hope there would be a tutorial in regards to DBA - road to Hero (DBA)

starts at 5:14

Hi, please where is the script?

its a great help. Thank u Jordan

Its very helpful info. I really enjoy.

What I am trying to understand is, if the databases are already a part of AG, then what is the need of setting up Replication?

Why would not you maximize the screen where all the action is happening????

Extremely good video! Great Information!

Really good video, thanks for your work.

Superb, excellently drafted

Please send scripts link

no screen sharing....

Here is the link to Edwins article that he references in the video: www.mssqltips.com/sqlservertip/2728/sql-server-2012-multisubnet-cluster-part-1/

Hi Team, You should provide DMV for fetching details for the same..