If we disable public access and enable private endpoint then which is best connection policy option need to select ?
@satish_sql532112 күн бұрын
Harsha answer to to your question is failover threshold limit execeeded but allow failback option is checked due to that also it will come...
@Madhu-p4m20 күн бұрын
I want to join
@vamsychiranjeevi961919 күн бұрын
You can ping me on my WhatsApp bro... +91-9739093905
@craghu99927 күн бұрын
Hi Vamsy Are there any videos marked private? If yes, how can I get access?
@vamsychiranjeevi961927 күн бұрын
Yes there are 100 videos in private mode. Few of them are on Google drive and the others on KZfaq. ping me on my WhatsApp _91-9739093905
@vinayak717Ай бұрын
If my AG is Asynchronous commit & fail over mode is manual and if my both Server is restarted what happens to AG is my AG will be healthy after restart
@vamsychiranjeevi9619Ай бұрын
if it is graceful restart then the databases will need to go through crash recovery for primary and secondary replicas. Post that the databases will come online on primary and on secondary if not we need to resume them
@RahulSharma-vi3csАй бұрын
You explained it simply thank you so much 🎉, much appreciated 🙏
@naturevibezzАй бұрын
customer managed key video available?
@vamsychiranjeevi9619Ай бұрын
yes it is but in private mode
@naturevibezzАй бұрын
@@vamsychiranjeevi9619 I watched the video. I am not able to create the assymetric key. It's showing error.
@sushilbkgАй бұрын
hi vamsy, can have your whatsup number
@satishgarepalli5977Ай бұрын
how to contact you..?
@vamsychiranjeevi9619Ай бұрын
Via WhatsAPP +91-9739093905
@vaibhavwadhai8046Ай бұрын
Any other new video on Azure SQL database ?
@vamsychiranjeevi9619Ай бұрын
Right now I am doing Partitioning series and completed 5 of them. I am planning to make them as 15. Post that there will be classes on it.
@kandavel0588Ай бұрын
Thankyou so much vamsh such a wonderful explanation of index and partition table.
@vamsychiranjeevi9619Ай бұрын
Glad you liked it
@thangamuhtuk2850Ай бұрын
My dag i secondary disconnected in my client setup. Both region is azure
@rahulmistry3777Ай бұрын
Hi do you take classes ?for sql dba
@vamsychiranjeevi9619Ай бұрын
Yes you can reach me on my WhatsAPP 9739093905
@escapetotheskyАй бұрын
Thanks for the very detailed video
@sudheerratna77552 ай бұрын
Hi Vamsy, thanks for this video. Appreciate all your efforts. Could you please help us understand as to how you were able to access SQL DB from VM when there is no explicit firewall rule/vnet rule or exception. Fyi, this was discussed around 19:53 of this video.
@dtchan95642 ай бұрын
Thank You for the demo
@syedthameemansari49632 ай бұрын
Excellent video especially the folder structure issue is perfectly explained. Can you share the video where self hosted integration run time is configured
@vamsychiranjeevi96192 ай бұрын
you can reach me on my WhatsApp 9739093905 for more details
@rahulmistry37772 ай бұрын
Hi do you take online class ??SQL DBA and Performance tuning
@vamsychiranjeevi96192 ай бұрын
yes I do you can reach me on my WhatsApp 9739093905
@sudarshana28272 ай бұрын
20:00
@Phantasia.Official2 ай бұрын
Missions? You meant Machines....?
@canuckabroad59673 ай бұрын
I wasn’t following the reason for the need to use the “tablediff” as part of the explanation. I thought he took a BACPAC of the entire table on the 2022 database and then needed to use that to restore to a brand new lower version 2019 instance. The 2022 database would have been the most up to date accurate state of data, what am I missing in his explanation, why did he stress to use tablediff to seemingly find some differences ?
@adibzainal39913 ай бұрын
very interesting! how to join this session?
@vamsychiranjeevi96193 ай бұрын
You can ping me on My WhatsApp +91-9739093905 for more details
@kingpixel48823 ай бұрын
Thanks Vamsy
@jayapalreddy51203 ай бұрын
Thank u Vamshi
@vaibhavwadhai80463 ай бұрын
Could you please share the note for this
@vaibhavwadhai80463 ай бұрын
How we can provide the sql access to end user without RBAC role for Azure SQL server ?
@vamsychiranjeevi96193 ай бұрын
Sorry I didn't get your question. From where are you trying to connect to Azure SQL DB? Is it from on-premises or from Azure?
@akanshashashikant62183 ай бұрын
Hi Vamsy.. Do u have any course running for SQL DBA .. I want to join.. can u send me the details
@sqltechzpestechz70533 ай бұрын
Tysm
@SaiChaitanyaJ3 ай бұрын
The best
@gokulakrishna-hg4qd3 ай бұрын
Thanks for the video. Are you providing any sort of training? Bcz this video looks like a training video.
@vamsychiranjeevi96193 ай бұрын
Yes this is part of my training. You can ping me on my WhatsApp +91-9739093905 for more details
@cuongnguyenduy76843 ай бұрын
Hello sir, I have a question that how you can connect to Azure SQL MI without port 3342? Did you setup vpn?
@vamsychiranjeevi96193 ай бұрын
yes I made use of VPN.
@vamsychiranjeevi96193 ай бұрын
There is a video of mine which demonstrates on different ways of connecting to Mi which means Public Endpoint, Private End Point and VPN. But it is in private mode as these part of my training. Here is the link kzfaq.info/get/bejne/lbWledKLua21eWw.html
@vamsychiranjeevi96193 ай бұрын
In case you are interested please ping me on my WhatsApp +91-9739093905
@babuvenugopalan30893 ай бұрын
The way you explained is very easy to understand. Waiting for next session :)
@uradithyak3 ай бұрын
Very clear explanations.👌🙏
@talarilinganna7063 ай бұрын
Hi Vamsy, Can you share me your contact number ??
@sadashiva52693 ай бұрын
How can you get your complete videos and the link which you have recorder
@vamsychiranjeevi96193 ай бұрын
You can ping me on my WhatsApp +91-9739093905
@paktukiman5423 ай бұрын
Thank you for the knowledge.
@krishna-gf8ok4 ай бұрын
Can you please send ur contact number
@vipulrohilla18824 ай бұрын
Hi Vamsi, can we connect from our local laptop to Azure SQL(Not MI) using Point to site VPN?
@vamsychiranjeevi96194 ай бұрын
It should work. But remember the concept of vnet is not there for Azure SQL where as in case of Mi we do have Vnet and inbound and outbound rules as well.
@sumuduroshini52224 ай бұрын
Excellent explanation and many thanks! What if there is no DMK but the column is encrypted by a private key in certificate and symmetric key is encryptedby certificate only? how to then decrypt without private key in certificate after restoring the db to new server?
@vamsychiranjeevi96194 ай бұрын
I think I didn't get your question or you have not formed properly. can you re-phrase it?
@user-ue4kp5iw1o4 ай бұрын
Hi vamshi, i ran into same problem, as we have migrated from mssql 2019 to 2022, and my team is facing issues in 2022, the database size is more than 1gb, and i cant export the db using backpack, is there any other method to rollback to 2019, i have tried using generate script and it takes a large file size and i cant pump it in my server. your help would be appreciated.
@vamsychiranjeevi96194 ай бұрын
when DB size is 1 GB it should be faster .Wonder what are the problems that you are facing?
@1rv04ee0654 ай бұрын
Great insights on the common interview Q&A's and deep insights on troubleshooting . Thank you for sharing with wider community !
@vamsychiranjeevi96194 ай бұрын
Glad you liked it. There are 152 videos what I made till now with another 48 videos to go
@rahulmistry37774 ай бұрын
DBA administration and performance tuning
@vamsychiranjeevi96193 ай бұрын
Yes I do but when it comes to on-premises I usually do only Performance Tuning
@rahulmistry37773 ай бұрын
@@vamsychiranjeevi9619 when is your next class will start and howmuch is the fees
@vamsychiranjeevi96193 ай бұрын
@@rahulmistry3777 ping me on my WhatsApp bro +91-9739093905
@rahulmistry37774 ай бұрын
do you provide advance level of DBA training
@vamsychiranjeevi96194 ай бұрын
Of course I do...My training is mostly on Performance Tuning.
@imranpathan835212 күн бұрын
@@vamsychiranjeevi9619hi I am watching u r video Provide u r class link
@vamsychiranjeevi961912 күн бұрын
@@imranpathan8352 kindly reach out to me on my WhatsApp +91-9739093905
@reddikrishna93034 ай бұрын
Hi Vamsi, can you please share your contact number?
@101018814 ай бұрын
Hi Vamsy, do you provide job support?
@vamsychiranjeevi96194 ай бұрын
Well, Can you ping me on my WhatsApp +91-9739093905?