SQL Server Partitioning Series Part-1
1:32:23
DP 300 Certification Questions Part-2
1:14:29
Interview Questions on Azure part-1
1:01:35
Пікірлер
@vaibhavwadhai8046
@vaibhavwadhai8046 Күн бұрын
Can we connect the Azure SQL server if we given access via RBAC role ??
@HanuamnthReddy
@HanuamnthReddy 7 күн бұрын
Vamsi sir, wonderful class🎉🎉🎉🎉
@HanuamnthReddy
@HanuamnthReddy 7 күн бұрын
Blob data contributor access
@kazukikimoto8322
@kazukikimoto8322 9 күн бұрын
This is the best video to learn about Azure SQL connectivity
@HanumanthaReddy-c7c
@HanumanthaReddy-c7c 9 күн бұрын
Really awesome explanation...very impressive bro..🎉🎉🎉
@vamsychiranjeevi9619
@vamsychiranjeevi9619 7 күн бұрын
I am glad that you liked it.
@vaibhavwadhai8046
@vaibhavwadhai8046 9 күн бұрын
If we disable public access and enable private endpoint then which is best connection policy option need to select ?
@satish_sql5321
@satish_sql5321 12 күн бұрын
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-p4m
@Madhu-p4m 20 күн бұрын
I want to join
@vamsychiranjeevi9619
@vamsychiranjeevi9619 19 күн бұрын
You can ping me on my WhatsApp bro... +91-9739093905
@craghu999
@craghu999 27 күн бұрын
Hi Vamsy Are there any videos marked private? If yes, how can I get access?
@vamsychiranjeevi9619
@vamsychiranjeevi9619 27 күн бұрын
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
@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
@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
@RahulSharma-vi3cs Ай бұрын
You explained it simply thank you so much 🎉, much appreciated 🙏
@naturevibezz
@naturevibezz Ай бұрын
customer managed key video available?
@vamsychiranjeevi9619
@vamsychiranjeevi9619 Ай бұрын
yes it is but in private mode
@naturevibezz
@naturevibezz Ай бұрын
@@vamsychiranjeevi9619 I watched the video. I am not able to create the assymetric key. It's showing error.
@sushilbkg
@sushilbkg Ай бұрын
hi vamsy, can have your whatsup number
@satishgarepalli5977
@satishgarepalli5977 Ай бұрын
how to contact you..?
@vamsychiranjeevi9619
@vamsychiranjeevi9619 Ай бұрын
Via WhatsAPP +91-9739093905
@vaibhavwadhai8046
@vaibhavwadhai8046 Ай бұрын
Any other new video on Azure SQL database ?
@vamsychiranjeevi9619
@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
@kandavel0588 Ай бұрын
Thankyou so much vamsh such a wonderful explanation of index and partition table.
@vamsychiranjeevi9619
@vamsychiranjeevi9619 Ай бұрын
Glad you liked it
@thangamuhtuk2850
@thangamuhtuk2850 Ай бұрын
My dag i secondary disconnected in my client setup. Both region is azure
@rahulmistry3777
@rahulmistry3777 Ай бұрын
Hi do you take classes ?for sql dba
@vamsychiranjeevi9619
@vamsychiranjeevi9619 Ай бұрын
Yes you can reach me on my WhatsAPP 9739093905
@escapetothesky
@escapetothesky Ай бұрын
Thanks for the very detailed video
@sudheerratna7755
@sudheerratna7755 2 ай бұрын
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.
@dtchan9564
@dtchan9564 2 ай бұрын
Thank You for the demo
@syedthameemansari4963
@syedthameemansari4963 2 ай бұрын
Excellent video especially the folder structure issue is perfectly explained. Can you share the video where self hosted integration run time is configured
@vamsychiranjeevi9619
@vamsychiranjeevi9619 2 ай бұрын
you can reach me on my WhatsApp 9739093905 for more details
@rahulmistry3777
@rahulmistry3777 2 ай бұрын
Hi do you take online class ??SQL DBA and Performance tuning
@vamsychiranjeevi9619
@vamsychiranjeevi9619 2 ай бұрын
yes I do you can reach me on my WhatsApp 9739093905
@sudarshana2827
@sudarshana2827 2 ай бұрын
20:00
@Phantasia.Official
@Phantasia.Official 2 ай бұрын
Missions? You meant Machines....?
@canuckabroad5967
@canuckabroad5967 3 ай бұрын
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 ?
@adibzainal3991
@adibzainal3991 3 ай бұрын
very interesting! how to join this session?
@vamsychiranjeevi9619
@vamsychiranjeevi9619 3 ай бұрын
You can ping me on My WhatsApp +91-9739093905 for more details
@kingpixel4882
@kingpixel4882 3 ай бұрын
Thanks Vamsy
@jayapalreddy5120
@jayapalreddy5120 3 ай бұрын
Thank u Vamshi
@vaibhavwadhai8046
@vaibhavwadhai8046 3 ай бұрын
Could you please share the note for this
@vaibhavwadhai8046
@vaibhavwadhai8046 3 ай бұрын
How we can provide the sql access to end user without RBAC role for Azure SQL server ?
@vamsychiranjeevi9619
@vamsychiranjeevi9619 3 ай бұрын
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?
@akanshashashikant6218
@akanshashashikant6218 3 ай бұрын
Hi Vamsy.. Do u have any course running for SQL DBA .. I want to join.. can u send me the details
@sqltechzpestechz7053
@sqltechzpestechz7053 3 ай бұрын
Tysm
@SaiChaitanyaJ
@SaiChaitanyaJ 3 ай бұрын
The best
@gokulakrishna-hg4qd
@gokulakrishna-hg4qd 3 ай бұрын
Thanks for the video. Are you providing any sort of training? Bcz this video looks like a training video.
@vamsychiranjeevi9619
@vamsychiranjeevi9619 3 ай бұрын
Yes this is part of my training. You can ping me on my WhatsApp +91-9739093905 for more details
@cuongnguyenduy7684
@cuongnguyenduy7684 3 ай бұрын
Hello sir, I have a question that how you can connect to Azure SQL MI without port 3342? Did you setup vpn?
@vamsychiranjeevi9619
@vamsychiranjeevi9619 3 ай бұрын
yes I made use of VPN.
@vamsychiranjeevi9619
@vamsychiranjeevi9619 3 ай бұрын
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
@vamsychiranjeevi9619
@vamsychiranjeevi9619 3 ай бұрын
In case you are interested please ping me on my WhatsApp +91-9739093905
@babuvenugopalan3089
@babuvenugopalan3089 3 ай бұрын
The way you explained is very easy to understand. Waiting for next session :)
@uradithyak
@uradithyak 3 ай бұрын
Very clear explanations.👌🙏
@talarilinganna706
@talarilinganna706 3 ай бұрын
Hi Vamsy, Can you share me your contact number ??
@sadashiva5269
@sadashiva5269 3 ай бұрын
How can you get your complete videos and the link which you have recorder
@vamsychiranjeevi9619
@vamsychiranjeevi9619 3 ай бұрын
You can ping me on my WhatsApp +91-9739093905
@paktukiman542
@paktukiman542 3 ай бұрын
Thank you for the knowledge.
@krishna-gf8ok
@krishna-gf8ok 4 ай бұрын
Can you please send ur contact number
@vipulrohilla1882
@vipulrohilla1882 4 ай бұрын
Hi Vamsi, can we connect from our local laptop to Azure SQL(Not MI) using Point to site VPN?
@vamsychiranjeevi9619
@vamsychiranjeevi9619 4 ай бұрын
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.
@sumuduroshini5222
@sumuduroshini5222 4 ай бұрын
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?
@vamsychiranjeevi9619
@vamsychiranjeevi9619 4 ай бұрын
I think I didn't get your question or you have not formed properly. can you re-phrase it?
@user-ue4kp5iw1o
@user-ue4kp5iw1o 4 ай бұрын
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.
@vamsychiranjeevi9619
@vamsychiranjeevi9619 4 ай бұрын
when DB size is 1 GB it should be faster .Wonder what are the problems that you are facing?
@1rv04ee065
@1rv04ee065 4 ай бұрын
Great insights on the common interview Q&A's and deep insights on troubleshooting . Thank you for sharing with wider community !
@vamsychiranjeevi9619
@vamsychiranjeevi9619 4 ай бұрын
Glad you liked it. There are 152 videos what I made till now with another 48 videos to go
@rahulmistry3777
@rahulmistry3777 4 ай бұрын
DBA administration and performance tuning
@vamsychiranjeevi9619
@vamsychiranjeevi9619 3 ай бұрын
Yes I do but when it comes to on-premises I usually do only Performance Tuning
@rahulmistry3777
@rahulmistry3777 3 ай бұрын
@@vamsychiranjeevi9619 when is your next class will start and howmuch is the fees
@vamsychiranjeevi9619
@vamsychiranjeevi9619 3 ай бұрын
@@rahulmistry3777 ping me on my WhatsApp bro +91-9739093905
@rahulmistry3777
@rahulmistry3777 4 ай бұрын
do you provide advance level of DBA training
@vamsychiranjeevi9619
@vamsychiranjeevi9619 4 ай бұрын
Of course I do...My training is mostly on Performance Tuning.
@imranpathan8352
@imranpathan8352 12 күн бұрын
​@@vamsychiranjeevi9619hi I am watching u r video Provide u r class link
@vamsychiranjeevi9619
@vamsychiranjeevi9619 12 күн бұрын
@@imranpathan8352 kindly reach out to me on my WhatsApp +91-9739093905
@reddikrishna9303
@reddikrishna9303 4 ай бұрын
Hi Vamsi, can you please share your contact number?
@10101881
@10101881 4 ай бұрын
Hi Vamsy, do you provide job support?
@vamsychiranjeevi9619
@vamsychiranjeevi9619 4 ай бұрын
Well, Can you ping me on my WhatsApp +91-9739093905?