Пікірлер
@Ganeshay-09
@Ganeshay-09 16 сағат бұрын
I think he is finding and searching for an answer .he is not Confidence
@Ganeshay-09
@Ganeshay-09 2 күн бұрын
how to add ethernet two connnect node 1 node 2 in that two enternet0 enternet1
@MSSQLDBATechSupport
@MSSQLDBATechSupport Күн бұрын
keep them in nat or host...and give the same series of ip ... See the full video ...we have almost 1 hour+ video on this same topic for another sql server versions as well
@ddnorbertbb
@ddnorbertbb 8 күн бұрын
Good tips, Thank You :)
@MSSQLDBATechSupport
@MSSQLDBATechSupport 7 күн бұрын
Glad it was helpful!
@mohak42
@mohak42 9 күн бұрын
Can you please take my interview?
@MSSQLDBATechSupport
@MSSQLDBATechSupport 8 күн бұрын
will inform you once we open registrations...
@saikumarkakarla9924
@saikumarkakarla9924 13 күн бұрын
Thanks brother. i use the same stamps in my production db . did successfully.
@MSSQLDBATechSupport
@MSSQLDBATechSupport 11 күн бұрын
Great 👍
@GowzYuvaVlogs
@GowzYuvaVlogs 14 күн бұрын
Script is not available in the drive. Can you please place it again
@MSSQLDBATechSupport
@MSSQLDBATechSupport 11 күн бұрын
Its paid kzbin.info/www/bejne/hoGrd3mXjMeGn6csi=WPZCMqcMQI1TdUtz
@lakshmikanthreddy7010
@lakshmikanthreddy7010 15 күн бұрын
To s3 bucket by using ola hallengren can we take backups .If ye please provide Thanks and nice explanation.
@MSSQLDBATechSupport
@MSSQLDBATechSupport 11 күн бұрын
yes... we can take... Please go through official documentation until i made a video
@prasadch-h3q
@prasadch-h3q 15 күн бұрын
Good explanation.. Thanks Harsha
@MSSQLDBATechSupport
@MSSQLDBATechSupport 15 күн бұрын
My pleasure 😊
@markoostendorp4423
@markoostendorp4423 17 күн бұрын
any tip if i dont see the cert in protocals?
@MSSQLDBATechSupport
@MSSQLDBATechSupport 17 күн бұрын
need to work with relative teams (probally with windows team)
@nareshg2957
@nareshg2957 19 күн бұрын
The request content was invalid and could not be deserialized: Required property 'name' not found in 'sku'. (Code: InvalidRequestContent) getting this error while creating it.
@MSSQLDBATechSupport
@MSSQLDBATechSupport 17 күн бұрын
Azure will make continuously add changes to there products... please go through Microsoft Documentation and F&Qs
@OluwaserereAkerele
@OluwaserereAkerele 19 күн бұрын
Where is the query pls. The google drive is not accessible
@MSSQLDBATechSupport
@MSSQLDBATechSupport 19 күн бұрын
Its paid program kzbin.info/www/bejne/hoGrd3mXjMeGn6csi=WPZCMqcMQI1TdUtz
@srid478
@srid478 20 күн бұрын
Hi , Can you provide the list of scripts that will you share once join
@MSSQLDBATechSupport
@MSSQLDBATechSupport 20 күн бұрын
I am not active on this course
@ayanvlogs3049
@ayanvlogs3049 20 күн бұрын
Script is no exist in the link which you provided.... Please provide me the link to download the script.. Thank you.
@MSSQLDBATechSupport
@MSSQLDBATechSupport 19 күн бұрын
Its paid program kzbin.info/www/bejne/hoGrd3mXjMeGn6csi=WPZCMqcMQI1TdUtz
@AmaniRachid-w4q
@AmaniRachid-w4q 21 күн бұрын
Databasless forget IT nowadays make your own business it wil be more better😅
@MSSQLDBATechSupport
@MSSQLDBATechSupport 20 күн бұрын
😊
@Not_First_Of_His_Name
@Not_First_Of_His_Name 21 күн бұрын
i get error when trying to connect with encryption mandatory and without certificate. but with optional it connects, with certficate it connects. Can you explain me why?
@MSSQLDBATechSupport
@MSSQLDBATechSupport 20 күн бұрын
Your Answer has been in below video kzbin.info/www/bejne/enLWf2htod6JfMk
@arjunsarnaik2104
@arjunsarnaik2104 22 күн бұрын
How to remove blocked logins ?
@MSSQLDBATechSupport
@MSSQLDBATechSupport 22 күн бұрын
If logins are getting failed,we need to make sure why logins are getting failed,need to act accordingly.. If you want to remove the logins from the instance, just go to instance-->security-->select the login which you want to remove-->delete
@arjunsarnaik2104
@arjunsarnaik2104 22 күн бұрын
@@MSSQLDBATechSupport My SQL Server login is currently blocked? How to troubleshoot
@MSSQLDBATechSupport
@MSSQLDBATechSupport 20 күн бұрын
If your enter the password wrongly for 3 times(again it depends on your organization password policy),it will blocked... configure audit to find the reason why logins are getting blocked.there your will get an answer... if you want to unblock the login... select the login(which login u want to unblock)-->status-->select the login is locked out.. If the login is blocked from windows side then u need to contact the active directory team to unblock as well. There could be n Number of reasons and use cases,need to find the reason and take action accordingly.
@yasinhamad5982
@yasinhamad5982 29 күн бұрын
Thanks.
@MSSQLDBATechSupport
@MSSQLDBATechSupport 22 күн бұрын
Welcome!
@damodhardaamu9925
@damodhardaamu9925 Ай бұрын
Already you're using AOAG, so what is the reason behind creating the replication( or)this scenario also running 🤔
@MSSQLDBATechSupport
@MSSQLDBATechSupport Ай бұрын
Its combing both HA technologies... its all requirement comes from client... Node1 and node2 are in always on... now to replicate one table to node3 ... at that time this video will helpful
@abhay6276
@abhay6276 Ай бұрын
Thank you Harsha 😊
@MSSQLDBATechSupport
@MSSQLDBATechSupport Ай бұрын
Welcome!!
@RKE558
@RKE558 Ай бұрын
Harsha where can i find the os image and sqlserver images could u provide links plz
@MSSQLDBATechSupport
@MSSQLDBATechSupport Ай бұрын
Due to unpaid for storage,it got deleted
@RKE558
@RKE558 Ай бұрын
@MSSQLDBATechSupport thank you Harsha for your prompt response
@MSSQLDBATechSupport
@MSSQLDBATechSupport Ай бұрын
😊
@Naveenkumar-bl8nq
@Naveenkumar-bl8nq Ай бұрын
Hi, thanks for video, I need some kt how to pass host name in certificate field. Since I have some test cases to handle so
@MSSQLDBATechSupport
@MSSQLDBATechSupport Ай бұрын
I tried with Localmachine in cert location.... I didn't tested what could be the consequences if we pass the directly hostname...
@caglim
@caglim Ай бұрын
First of all, thank you for the video; it’s really well-made. However, I have a question. I’m using a 2-node AON setup and have configured transactional replication, but not according to AON. I set everything up on N1-distribution database, jobs, publication, etc., are all on N1. Naturally, it didn’t work after failing over to N2. In your video, was the distribution database already present, or did you create it directly on N2? That’s my question. Do you have any recommendations for me? Instead of starting from scratch, are there scripts I can run to make it work on N2 as well? What steps would you suggest I take?
@MSSQLDBATechSupport
@MSSQLDBATechSupport Ай бұрын
I am using N3 as distributor server... and i had created earlier it self... i am telling to distributor server if N1 is not available u can connect to listener... Try to create using GUI ,and don't enter finish at the last and take script only... like that u can try to automate.
@luisfranciscordg
@luisfranciscordg Ай бұрын
MS SQL Server has SQL Server Language Extensions and SQL CLR for extensibility.
@MSSQLDBATechSupport
@MSSQLDBATechSupport Ай бұрын
Thanks for adding the point
@PrasadCh-u9y
@PrasadCh-u9y Ай бұрын
Thanks Harsha..very useful
@MSSQLDBATechSupport
@MSSQLDBATechSupport Ай бұрын
Keep watching
@mirzairfan3426
@mirzairfan3426 Ай бұрын
Excellent video. Really appreciated ur efforts. Please can u check the link to downlod the script is not found. Please can you share the link and so script ca be downloaded. Bundle of thanks in advance
@MSSQLDBATechSupport
@MSSQLDBATechSupport Ай бұрын
its only for our standard paid users www.youtube.com/@MSSQLDBATechSupport/join
@SajjadAli-vh3gm
@SajjadAli-vh3gm Ай бұрын
The link isn't working
@MSSQLDBATechSupport
@MSSQLDBATechSupport Ай бұрын
its only for our standard paid users www.youtube.com/@MSSQLDBATechSupport/join
@mosaadhasan2762
@mosaadhasan2762 Ай бұрын
Thank u very much indeed u solved the problem of using cursor in triggers I am very grateful to u
@MSSQLDBATechSupport
@MSSQLDBATechSupport Ай бұрын
Glad to hear that
@AdemiSan-x3i
@AdemiSan-x3i 2 ай бұрын
Great job. Your videos are clear. Do you have whatsapp contact?
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
Thanks...
@spamspam7888
@spamspam7888 2 ай бұрын
you saved my fucking time bro
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
☺️
@hemanthp8587
@hemanthp8587 2 ай бұрын
The best explanation of SQL server architecture in the shortest time
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
Thanks
@rajsekhar2247
@rajsekhar2247 2 ай бұрын
Clear explanation 👍
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
Glad you liked it!
@Wong-i5v
@Wong-i5v 2 ай бұрын
Hi, how can you change the local user to a domain user later?
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
Thats not possible... As shown in the video by administrator is the local admin for every windows system.... I used local administrator user which has been there... i didn't convert any user... i used already existing account only.
@abhay6276
@abhay6276 2 ай бұрын
Sir do we have video on how to build server in Microsoft Azure for free? If yes could you please share the link with us.
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
Its all depends on your free subscription... if you had free subscription u can do the same with limited resources.. remaining all same to same
@abhay6276
@abhay6276 2 ай бұрын
@MSSQLDBATechSupport sir i think you have made video on it please can you share the link here. I searched alot but unable to find.
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
kzbin.info/www/bejne/fmTUhIeefsR8fpIsi=L73BGg37SmM60tvb
@kishorKumarGantyala
@kishorKumarGantyala 2 ай бұрын
Nice video, Can you please share us script which was used in the video?
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
You'll need to follow the video instructions to get access to the scripts. kzbin.info/www/bejne/hoGrd3mXjMeGn6csi=QaRJt5mtjN20fYP0
@gongatireddy4285
@gongatireddy4285 2 ай бұрын
Great tip!!
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
Thanks! & Glad you liked it!
@ishaqqureshi6735
@ishaqqureshi6735 2 ай бұрын
I can not download the scripts ?? kindly allow it
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
You'll need to follow the video instructions to get access to the scripts. kzbin.info/www/bejne/hoGrd3mXjMeGn6csi=QaRJt5mtjN20fYP0
@CoryFulchiron
@CoryFulchiron 2 ай бұрын
Thank you :)
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
You're welcome!
@konersite
@konersite 2 ай бұрын
Thank you, It worked
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
Glad it helped!
@swamikrishnaanurag335
@swamikrishnaanurag335 2 ай бұрын
Hi,how can we connect?
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
U can drop an email [email protected]
@swapnilvmestry
@swapnilvmestry 2 ай бұрын
Very Nicely explained. If possible, please share the scripts
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
Glad you liked the explanation! The scripts are available for standard support users kzbin.info/www/bejne/hoGrd3mXjMeGn6csi=xRM8xBRJeUurSwRW
@MaheshG-nw2sr
@MaheshG-nw2sr 2 ай бұрын
Thank you Anna for the valuable content and script
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
Welcome
@manendrakollepara8620
@manendrakollepara8620 2 ай бұрын
Hi harsha good informative videos for the above can we create a job to sent email for failed logins
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
thats what i said in the video as well.
@SAINATH879
@SAINATH879 2 ай бұрын
the query used to pull list of groups where one of the user belongs to is not giving accurate solution. in my case user belongs to multiple groups but it is showing only one group.
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
In that cases possible reasons are that all groups might be not added into sql server. or Might not have sufficient permissions or You need to raise the support ticket to microsoft.
@veerukodavalluri5479
@veerukodavalluri5479 2 ай бұрын
Let’s say if something happens to global forwarder what is the impact on other nodes ?
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
Nothing happens... if anything happens to Forwarder the secondary replica in that AG will take up that role... By default DAG will be Asynchronous mode.so No need to worry... Before going to production test and POC with all scenarios you had
@veerukodavalluri5479
@veerukodavalluri5479 2 ай бұрын
@MSSQLDBATechSupport Thank you Harsha
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
welcome
@veerukodavalluri5479
@veerukodavalluri5479 2 ай бұрын
Hi, how can we configure backup jobs ? , will it allow ola scripts ?how to setup preferred node here in DAG configuration
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
I think no... But you need to write the your T SQL Logic
@saikiran-fu6xu
@saikiran-fu6xu 2 ай бұрын
can you please share the google drive link for the script
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
its paid... Follow the video to get the access kzbin.info/www/bejne/hoGrd3mXjMeGn6csi=ujMlMs_UFuRL7ku4
@aniruddhabera6049
@aniruddhabera6049 2 ай бұрын
Nice
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
Thanks
@aniruddhabera6049
@aniruddhabera6049 2 ай бұрын
Nice and interesting
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
Glad you found it interesting.
@Srinivasulu-rn5od
@Srinivasulu-rn5od 2 ай бұрын
Nice video, this is the first time a listening a video about queue, bit confusing but interesting, Thanks
@MSSQLDBATechSupport
@MSSQLDBATechSupport 2 ай бұрын
Thanks! I'm glad you found the video interesting! Queue concepts can be challenging, but hopefully this video helped make it a little clearer.