![vamsy chiranjeevi](/img/default-banner.jpg)
- 60
- 173 818
vamsy chiranjeevi
Ireland
Приєднався 17 січ 2012
Відео
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
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
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
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
You explained it simply thank you so much 🎉, much appreciated 🙏
customer managed key video available?
yes it is but in private mode
@@vamsychiranjeevi9619 I watched the video. I am not able to create the assymetric key. It's showing error.
hi vamsy, can have your whatsup number
how to contact you..?
Via WhatsAPP +91-9739093905
Any other new video on Azure SQL database ?
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.
Thankyou so much vamsh such a wonderful explanation of index and partition table.
Glad you liked it
My dag i secondary disconnected in my client setup. Both region is azure
Hi do you take classes ?for sql dba
Yes you can reach me on my WhatsAPP 9739093905
Thanks for the very detailed video
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.
Thank You for the demo
Excellent video especially the folder structure issue is perfectly explained. Can you share the video where self hosted integration run time is configured
you can reach me on my WhatsApp 9739093905 for more details
Hi do you take online class ??SQL DBA and Performance tuning
yes I do you can reach me on my WhatsApp 9739093905
20:00
Missions? You meant Machines....?
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 ?
very interesting! how to join this session?
You can ping me on My WhatsApp +91-9739093905 for more details
Thanks Vamsy
Thank u Vamshi
Could you please share the note for this
How we can provide the sql access to end user without RBAC role for Azure SQL server ?
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?
Hi Vamsy.. Do u have any course running for SQL DBA .. I want to join.. can u send me the details
Tysm
The best
Thanks for the video. Are you providing any sort of training? Bcz this video looks like a training video.
Yes this is part of my training. You can ping me on my WhatsApp +91-9739093905 for more details
Hello sir, I have a question that how you can connect to Azure SQL MI without port 3342? Did you setup vpn?
yes I made use of VPN.
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
In case you are interested please ping me on my WhatsApp +91-9739093905
The way you explained is very easy to understand. Waiting for next session :)
Very clear explanations.👌🙏
Hi Vamsy, Can you share me your contact number ??
How can you get your complete videos and the link which you have recorder
You can ping me on my WhatsApp +91-9739093905
Thank you for the knowledge.
Can you please send ur contact number
Hi Vamsi, can we connect from our local laptop to Azure SQL(Not MI) using Point to site VPN?
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.
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?
I think I didn't get your question or you have not formed properly. can you re-phrase it?
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.
when DB size is 1 GB it should be faster .Wonder what are the problems that you are facing?
Great insights on the common interview Q&A's and deep insights on troubleshooting . Thank you for sharing with wider community !
Glad you liked it. There are 152 videos what I made till now with another 48 videos to go
DBA administration and performance tuning
Yes I do but when it comes to on-premises I usually do only Performance Tuning
@@vamsychiranjeevi9619 when is your next class will start and howmuch is the fees
@@rahulmistry3777 ping me on my WhatsApp bro +91-9739093905
do you provide advance level of DBA training
Of course I do...My training is mostly on Performance Tuning.
Hi Vamsi, can you please share your contact number?
Hi Vamsy, do you provide job support?
Well, Can you ping me on my WhatsApp +91-9739093905?
@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
Its possible to count how many data bases and size in ssms is there particular command or script ??
ua-cam.com/video/Mq4ok1S_MnE/v-deo.html
How to contact you sir? Are you taking classes ? Please do respond.
Hi, you can reach me on my WhatsApp +91-9739093905
Who’s account of need to add in Azure active directory administrator provision for SQL server as per best practice in Prod Environment
Very informative, thanks. But how to get information what exactly is encrypted inside database using DMK?
Hello @vamsy , Thanks for video. I have doubt how can we used or handle the Failover primary and secondary endpoint
Thanks for the video.
It is very helpful. If it is standalone server we don’t know the password what we need to do?
This issue won't occur on the same server as SMK remains the same.