Working With SQL Server Developer Edition [closed]


Working With SQL Server Developer Edition [closed]



I just bought Visual Studio 2008 Professional and it came with SQL Server 2005 Developer Edition. I'm used to using SQL Server 2005 at work, but the Developer edition doesn't seem to come with Server Management Studio, so I'm at a bit of a loss. A few questions:

  1. What resources are there for configuring and setting up SQL Server 2005 Developer Edition?
  2. What are some resources for managing databases (I know that I can have Multiple Databases with SQL Server 2005), and what 'extras' are provided by Developer Edition?
  3. Are there any funky things I need to know about if I were to create a database and move it from Developer Edition to an actual deployment server?
  4. Are there any other 'gotchas'?


Edit: I've answered the 'Why isn't SQL Server Management Studio showing up' question below. Resources for the other questions are still appreciated.

Any other insights?




Is performance hit hard when you reinitialize a subscription in sql server 2005

1:



SQL Server script: ALTER PROCEDURE - Executing multiple ALTER PROCEDURE into one script without having to select each of the ALTER one after another
OK, If you actually have the full Developer edition on SQL2005 it does have SSMS with it, you just didnt choose that option in the install..
created persisted computed columns when the user defined scalar function appears to be non-deterministic
What is more likely is that you installed SQL 2005 Express Edition which does not include SSMS.
How to temporarily disable the log in SQL2000/2005?
(SSMS = SQL Server Management Studio).
SqlServer 2005: deadlock problem with no shared records
To manage your SQL instance you should download SQL Server Management Studio Express from here http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en.
SSIS 2005 XML Validation Failure Logging
keep in mind that Express installs with an instance name so your server will actually be MACHINENAME\SqlExpress by default..
SQL Server 2005 “FOR XML PATH” Grouping
And SQLExpress databases are exactly the same as regular SQL Server - the db engine just has limitations when you are running Express..
How to bulk insert into a table in sql server 2005
Good luck..


2:


It does come with SSMS and BIDS but it may not install them by default.

Re-run the installer and make sure the 'workstation' (IIRC) bits are installed.

.


3:


It turns out that installing SQL Server 2005 Developer Edition on a system that also has the Express Edition requires that the user run the setup from the commandline like so:. D:\SQL Server x86\Servers\setup.exe -SKUUPGRADE=1. The other questions are still open to be answered, however..


4:


Developer Edition contains all the features that Enterprise has (or at least most of them).

This can be bad if you do not realise.. Some predecessors of mine finished a nice project that required the use of partitioned tables to greatly speed up our creaking DB.

It worked a charm.

A couple of weeks before deployment it got pointed out that only the Enterprise edition supported partitioned tables.

They had to go cap-in-hand to the CFO and the CEO asking for about £16,000 in additional licencing costs..



83 out of 100 based on 43 user ratings 743 reviews