June 16, 2011 at 7:29 am
Hi everyone,
I am interested to learn about SQL Server, so basically I download the express verssion to learn.
Qs1: I repeated the downloading process quite a few time by running SQLEXPR.exe but I cant seems to locate it so that I can run it and start creating databases, tables things like that.
Qs2: For a newbie, anyone got books to recommended? Down to the level for pure novice (say I know nuts about DDL, DML etc etc, schema)
Nikeman
Just do It
June 16, 2011 at 7:37 am
Try downloading it instead of running it from your browser. I think that's what you need to do to get it going.
In terms of a book to start out with, SQL for Dummies is probably a good place to start. I started out with Paul Nielson's "SQL 2000 Bible" (you'd want the current version, of course), and found that extremely helpful. When I started out, I was at the level of "If a database is what I think it is, it's probably what I need for this project", and it worked.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 16, 2011 at 8:46 am
Hi,
Much appreciate your response.
I had tried downloaded the *.exe file to my c:/program files, and promptly run the setup.exe from there though.
Nikeman
June 16, 2011 at 9:12 am
SQL Server Express is a program that has to run on your machine as a service. You download the installer and then it will set up a new service and the SQL Server Engine.
In terms of a basic book, and of the basic books on SQL Server (SQL 2005 Administration, Unleashed, For Dummies, etc) will give you a basic understanding. If you are looking to better understand schemas, DML, and T-SQL, I might recommend SQL in a Nutshell (Kevin Kline) as a good basic SQL book.
June 17, 2011 at 6:01 am
Steve Jones - SSC Editor (6/16/2011)
SQL Server Express is a program that has to run on your machine as a service. You download the installer and then it will set up a new service and the SQL Server Engine.In terms of a basic book, and of the basic books on SQL Server (SQL 2005 Administration, Unleashed, For Dummies, etc) will give you a basic understanding. If you are looking to better understand schemas, DML, and T-SQL, I might recommend SQL in a Nutshell (Kevin Kline) as a good basic SQL book.
Hi Steve,
Thanks for replying, running as a service- understood.
However how do I create database using SQLExpress?
June 17, 2011 at 6:26 am
You'll need to download and install SQL Server Management Studio. (Well, honestly, there are other ways to do this, but that's by far the easiest.)
That will give you an interface for creating, administering, programming, etc., databases.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 17, 2011 at 10:06 am
Management Studio Express: http://msdn.microsoft.com/en-us/library/ms365247.aspx
June 18, 2011 at 1:25 am
Steve Jones - SSC Editor (6/17/2011)
Management Studio Express: http://msdn.microsoft.com/en-us/library/ms365247.aspx
Hi Steve,
I manage to download, when I open the applications, it prompted me for server name (I dont have any currently as I am running on my home pc) so pressing cancel.
Thus I left with no screen to create a db, pardon me but if I were to create a dummy server how would it be?
Any site to guide would be much appreciate.
Nikeman
June 18, 2011 at 9:50 am
The server name is your machine name.
For express, it's often machinename\SQLExpress. You should be able to scan for them.
June 20, 2011 at 5:59 am
You can also try server-name "(local)". With parentheses, not with quotation marks.
If you need to find the server name, check what services are running on your machine. You're looking for "SQL Server" and the instance-name will be after that. If it has, "SQL Server (MSSQLSERVER)", that's the default instance, and will connect using "(local)". If it has, for example, "SQL Server (INSTANCE2)", and your computer is "MyComp", then the server-name would be "MyComp\INSTANCE2".
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply