Our Target Audience ---------------------------------- Computer Science Students SQL Professionals SQL Database Administrators SQL Developers Data Engineers Solution Architects ETL Developers Data Science Professionals
Solutions We Offer ------------------------------------- SQL Server Videos Python Videos
Outcome We Expect -------------------------------------- People who are interacting with SQL Server on a day to day basis, when they go through our videos, they will become more knowledgeable day by day and their mind will become creative to apply the knowledge learned in different situations (during their work) and this will make them happy and content.
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 vermavine@gmail.com in case you are interested in this one on one session.
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.
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.
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 👍
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.
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.
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
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.
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
Hi Ankit, Please send me an email at vermavine@gmail.com, 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.
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. 😊
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.
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!
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!
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.
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. 😊
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 RU-vid join button.
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.