วีดีโอ

I find it very interesting in following ur explanations ,it opens up my eye in a lot of things compare to the traditional on prem sql. Thanks for ur videos sir

How about pre-size tempdb files and do not let any user run inefficient queries period.

Very informative and very useful troubleshooting scenarios. also please replicate following issue and try to troubleshoot this scenarios. (due to its nature of the error this has multiple scenarios in itsetlf) Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=0; handshake=14999; (Microsoft SQL Server, Error: -2)

Can we connect the Azure SQL server if we given access via RBAC role ??

Vamsi sir, wonderful class🎉🎉🎉🎉

Blob data contributor access

This is the best video to learn about Azure SQL connectivity

Really awesome explanation...very impressive bro..🎉🎉🎉

If we disable public access and enable private endpoint then which is best connection policy option need to select ?

Harsha answer to to your question is failover threshold limit execeeded but allow failback option is checked due to that also it will come...

I want to join

Hi Vamsy Are there any videos marked private? If yes, how can I get access?

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

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

customer managed key video available?

hi vamsy, can have your whatsup number

how to contact you..?

Any other new video on Azure SQL database ?

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

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

Hi do you take classes ?for sql dba

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

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

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?

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 ?

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.

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

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

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?

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?

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.

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

DBA administration and performance tuning