vamsy chiranjeevi
vamsy chiranjeevi
  • 60
  • 173 818

Відео

Azure Managed Instance Interview Questions Part 1
Переглядів 1 тис.2 місяці тому
We are going to discuss the below questions in a detailed Manner Can you provide the checklist for MI installation? 2. What are the post-MI installation configurations? 3. What kind of applications can you migrate to MI? Would you suggest MI for critical applications? 4. Can you explain the service tiers critical/business? 5. Can you please explain about Gen-5? 6. How many components/services c...
SQL Server Partitioning Series Part-1
Переглядів 1,2 тис.2 місяці тому
SQL Server Partitioning Series Part-1
How to create indexes to resolve Tempdb usage
Переглядів 1,7 тис.3 місяці тому
How to create indexes to resolve Tempdb usage
How to access my training videos based on dates and the right order to follow
Переглядів 1,8 тис.5 місяців тому
How to access my training videos based on dates and the right order to follow
Understanding profiler events and calculating storage IOPS and Interview questions part 11
Переглядів 1,1 тис.7 місяців тому
Understanding profiler events and calculating storage IOPS and Interview questions part 11
Real time issues on SSISDB and sync up jobs in Always ON April 23rd
Переглядів 1,5 тис.8 місяців тому
Real time issues on SSISDB and sync up jobs in Always ON April 23rd
How to create DNS Alias for Managed Instance and connect to it with Private End Point
Переглядів 1,3 тис.8 місяців тому
This video explains about different ways of connecting to the Managed Instance. 1)Public Endpoint: We can connect from anywhere without the need of Point to site or site to site or Express route provided if you enable the port 3342 inside Managed instance Virtual network inbound rules. 2)VNET Local Endpoint: This is the default way of connecting to the Managed instance and it makes use of port ...
Automate Migrations from on-prem to Azure Managed Instance via Azure Data Studio using Power Shell
Переглядів 3,5 тис.9 місяців тому
When we Migrate multiple databases from on-premises to Azure Managed Instance using Data studio we have 2 methods. 1) offline 2) Online In both the modes we have 2 methodologies (I) Using Azure Blob Containers Means from On-premises we can directly place our Backup files on to Storage container by using Backup to URL. once the files are in place it will the restore them on to MI Automatically. ...
How to Make use of CMK TDE instead of SMK for MI databases and restore CMK TDE DB from MI to on-prem
Переглядів 69410 місяців тому
In this Video I have shown how to make use of Customer Managed Key for our Azure Managed Instance Database instead of Service Master key which is the default. As you know if we opt for SMK all the keys and credentials will be with Microsoft and the rotation of keys as well will be taken care by them. However due to tighten security if your company doesn't allow us to make use of SMK then we nee...
How to restore TDE enabled database from on-prem to Azure Managed instance using Windows driver kit
Переглядів 1,1 тис.10 місяців тому
How to restore TDE enabled database from on-prem to Azure Managed instance using Windows driver kit
Restore database from Managed Instance to on-prem and how to restore TDE database from on-prem to MI
Переглядів 1,6 тис.10 місяців тому
Restore database from Managed Instance to on-prem and how to restore TDE database from on-prem to MI
New Feature Wave 2022 Azure Managed Instance creation Part-1
Переглядів 1 тис.10 місяців тому
New Feature Wave 2022 Azure Managed Instance creation Part-1
Migration from SQL Server Higher Version to lower Version
Переглядів 3,2 тис.10 місяців тому
Migration from SQL Server Higher Version to lower Version
Why my Always on Availability Groups is not getting failed over despite of no errors part-2
Переглядів 1,6 тис.10 місяців тому
Why my Always on Availability Groups is not getting failed over despite of no errors part-2
Why my Always on Availability Groups is not getting failed over despite of no errors part-1
Переглядів 82510 місяців тому
Why my Always on Availability Groups is not getting failed over despite of no errors part-1
Interview Questions and Answers on SQL DBA and Azure Part-10
Переглядів 3,9 тис.11 місяців тому
Interview Questions and Answers on SQL DBA and Azure Part-10
DP 300 Certification Questions Part-2
Переглядів 2,2 тис.11 місяців тому
DP 300 Certification Questions Part-2
Always ON using Distributed Network Name (DNN) on Azure Virtual Machines (IAAS)
Переглядів 1,9 тис.Рік тому
Always ON using Distributed Network Name (DNN) on Azure Virtual Machines (IAAS)
Interview Questions Part-7 Always ON Availability Groups Part-4
Переглядів 3,8 тис.Рік тому
Interview Questions Part-7 Always ON Availability Groups Part-4
Interview Questions and Answers session 2 June 21st
Переглядів 4,1 тис.Рік тому
Interview Questions and Answers session 2 June 21st
How SQL Server 2022 Parameter Sensitive Plan Optimization overcomes problem of parameter sniffing
Переглядів 1,8 тис.Рік тому
How SQL Server 2022 Parameter Sensitive Plan Optimization overcomes problem of parameter sniffing
Interview Questions on Azure part-1
Переглядів 4,1 тис.Рік тому
Interview Questions on Azure part-1
Troubleshooting Always on Availability Groups Part-3
Переглядів 3,8 тис.Рік тому
Troubleshooting Always on Availability Groups Part-3
How to create Contained Availability Groups part-1and what will happen if we failover
Переглядів 2,8 тис.Рік тому
How to create Contained Availability Groups part-1and what will happen if we failover
How to Troubleshoot Always on when they are not in Sync Part 2
Переглядів 4,4 тис.Рік тому
How to Troubleshoot Always on when they are not in Sync Part 2
Azure Data Studio vs Data Migration Assistant
Переглядів 2,4 тис.Рік тому
Azure Data Studio vs Data Migration Assistant
SQL Server Tempdb Improvements from 2014 to 2022 with demos
Переглядів 3,6 тис.Рік тому
SQL Server Tempdb Improvements from 2014 to 2022 with demos
Point to site using Radius Authentication and Azure Active Directory
Переглядів 2,8 тис.Рік тому
Point to site using Radius Authentication and Azure Active Directory
How to resolve missing Database Master Key Password while Migrating databases in SQL Server
Переглядів 3,7 тис.Рік тому
How to resolve missing Database Master Key Password while Migrating databases in SQL Server

