Thanks for the Video. easy to follow. Just got started with writing a winforms app that started as a text based config with output to text files then added database support. I was doing all my "create table" logic in SQL Server Management Studio with saved SQL files, but this is way better as I can put my project under source control in Github. Maybe I should have already know this stuff.
Hey there,keep up the great work in your channel. I have only a general enquiry as a newbie sql learner. Could i channel shopify live data into an sql application?(This should be an application developed for a company of 50 employees mainly for the sake of generating reports and analytics)) Is this an easy process to undertake as a sql beginner? What should i keep in mind and what are the tools or softwares that i should work with right from the beginning. For notice, I made my mind to work with microsoft sql server, also our company has a dedicated server. Thanks for taking care of my enquiry.
Hello does Microsoft SQL Server Local Database have a storage limit of the file size or is the only limit the storage capacity of your HDD or SSD of your computer, in addition I would like to also know any restrictions or limitation of MS SQL Localdb. Thank you.
The storage capacity is essentially limited by the available storage on your computer's HDD or SSD. You can use as much storage as your disk allows. LocalDB may lack certain advanced features available in the full version of SQL Server, such as SQL Server Agent, SQL Server Integration Services (SSIS), and others. By default, LocalDB operates in single-user mode, meaning that only one connection is allowed at a time. This is suitable for development scenarios.
There is a error while trying to import and connect database saying that to enable trust server certificate by reviewing ssl and certificate configuration How to correct this?
Hello, how can I do the process in the opposite way, a change made in the database is reflected in the visual project? How do I publish the change in the opposite way, taking into account that the project is already created, thanks
I was able to import from visual studio. I then went into the database, added a table, went back to visual studio, right clicked project, but the database was now greyed out.
Why i have azure extension for SQL server this option when im installing the SQL server? And i dont know what to do with it... i skipped that step and then when i completed install, i opened visual studio community 2022, i dont have the data connection selection on the top left corner...
thank you for this video, one of my problems has been solved... my learning of sql in asp has come to light.
No doubt, you are welcome
Thanks for the Video. easy to follow. Just got started with writing a winforms app that started as a text based config with output to text files then added database support. I was doing all my "create table" logic in SQL Server Management Studio with saved SQL files, but this is way better as I can put my project under source control in Github. Maybe I should have already know this stuff.
You are welcome
thank you so much. It helps me do my Assignment😍😍😍
@@DouglasJapheth you are welcome
Great explainer, thanks!
@@hwilkes2048 you are welcome
Thank you so much for such an informative video.
You are welcome
Thanks, that was really helpful :)
@@mikestock1848 you are welcome
Excellent! Just what I needed to get me started. Thanks for the upload 🙂
You are welcome
Thanks you a lot. saved my day.
You are welcome
This is great and I love that accent.
@@nonobrochacho240 no doubt
thanks for nice share..
You are welcome
Thanks, that was what i was looking for.
You are welcome
Thanks for this great tutorial. Why is it necessary to publish the database as in the latter part of the tutorial?
You publish it again once you make changes in code
@@hacked101 Great - thank you
@@kennywilliamm you are welcome
hi can i ask about mu problem that said
The connection properties object must be of type SqlConnectionProperties or OleDBSqlConnectionPropertiies
Is self explanatory, please follow the video carefully
Hey there,keep up the great work in your channel.
I have only a general enquiry as a newbie sql learner.
Could i channel shopify live data into an sql application?(This should be an application developed for a company of 50 employees mainly for the sake of generating reports and analytics))
Is this an easy process to undertake as a sql beginner? What should i keep in mind
and what are the tools or softwares that i should work with right from the beginning.
For notice, I made my mind to work with microsoft sql server, also our company has a dedicated server.
Thanks for taking care of my enquiry.
Thanks man🙏
You are welcome
That way very helpful, thanks.
You are welcome
This video is very useful 👌
Thanks 😊
You are welcome
How to manage deployment change into different environment like local ,dev, qa and prod?
Check out my video on SQL Server Database Deployment
@@hacked101 Thanks a lot.
Great video, the only thing is that if the project can be used for Oracle.
No doubt
finally a video that helped mi a looot! Thanks
You are welcome
Hello does Microsoft SQL Server Local Database have a storage limit of the file size or is the only limit the storage capacity of your HDD or SSD of your computer, in addition I would like to also know any restrictions or limitation of MS SQL Localdb. Thank you.
The storage capacity is essentially limited by the available storage on your computer's HDD or SSD. You can use as much storage as your disk allows. LocalDB may lack certain advanced features available in the full version of SQL Server, such as SQL Server Agent, SQL Server Integration Services (SSIS), and others. By default, LocalDB operates in single-user mode, meaning that only one connection is allowed at a time. This is suitable for development scenarios.
thank you 🙏😁
You are welcome
what do i do if importing didnt bring the table but "security" and "server objects" instead? edit: nvm i figured it out
Please make sure you select the tables you want to import
You might have solved this, tell me if did
@@DanananaDynamite i wasnt actually selecting the the database to import so i was never importing anything
There is a error while trying to import and connect database saying that to enable trust server certificate by reviewing ssl and certificate configuration
How to correct this?
There is a checkbox that needs to be checked to allow importing sensitive stuff. Please make sure you follow the video carefully
Many Thanks!
You are welcome
Great Video, easy to learn.
No doubt
please let me know that it can be connect with a program c++?
No doubt
what should I do if i want to create a new table like in 3:40 but there isn't a option to that?
Do you have sql Server installed on your computer?
@@hacked101 yes
Hello, how can I do the process in the opposite way, a change made in the database is reflected in the visual project? How do I publish the change in the opposite way, taking into account that the project is already created, thanks
Watch the video to the end
I was able to import from visual studio. I then went into the database, added a table, went back to visual studio, right clicked project, but the database was now greyed out.
Okay
Man, i'm using the 2022 version but some options you are chosing just don't apper to me. Can you help me?
What options
@@hacked101import option
How can we know the server name in the laptop?
You set the parameters when installing the server
when i add table mine says failed to retrieve server version
Please follow the video carefully
Comfortable) But how to create Database Project for MySQL 8.0 ?
Will make a video shortly
Now we won't have to install Microsoft sql server separately is it true?
You have though
Is it just me or is the audio really low? Content is good though.
Sure
could you record your voice louder its very hard to here you then again I might be going def.
No doubt
Youre the man!
No doubt cuz
cant hear anything!
🙂
Why i have azure extension for SQL server this option when im installing the SQL server? And i dont know what to do with it... i skipped that step and then when i completed install, i opened visual studio community 2022, i dont have the data connection selection on the top left corner...
Watch my video on how to download and install SQL Server