If we Increase data size there is any chance of data loss
@Techie-VineetАй бұрын
No, but ideally you should first test this in your lab/test environment before making any changes in the production.
@SaMithun19902 ай бұрын
Baler video
@abhay62762 ай бұрын
Sir can please make video on how to build server like AoAg on Microsoft Azure environment 😊
@piyushsoni57273 ай бұрын
Sir please explain the video in hindi
@Techie-Vineet3 ай бұрын
Hi Piyush, we can explain this video to you in Hindi. However, this would require a 1 hour one on one session costing INR 500/-. Please send me an email on [email protected] in case you are interested in this one on one session.
@venkataneelapala56405 ай бұрын
Thanks, I am getting error in dimdate table, I think I need to rework again and not able to find where exactly the error.
@venkataneelapala56405 ай бұрын
Thanks, Please also tell us the purpose and advantage of this SSIS for each video, like what we achieve finally with these steps.
@Techie-Vineet5 ай бұрын
This is basically a sample tutorial on how to create and deploy Integration Services Packages. So far we have created 9 parts of this video series, some more parts are still pending and have to be created yet. Please let us know if you want us to create these parts on Deployment of Integration Packages.
@venkataneelapala56405 ай бұрын
@@Techie-Vineet Thanks for your reply I will watch remaining parts also and come back to you.
@cryptoseries32595 ай бұрын
This is helpful. I came here to learn how to restore using full recovery. Thank you so much!
@buddhikaperera57166 ай бұрын
thanks a lot sir..
@MonikaDadool6 ай бұрын
Page restore can help us restore corrupt pages in SQL database
Taking online classes is not a possibility for me at the moment as I am a working professional (mostly busy with my office work). May be soon I will think about it. Will let everyone know about this through my community post when the time is right.
@rahulmistry37777 ай бұрын
@@Techie-Vineet may be on weekend you can plan hope you will start soon
@vasugovind-tb6bi7 ай бұрын
This is very helpful. I have few questions. 1) Let us assume I have a folder called C:/Data/Documents in this folder there are almost 100 documents each with different format (they can be an .xlsx, .pdf, .docx,...etc) If I want to store them in the SQL SERVER is there any bulk insert command of option to store all these in the SQL SERVER ? 2) In the video you created a database called Archive for storing the Filestream data. Can we use the same database for creating a table to store the Student information like Student ID, Name, Subject, Marks .....etc thank you so much for posting such a great videos 👍
@hoanguyen-ls9rz7 ай бұрын
Thanks for your video
@aakashlko928 ай бұрын
Heap tables are the tables who contains only clustered indexs
@aakashlko928 ай бұрын
I have subscribed..can you please send me notes in my mail?
Thanks so much Vineet for making very detailed videos. Please what is polybase?
@Techie-Vineet10 ай бұрын
Using Polybase, you can use T-SQL in your SQL Server Instance to query data from SQL Server, Teradata, MongoDB, Hadoop Clusters, Cosmos DB, and S3-compatible object storage without separately installing any client connection software. This comes under Data Virtualization. We will soon make out many videos regarding Data Virtualization area. So keep an eye.
@sandeepagrawal301210 ай бұрын
Vineet , Your videos are really helpful to understand the things in Deep
@ankitsaxena257510 ай бұрын
Sir, 30 rupya me saare notes mil jayege kya
@Techie-Vineet10 ай бұрын
Rate is Rs. 25/- per page
@becalm532311 ай бұрын
Thanks sir ❤
@becalm532311 ай бұрын
Thanks sir ❤
@ankitsaxena56511 ай бұрын
Sir, can you teach me in Hindi one to one
@Techie-Vineet11 ай бұрын
Hi Ankit, teaching one to one is not a possibility for me due to scarcity of time. I hope you understand.
@dreamhousepune205111 ай бұрын
Dear sir, How to contact you sir?
@Techie-Vineet11 ай бұрын
You may post your comments to me on youtube.
@becalm532311 ай бұрын
Thanks for the video sir❤
@becalm532311 ай бұрын
Thank you sir. Waiting for more videos on performance tuning
@Techie-Vineet11 ай бұрын
Another Performance Tuning Video is coming within next 5 Days.
@SunilValhe-h2g11 ай бұрын
hi, do you provide trainings or course for the SQL server
@Techie-Vineet11 ай бұрын
My life is quite busy, so I will never get time for one on one trainings. So, I have started contributing videos via youtube for now. Soon, when my channel will get monetized, we will start with "paid memberships" for Videos/Courses, which you may opt for.
@becalm532311 ай бұрын
Keep up the good work 👍
@becalm532311 ай бұрын
Thank you sir ❤
@labibchy9293 Жыл бұрын
Hi Vineet bhai I have a suggestion for you . Try to use more and more in dark mode that will help your subscriber to follow the video even in late night. You can use onenote dark option. instead of notepad , notepad++ dark mode.Awesome videos
@Techie-Vineet Жыл бұрын
Will try to perform this experiment. Thanks for the suggestion.
@abhay6276 Жыл бұрын
Vineet bhai, sorry, to be frank you made lots of confusion while practically demonstrate i would suggest make a fresh video without any confusion us. And I hope you reply this time.
@Techie-Vineet Жыл бұрын
Can you please send me your confusion via email. I will review it as soon as I get a chance.
@jerrystanwick7509 Жыл бұрын
Awesome video, thank you. I am not an SQL guy but IT and dealing with a bloated .mdf file in a sccm database (specifically the dbo.logs table) Question, Say you want to keep the file, but delete the data in the file. For example you have a .mdf file, and in the file you have the table dbo.logs, how can you delete the data out of the dbo.logs table? Leaving the dbo.logs table, but cleaning it out. Not sure if wording this question correctly
@becalm5323 Жыл бұрын
Thank you Sir. Hoping to see more videos on performance tuning ❤
@Techie-Vineet Жыл бұрын
More videos to come! This is just the beginning!!
@ankitsaxena565 Жыл бұрын
Sir,can you share the PPT so that I could read the concept
@Techie-Vineet Жыл бұрын
Hi Ankit, Please send me an email at [email protected], so that I can send you PDF notes over the email. I hope you have already subscribed to my channel. If not, then please go ahead and do so.
@ankitsaxena565 Жыл бұрын
@@Techie-Vineet Yes sir,I have already subscribed to your channel and you are doing great work for the future of India
@ankitsaxena565 Жыл бұрын
@@Techie-Vineet sir,I have sent mail , please share the notes
@abhay6276 Жыл бұрын
Hi Vineet, I must appreciate your handwork for making the valuable content video. it would more better if you perform some real time scenario what developer will do after comparing the estimated plan and actual plan and instead of showing how to display and save the execution plan. i hope you got my point and will you make it soon. Thank you for Advance..waiting for your valuable reply. 😊
@Techie-Vineet Жыл бұрын
Hi Abhay, I got your point. Starting Jan 28, 2024, we are starting a series on performance Tuning videos from scratch. In initial lessons, we will cover some theory stuff and eventually move towards the practical stuff in later videos. So, stay in Tune.
@gabrielsantiagoarnesano2660 Жыл бұрын
Hi!! I'm looking for restart master database and as you said equal version is a must. I restore it in a different version of sql server 2019 and it crashed my sql instance. I'm looking for the 10.0.2000.5 version of sql server 2019, does somebody know where can i find it? I looked at microsoft official page but i didn't find it. Thanks!
@Techie-Vineet Жыл бұрын
try downloading SQL Server 2019 from below link: www.microsoft.com/en-us/evalcenter/download-sql-server-2019
@sathyakathir5242 Жыл бұрын
Good tht u choose good topics which is not shown in other channels...pls make sure to post performance tuning topics in simpler way...tht would be really useful...thanks!
@Techie-Vineet Жыл бұрын
I will try my best. You will see some new videos coming in for Performance Tuning (starting this topic from beginning) starting Jan 29. Stay tuned for more upcoming Performance Tuning Videos Jan 28 onwards.
@ankitsaxena565 Жыл бұрын
Great tutorial,you are a real hero in SQL server
@abhay6276 Жыл бұрын
Hello everyone, i m one of the subscribers of this channel , Guys if you watch the video till the end at least please like the video. if you do this it would be encourage sir to make more videos and it available for free for us...please do not be miser to hit the like button. 😊
@labibchy9293 Жыл бұрын
Quality education Vineet bhai.
@sivaramakrishnagutti3016 Жыл бұрын
Hai bro.. I need training on sql
@Techie-Vineet Жыл бұрын
For now you can watch my free videos that release every Tue, Thu and Sat. You may start with our Database Design Playlist that contain more than 30 videos at present. This Database Design playlist is expanding continuously. Soon, when I reach the appropriate subscriber count, I will release my paid courses as well that can be opted from the KZbin join button.
@sivaramakrishnagutti3016 Жыл бұрын
@@Techie-Vineet ok bro thanks.. I will suggest this channel for my friends also
@abhay6276 Жыл бұрын
Thank you so much sir ...when i was restoring the full backup with no recovery followed by consecutive log backups getting error i.e LSN mismatch.... after watching your video i finally resolved this issue ....thanks a lot sir...please make more video ... your content are practical oriented ...so please keep it continue sir.. this channel need millions of likes and subscribers...Wonderful... Have a great future.
@acayipbiseyya Жыл бұрын
you are big big big men. thanks a lot lot
@Techie-Vineet Жыл бұрын
You're welcome!
@buddhikaperera5716 Жыл бұрын
its help me very much.. thanks
@Techie-Vineet Жыл бұрын
Glad to hear that
@aymanabofard Жыл бұрын
Thank you so much my friend
@itkconfig Жыл бұрын
thank you
@sahadevpandu3555 Жыл бұрын
Well Explained.
@mertkurt947 Жыл бұрын
Thank you
@aakashlko922 жыл бұрын
Hi kindly make videos on filegroup and it's addition process in log shipping,always on and in mirroring environment