КОМЕНТАРІ

  • @vinayak717
    @vinayak717 16 годин тому

    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 you need to resume them

  • @RahulSharma-vi3cs
    @RahulSharma-vi3cs День тому

    You explained it simply thank you so much 🎉, much appreciated 🙏

  • @naturevibezz
    @naturevibezz 5 днів тому

    customer managed key video available?

    • @vamsychiranjeevi9619
      @vamsychiranjeevi9619 5 днів тому

      yes it is but in private mode

    • @naturevibezz
      @naturevibezz 5 днів тому

      @@vamsychiranjeevi9619 I watched the video. I am not able to create the assymetric key. It's showing error.

  • @sushilbkg
    @sushilbkg 8 днів тому

    hi vamsy, can have your whatsup number

  • @satishgarepalli5977
    @satishgarepalli5977 10 днів тому

    how to contact you..?

  • @vaibhavwadhai8046
    @vaibhavwadhai8046 17 днів тому

    Any other new video on Azure SQL database ?

    • @vamsychiranjeevi9619
      @vamsychiranjeevi9619 17 днів тому

      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 21 день тому

    Thankyou so much vamsh such a wonderful explanation of index and partition table.

  • @thangamuhtuk2850
    @thangamuhtuk2850 22 дні тому

    My dag i secondary disconnected in my client setup. Both region is azure

  • @rahulmistry3777
    @rahulmistry3777 26 днів тому

    Hi do you take classes ?for sql dba

  • @escapetothesky
    @escapetothesky 29 днів тому

    Thanks for the very detailed video

  • @sudheerratna7755
    @sudheerratna7755 Місяць тому

    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 Місяць тому

    Thank You for the demo

  • @syedthameemansari4963
    @syedthameemansari4963 Місяць тому

    Excellent video especially the folder structure issue is perfectly explained. Can you share the video where self hosted integration run time is configured

  • @rahulmistry3777
    @rahulmistry3777 Місяць тому

    Hi do you take online class ??SQL DBA and Performance tuning

  • @sudarshana2827
    @sudarshana2827 Місяць тому

    20:00

  • @Phantasia.Official
    @Phantasia.Official Місяць тому

    Missions? You meant Machines....?

  • @canuckabroad5967
    @canuckabroad5967 2 місяці тому

    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 2 місяці тому

    very interesting! how to join this session?

    • @vamsychiranjeevi9619
      @vamsychiranjeevi9619 2 місяці тому

      You can ping me on My WhatsApp +91-9739093905 for more details

  • @kingpixel4882
    @kingpixel4882 2 місяці тому

    Thanks Vamsy

  • @jayapalreddy5120
    @jayapalreddy5120 2 місяці тому

    Thank u Vamshi

  • @vaibhavwadhai8046
    @vaibhavwadhai8046 2 місяці тому

    Could you please share the note for this

  • @vaibhavwadhai8046
    @vaibhavwadhai8046 2 місяці тому

    How we can provide the sql access to end user without RBAC role for Azure SQL server ?

    • @vamsychiranjeevi9619
      @vamsychiranjeevi9619 2 місяці тому

      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 2 місяці тому

    Hi Vamsy.. Do u have any course running for SQL DBA .. I want to join.. can u send me the details

  • @sqltechzpestechz7053
    @sqltechzpestechz7053 2 місяці тому

    Tysm

  • @SaiChaitanyaJ
    @SaiChaitanyaJ 2 місяці тому

    The best

  • @gokulakrishna-hg4qd
    @gokulakrishna-hg4qd 2 місяці тому

    Thanks for the video. Are you providing any sort of training? Bcz this video looks like a training video.

    • @vamsychiranjeevi9619
      @vamsychiranjeevi9619 2 місяці тому

      Yes this is part of my training. You can ping me on my WhatsApp +91-9739093905 for more details

  • @cuongnguyenduy7684
    @cuongnguyenduy7684 2 місяці тому

    Hello sir, I have a question that how you can connect to Azure SQL MI without port 3342? Did you setup vpn?

    • @vamsychiranjeevi9619
      @vamsychiranjeevi9619 2 місяці тому

      yes I made use of VPN.

    • @vamsychiranjeevi9619
      @vamsychiranjeevi9619 2 місяці тому

      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 ua-cam.com/video/_OuFoZTGQI8/v-deo.html

    • @vamsychiranjeevi9619
      @vamsychiranjeevi9619 2 місяці тому

      In case you are interested please ping me on my WhatsApp +91-9739093905

  • @babuvenugopalan3089
    @babuvenugopalan3089 2 місяці тому

    The way you explained is very easy to understand. Waiting for next session :)

  • @uradithyak
    @uradithyak 2 місяці тому

    Very clear explanations.👌🙏

  • @talarilinganna706
    @talarilinganna706 2 місяці тому

    Hi Vamsy, Can you share me your contact number ??

  • @sadashiva5269
    @sadashiva5269 2 місяці тому

    How can you get your complete videos and the link which you have recorder

  • @paktukiman542
    @paktukiman542 2 місяці тому

    Thank you for the knowledge.

  • @krishna-gf8ok
    @krishna-gf8ok 3 місяці тому

    Can you please send ur contact number

  • @vipulrohilla1882
    @vipulrohilla1882 3 місяці тому

    Hi Vamsi, can we connect from our local laptop to Azure SQL(Not MI) using Point to site VPN?

    • @vamsychiranjeevi9619
      @vamsychiranjeevi9619 3 місяці тому

      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 3 місяці тому

    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 3 місяці тому

      I think I didn't get your question or you have not formed properly. can you re-phrase it?

  • @user-ue4kp5iw1o
    @user-ue4kp5iw1o 3 місяці тому

    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 3 місяці тому

      when DB size is 1 GB it should be faster .Wonder what are the problems that you are facing?

  • @1rv04ee065
    @1rv04ee065 3 місяці тому

    Great insights on the common interview Q&A's and deep insights on troubleshooting . Thank you for sharing with wider community !

    • @vamsychiranjeevi9619
      @vamsychiranjeevi9619 3 місяці тому

      Glad you liked it. There are 152 videos what I made till now with another 48 videos to go

  • @rahulmistry3777
    @rahulmistry3777 3 місяці тому

    DBA administration and performance tuning

    • @vamsychiranjeevi9619
      @vamsychiranjeevi9619 2 місяці тому

      Yes I do but when it comes to on-premises I usually do only Performance Tuning

    • @rahulmistry3777
      @rahulmistry3777 2 місяці тому

      @@vamsychiranjeevi9619 when is your next class will start and howmuch is the fees

    • @vamsychiranjeevi9619
      @vamsychiranjeevi9619 2 місяці тому

      @@rahulmistry3777 ping me on my WhatsApp bro +91-9739093905

  • @rahulmistry3777
    @rahulmistry3777 3 місяці тому

    do you provide advance level of DBA training

    • @vamsychiranjeevi9619
      @vamsychiranjeevi9619 3 місяці тому

      Of course I do...My training is mostly on Performance Tuning.

  • @reddikrishna9303
    @reddikrishna9303 3 місяці тому

    Hi Vamsi, can you please share your contact number?

  • @10101881
    @10101881 3 місяці тому

    Hi Vamsy, do you provide job support?

  • @chaitalib4290
    @chaitalib4290 3 місяці тому

    @author @vamsy chiranjeevi - Have you get success setting up contained AG on windows OS 2022/SQL 2022 enviornment? I am having same problem you mentioned. Please let me know how did you resolve it. thank you

  • @vasanth7507
    @vasanth7507 3 місяці тому

    Its possible to count how many data bases and size in ssms is there particular command or script ??

  • @ManchiMata2022
    @ManchiMata2022 3 місяці тому

    ua-cam.com/video/Mq4ok1S_MnE/v-deo.html

  • @ctejaswini6136
    @ctejaswini6136 3 місяці тому

    How to contact you sir? Are you taking classes ? Please do respond.

  • @vaibhavwadhai8046
    @vaibhavwadhai8046 4 місяці тому

    Who’s account of need to add in Azure active directory administrator provision for SQL server as per best practice in Prod Environment

  • @mustafaxodayev6799
    @mustafaxodayev6799 4 місяці тому

    Very informative, thanks. But how to get information what exactly is encrypted inside database using DMK?

  • @jagadeeskumarlenin5517
    @jagadeeskumarlenin5517 4 місяці тому

    Hello @vamsy , Thanks for video. I have doubt how can we used or handle the Failover primary and secondary endpoint

  • @rkb9394
    @rkb9394 4 місяці тому

    Thanks for the video.

  • @Sudeshruti
    @Sudeshruti 4 місяці тому

    It is very helpful. If it is standalone server we don’t know the password what we need to do?

    • @vamsychiranjeevi9619
      @vamsychiranjeevi9619 4 місяці тому

      This issue won't occur on the same server as SMK remains the same.