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.
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?
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.
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.
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
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
Excellent! Just what I needed to get me started. Thanks for the upload 🙂
You are welcome
Thanks, that was what i was looking for.
You are welcome
This is great and I love that accent.
@@nonobrochacho240 no doubt
Thank you so much for such an informative video.
You are welcome
This video is very useful 👌
Thanks 😊
You are welcome
finally a video that helped mi a looot! Thanks
You are welcome
Thanks, that was really helpful :)
@@mikestock1848 you are welcome
That way very helpful, thanks.
You are welcome
Thanks you a lot. saved my day.
You are welcome
thanks for nice share..
You are welcome
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.
Great Video, easy to learn.
No doubt
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
thank you 🙏😁
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.
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
Many Thanks!
You are welcome
Great video, the only thing is that if the project can be used for Oracle.
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
Youre the man!
No doubt cuz
when i add table mine says failed to retrieve server version
Please follow the video carefully
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
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
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
@@sesame9020 i wasnt actually selecting the the database to import so i was never importing anything
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.
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
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
Is it just me or is the audio really low? Content is good though.
Sure
How can we know the server name in the laptop?
You set the parameters when installing the server
please let me know that it can be connect with a program c++?
No doubt
Now we won't have to install Microsoft sql server separately is it true?
You have though
Comfortable) But how to create Database Project for MySQL 8.0 ?
Will make a video shortly
could you record your voice louder its very hard to here you then again I might be going def.
No doubt
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