I'm brand new to this. SQL 2014 Express automatically wants me to connect to a sever, but I want it to be local. Because I'm not connecting to another server, it will not allow me to create a new database. How can I create a new DB from Scratch? I can't seem to find any answers anywhere.
Daniel Gregory when installing the the sql server, section server configuration you should do it manually, next to DATABASE ENGINE, UNDER ACCOUNT NAME click browser ---> choose advance --> then click find now ---> choose NETWORK SERVICES. For any other feature do the same and set it to LOCAL SERVICES
I seem to have downloaded several copies of Microsoft SQL server (2008, 2012 AND 2014!) but I can't seem to find any executable program in any of the multiple folders called 'Management Studio'. Am I looking in the wrong place?
Hi kash. Great Stuff. I went onto the website and would like to purchase this series of videos. Would you be able to direct me to it? I went to check out the sample videos, and i could only find 2012 sql server videos. I was afraid that I would purchase the 2012 series instead of the 2014 series.
I appreciate this tutorial but you haven't actually told me anything of substance - like Why would I use Register Servers. You did say when I would use them (prod vs dev). Also, what if I don't currently have db loaded (like adventureworks). The assumption in this video is that everything is already loaded? I have the same problem with MSDN tutorial. Even so, I'll look at another video tutorial to see if there is more info.
Apparently when you install SQL server 2016 the SSMS dose not auto install you have to go to this link: msdn.microsoft.com/library/mt238290.aspx to get the installation file for ssms
Just wanted to say thank you! Keep the videos coming.
plz make a playlist of your videos.
plz make a video playlist for advance Ms- sql server training related to live projects
Good stuff Kash. Thank You
Thank you for the comments...Plz SUBSCRIBE to our channel!
Just need buddy, thanks again
Good tutorial! ssms is a great tool but have you tried dbforge Studio?
Help I do not see the development tab I only have local server groups and central management services
When reviewing the videos, I noticed SQL Server 2012 not SQL Server 2014.
I'm brand new to this. SQL 2014 Express automatically wants me to connect to a sever, but I want it to be local. Because I'm not connecting to another server, it will not allow me to create a new database. How can I create a new DB from Scratch? I can't seem to find any answers anywhere.
Daniel Gregory when installing the the sql server, section server configuration you should do it manually, next to DATABASE ENGINE, UNDER ACCOUNT NAME click browser ---> choose advance --> then click find now ---> choose NETWORK SERVICES. For any other feature do the same and set it to LOCAL SERVICES
I seem to have downloaded several copies of Microsoft SQL server (2008, 2012 AND 2014!) but I can't seem to find any executable program in any of the multiple folders called 'Management Studio'. Am I looking in the wrong place?
Sorted now
Cool, here is the location also
"C:\Program Files\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"
Check Tools inside the software. it should have three options.
Hi kash. Great Stuff. I went onto the website and would like to purchase this series of videos. Would you be able to direct me to it? I went to check out the sample videos, and i could only find 2012 sql server videos. I was afraid that I would purchase the 2012 series instead of the 2014 series.
Thank you for the comment, plz subscribe and like our videos.
Sorry but the videos are not ready yet, had a family member passing away.
very nice
Can anybody help me with this problem
List ProductId for products that are in the top 10 percent of most ordered (OrderQty) products.
Try this
SELECT PRODUCTID, SUM(OrderQty) GROUP BY PRODUCTID
I appreciate this tutorial but you haven't actually told me anything of substance - like Why would I use Register Servers. You did say when I would use them (prod vs dev). Also, what if I don't currently have db loaded (like adventureworks). The assumption in this video is that everything is already loaded? I have the same problem with MSDN tutorial. Even so, I'll look at another video tutorial to see if there is more info.
Ah, my mistake. The intention of this video is to promote your tutorials that are for sale.
I installed SQL Server 2016 on my windows 10 but I do not see a program called SQL server 2016 managment studio. can anyone help
Apparently when you install SQL server 2016 the SSMS dose not auto install you have to go to this link:
msdn.microsoft.com/library/mt238290.aspx
to get the installation file for ssms