I look forward to try this in my environment Thanks for the detailed explanation....
@HanumanthaY-x3p15 күн бұрын
Very well described
@satish_sql532118 күн бұрын
Can we do this thoriugh GUI in alwayson ..?
@jbswiki17 күн бұрын
Thank you for the question. Yes you can create read routing from GUI.
@satish_sql532118 күн бұрын
could you please ping me your email id
@satish_sql532118 күн бұрын
I faced another scenario and resolved related to cluster observed same it is in pending state and fluctuating .....
@jbswiki17 күн бұрын
Thanks for sharing your experience. It’s interesting to hear that you encountered a similar issue with the cluster being in a pending state and fluctuating. Could you share more details on how you resolved it? It might help others facing the same problem.
@satish_sql532118 күн бұрын
Awesome nice and simple ..!!
@jhonerodriguezba20 күн бұрын
Hi broo , sorry but when I started using DTBRS I can not find an admin account , let me know how can I fix this issue please .
@damodhardaamu992525 күн бұрын
Excellent explanation 😊
@jbswiki24 күн бұрын
Thanks !!!Glad you liked it.
@elyassafi142325 күн бұрын
It didn’t work for me, getting error: Database is cannot be opened due to inaccessible files or insufficient, memory or disk space.
@srikanthmandala-gr4nz26 күн бұрын
Well said
@jvivek2k1Ай бұрын
🎉❤ very good Good luck
@kart19121980Ай бұрын
Nicely explained things in detail related to Azure SQL database auditing...very much informative and thanks once again for sharing everything for free...good work 👍👍👍
@jbswikiАй бұрын
Thanks. Glad you find it useful.
@acayipbiseyyaАй бұрын
So, can we say that the one with the highest selectivity should be written first in the where condition?
@jbswikiАй бұрын
Yes, it’s generally a good practice to place the condition with the highest selectivity first in the WHERE clause. This helps the database engine filter out rows more efficiently, potentially improving query performance. Selectivity refers to the ability of a condition to narrow down the number of rows returned by a query. The more selective a condition, the fewer rows it returns.
@farhaanchyАй бұрын
Please advise a scenario where the communication link between the HQ and DR is broken and you do a forced failover but if the HQ servers comes up and formes a quorom and the DR site doesnt know wont there be a split brain scenario as there are now two writeable primaries one at the hq and one at the Dr.
@raimca1Ай бұрын
Good video
@jbswikiАй бұрын
Glad you enjoyed
@MyLubimishBabyLoveАй бұрын
Under availability group there is always 1 primary server and 1 or more secondary. If i have some heavy script to run and want to switch mode to async what is best approach? Should i change it on primary and all secondary servers or only secondary? I mean inside availability group. As shown in your video at 05:30
@jbswikiАй бұрын
Hope you are well. Only secondary should fine for the given scenario.
@saitama38432 ай бұрын
Thank you so much. Keep posting these gems. 🙏
@jbswiki2 ай бұрын
Wow, thanks for your interest.
@Mr_Singh122 ай бұрын
Please add a conclusion of the video at the end because here I understand what you have explained but didn't understand as why we are looking into those details and what are we driving from these details. Basically, what are we trying to achieve?
@jbswiki2 ай бұрын
Sure will do. Thanks for your interest.
@salmankhatri56072 ай бұрын
❤
@rahulmistry37772 ай бұрын
Great explanation hope you will upload more videos
@jbswiki2 ай бұрын
More videos every Tuesday. Thanks for your support.
@saitama38432 ай бұрын
Thank you. I am watching all your videos
@jbswiki2 ай бұрын
Thank you for your support.
@saitama38432 ай бұрын
Please make more such videos on internals. Thank you.
@jbswiki2 ай бұрын
Sure, Thanks for your support!!!
@rahulmistry37772 ай бұрын
Amazing video
@jbswiki2 ай бұрын
Thank you for your support.
@rahulmistry37772 ай бұрын
Amazing video do you take online classes ?
@jbswiki2 ай бұрын
Glad you liked it. I am doing KZbin videos only.
@rahulmistry37772 ай бұрын
@@jbswiki Have any plan to start ?you can think of that on weekend
@rahulmistry37772 ай бұрын
Amazing video..do you take classes ?for HA and performance tunning
@jbswiki2 ай бұрын
Thank you for your support. Glad you liked it. I am doing KZbin videos only.
@goksoy13052 ай бұрын
thx :D
@jbswiki2 ай бұрын
Thank you for your support!!!
@pdsqsql14932 ай бұрын
Really great presentation, explained very well with everything!!! How we can migrate existing on-prem User and windows logins which are AD accounts to Managed Instance? I can see in my MI database AS login as red cross so wondering need current logins?
@juanignaciouria87982 ай бұрын
Excellent video; clearly explained. Thank you so much
@jbswiki2 ай бұрын
Glad it was helpful!
@user-kw9ke4ve7z3 ай бұрын
What is Incorrect PFS Free Space Information" Error and when we can get it and what are causes?
@rahulmistry37773 ай бұрын
Hi do you take classes ?for SQL DBA
@jbswiki2 ай бұрын
Thanks for your interest. Only youtube videos and blogging.
@pdsqsql14933 ай бұрын
Prefect Demo! It's very step by step explained!
@jbswiki2 ай бұрын
Thank you for the support.
@nmartinez33 ай бұрын
Thank you for a clear and concise explanation.
@jbswiki3 ай бұрын
Glad it was helpful!
@pradeepdnm3 ай бұрын
Awesome! thanks for the solution. Jai Hind!
@jbswiki3 ай бұрын
Most welcome!
@pradeepdnm3 ай бұрын
Hey Vivek, Good Day! Thanks for this video. helps a lot. Thank you for contributing to the community. looking for more videos on SQL server.
@jbswiki3 ай бұрын
More to come! Thanks a ton!
@Penjarlamahesh3 ай бұрын
very good explain.
@jbswiki3 ай бұрын
Glad it was helpful!
@damodhardaamu99253 ай бұрын
I think it's taking too much time for execution right
@jbswiki2 ай бұрын
True. Solution on the main video :-)
@salmankhatri56073 ай бұрын
Best practical knowledge person for sql database.... 👍
@jbswiki3 ай бұрын
Thanks a lot
@saltymango43373 ай бұрын
Great channel. Have an interview in couple of days. "SQL Internal Series" playlist is really useful. Thanks @Jbswiki.
@jbswiki3 ай бұрын
Good luck with your interview. Thanks for your support.
@ravi2048343 ай бұрын
I always love you videos
@jbswiki3 ай бұрын
Glad you liked it. Thank you for the support.
@gauthamakrishna28083 ай бұрын
Very helpful session... could you please share script as well
@jbswiki3 ай бұрын
Glad you liked it. Thank you for the support.
@srideva65773 ай бұрын
Excellent info
@jbswiki3 ай бұрын
Glad you liked it. Thank you for the support.
@srideva65773 ай бұрын
@@jbswiki I have watched all your videos. It really makes me better knowledge in MSSQL. Very clear explanation in the topics you covered so far. Thank you so much.
@maximus12604 ай бұрын
Clear and comprehensible presentation. Excellent video quality. Puzzled by the unexpectedly low view count.😇😇😇
@jbswiki4 ай бұрын
Glad you liked it. Thank you for the support.
@user-iy6yb8cr7g4 ай бұрын
This video is amazing, I appricated it, thanks very much
@jbswiki4 ай бұрын
Glad you liked it. many thanks for your support.
@dsharma81984 ай бұрын
Thank you.. this helped me resolve my AG issue.
@jbswiki4 ай бұрын
I'm thrilled to hear that the video was helpful in resolving your AG issue! Your success is exactly why I create this content. If you have any more questions or need further assistance, don't hesitate to reach out. Thanks for watching and for your support!
@BUY.YOUTUB.VIEWS.3144 ай бұрын
Thumbs up if you've recommended this video to all your social media followers!
@zohaibriaz66675 ай бұрын
Excellent work. the most important point is that all the scripts are provided in the description. Great Work man, keep it up
@jbswiki3 ай бұрын
Thanks a ton
@zohaibriaz66675 ай бұрын
Great. Excellent Work ❤
@jbswiki5 ай бұрын
Wow, Thanks for your support.
@Tara-vc6ox5 ай бұрын
*Promosm* ❣️
@AmitKumar-pl4qm5 ай бұрын
Nice one
@jbswiki5 ай бұрын
Glad you liked it.
@vinayak7175 ай бұрын
Will you please create video on adding data file in AG database where primary and secondary has not the same drive structure.