Also, stopping the SQL services properly will cause SQL server to perform a checkpoint before fully stopping, so this could take quite a while depending on several things.

If...

First, you normally don't want to give your web application authority so high that it can create the databases. This would be very bad and has huge security implications which...

The SQL error log shows the progress of the start up recovery and if it was able to roll transactions forward or backward for each database.

Large databases will take...

Steve,

How about if I make these three azure articles into a stairway starting here?

Jim

Cool. What I figured, just clarifying so you didn't get less than you bargained for.

I'll have a crack at it if you want to assign it to me.

Jim

This has a dependency with the client app/technology (.net, etc). I assume the article would avoid deploying a simple .net application too and all of it's complexity? Seems beyond...

As a consultant, I'm seeing a lot of companies going the VM path before they call out a DBA. The typical problem that I keep seeing (besides all databases except...

He is almost right, but wrong because of VM.

Non-VM, it is licensed by physical CPU socket and can use all logical CPUs which are utilizing no more than 4 physical...

You've come to the right place. Tons of gold in these forums, as wells as wonderful articles and blogs.

As a DBA, your most important job is protecting the data....

Microsoft explains it well.

http://msdn.microsoft.com/en-us/library/ms345146(v=sql.90).aspx

Jim

Amuzelog,

Yes, the design can be greatly improved, however, it is difficult to determine exactly what is needed since the example tables are very generic with no apparent relation between them....

Typically, when you get this message, you can wait 10 seconds and click Connect again and it'll work. Basically, the services are not reporting that they are starting fast enough...

Try putting the last update statement in an

EXEC (@MyUpdateSQLStatement);

...kind of thing.

If you receive an error, it is best to post it along with your question.

Since this is a sql2005 forum, I'll assume that you are attempting to use sql2000's Enterprise Manager to connect to a SQL 2005 instance of SQL server. This can not...

I have the developer edition of 2005 and the express edition of 2008r2 running in an XP virtual machine. Both instances run perfectly side by side without problems.

I installed...