Пікірлер
@salmankhatri5607 7 күн бұрын
I look forward to try this in my environment Thanks for the detailed explanation....
@HanumanthaY-x3p 15 күн бұрын
Very well described
@satish_sql5321 18 күн бұрын
Can we do this thoriugh GUI in alwayson ..?
@jbswiki 17 күн бұрын
Thank you for the question. Yes you can create read routing from GUI.
@satish_sql5321 18 күн бұрын
could you please ping me your email id
@satish_sql5321 18 күн бұрын
I faced another scenario and resolved related to cluster observed same it is in pending state and fluctuating .....
@jbswiki 17 күн бұрын
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_sql5321 18 күн бұрын
Awesome nice and simple ..!!
@jhonerodriguezba 20 күн бұрын
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 .
@damodhardaamu9925 25 күн бұрын
Excellent explanation 😊
@jbswiki 24 күн бұрын
Thanks !!!Glad you liked it.
@elyassafi1423 25 күн бұрын
It didn’t work for me, getting error: Database is cannot be opened due to inaccessible files or insufficient, memory or disk space.
@srikanthmandala-gr4nz 26 күн бұрын
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.
@saitama3843 2 ай бұрын
Thank you so much. Keep posting these gems. 🙏
@jbswiki 2 ай бұрын
Wow, thanks for your interest.
@Mr_Singh12 2 ай бұрын
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?
@jbswiki 2 ай бұрын
Sure will do. Thanks for your interest.
@salmankhatri5607 2 ай бұрын
❤
@rahulmistry3777 2 ай бұрын
Great explanation hope you will upload more videos
@jbswiki 2 ай бұрын
More videos every Tuesday. Thanks for your support.
@saitama3843 2 ай бұрын
Thank you. I am watching all your videos
@jbswiki 2 ай бұрын
Thank you for your support.
@saitama3843 2 ай бұрын
Please make more such videos on internals. Thank you.
@jbswiki 2 ай бұрын
Sure, Thanks for your support!!!
@rahulmistry3777 2 ай бұрын
Amazing video
@jbswiki 2 ай бұрын
Thank you for your support.
@rahulmistry3777 2 ай бұрын
Amazing video do you take online classes ?
@jbswiki 2 ай бұрын
Glad you liked it. I am doing KZbin videos only.
@rahulmistry3777 2 ай бұрын
@@jbswiki Have any plan to start ?you can think of that on weekend
@rahulmistry3777 2 ай бұрын
Amazing video..do you take classes ?for HA and performance tunning
@jbswiki 2 ай бұрын
Thank you for your support. Glad you liked it. I am doing KZbin videos only.
@goksoy1305 2 ай бұрын
thx :D
@jbswiki 2 ай бұрын
Thank you for your support!!!
@pdsqsql1493 2 ай бұрын
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?
@juanignaciouria8798 2 ай бұрын
Excellent video; clearly explained. Thank you so much
@jbswiki 2 ай бұрын
Glad it was helpful!
@user-kw9ke4ve7z 3 ай бұрын
What is Incorrect PFS Free Space Information" Error and when we can get it and what are causes?
@rahulmistry3777 3 ай бұрын
Hi do you take classes ?for SQL DBA
@jbswiki 2 ай бұрын
Thanks for your interest. Only youtube videos and blogging.
@pdsqsql1493 3 ай бұрын
Prefect Demo! It's very step by step explained!
@jbswiki 2 ай бұрын
Thank you for the support.
@nmartinez3 3 ай бұрын
Thank you for a clear and concise explanation.
@jbswiki 3 ай бұрын
Glad it was helpful!
@pradeepdnm 3 ай бұрын
Awesome! thanks for the solution. Jai Hind!
@jbswiki 3 ай бұрын
Most welcome!
@pradeepdnm 3 ай бұрын
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.
@jbswiki 3 ай бұрын
More to come! Thanks a ton!
@Penjarlamahesh 3 ай бұрын
very good explain.
@jbswiki 3 ай бұрын
Glad it was helpful!
@damodhardaamu9925 3 ай бұрын
I think it's taking too much time for execution right
@jbswiki 2 ай бұрын
True. Solution on the main video :-)
@salmankhatri5607 3 ай бұрын
Best practical knowledge person for sql database.... 👍
@jbswiki 3 ай бұрын
Thanks a lot
@saltymango4337 3 ай бұрын
Great channel. Have an interview in couple of days. "SQL Internal Series" playlist is really useful. Thanks @Jbswiki.
@jbswiki 3 ай бұрын
Good luck with your interview. Thanks for your support.
@ravi204834 3 ай бұрын
I always love you videos
@jbswiki 3 ай бұрын
Glad you liked it. Thank you for the support.
@gauthamakrishna2808 3 ай бұрын
Very helpful session... could you please share script as well
@jbswiki 3 ай бұрын
Glad you liked it. Thank you for the support.
@srideva6577 3 ай бұрын
Excellent info
@jbswiki 3 ай бұрын
Glad you liked it. Thank you for the support.
@srideva6577 3 ай бұрын
@@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.
@maximus1260 4 ай бұрын
Clear and comprehensible presentation. Excellent video quality. Puzzled by the unexpectedly low view count.😇😇😇
@jbswiki 4 ай бұрын
Glad you liked it. Thank you for the support.
@user-iy6yb8cr7g 4 ай бұрын
This video is amazing, I appricated it, thanks very much
@jbswiki 4 ай бұрын
Glad you liked it. many thanks for your support.
@dsharma8198 4 ай бұрын
Thank you.. this helped me resolve my AG issue.
@jbswiki 4 ай бұрын
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.314 4 ай бұрын
Thumbs up if you've recommended this video to all your social media followers!
@zohaibriaz6667 5 ай бұрын
Excellent work. the most important point is that all the scripts are provided in the description. Great Work man, keep it up
@jbswiki 3 ай бұрын
Thanks a ton
@zohaibriaz6667 5 ай бұрын
Great. Excellent Work ❤
@jbswiki 5 ай бұрын
Wow, Thanks for your support.
@Tara-vc6ox 5 ай бұрын
*Promosm* ❣️
@AmitKumar-pl4qm 5 ай бұрын
Nice one
@jbswiki 5 ай бұрын
Glad you liked it.
@vinayak717 5 ай бұрын
Will you please create video on adding data file in AG database where primary and secondary has not the same drive structure.