You probably did not give access for this user to Midas DB. Add this user Public rights to the Midas DB.

Once you have done that, in the DB node (Midas),...

I second that notion. 😀

And thanks for the info Grant. Never knew that...

It depends on what you are planning to do with the user that was created. The best way would be to add the user to a role and then give...

We do not give anyone access to our production DB. None of the DBA will allow any developer to have access to the production DB. Especially security. DBA know what...

For me the rule is

NEVER put the website (Even if it is Intranet) on the same box as a DB Server.

When allocating a server (For Web or for DB)...

Our QA IPSAN has always been slow. Our production SAN is very very quick. But I dont want to take a risk right now with out testing the VMWare very...

If you set the Mode in 2000 compatability, you wont get any gain from the SQL 2005. It will be working just like any other 2000 DB.

I have the same...

We are on an IPSAN for the QA. Min Disk space 600 Gig for virtual machine. When we do a restore it takes way too much time. Sometimes it does...

I am not sure if you are talking about auditing or data integrity. If it is data integrity, you can acheive it by using transactions. Use primary key and foreign...

I am not an expert in replication but snapshot replication is done on specific tables that you choose.

Steve has put it better than me..:-)

Your ides about how to get knowledge in SQL DBA work seems to be pretty good.

Setting up a test Server and doing some pet projects will definetly help you....

Embedded SQLs are SQLs that are written directly in the application code. Usually a programmer will access the database using Stored Procs, but some of them writes the SQL code...

We have been experimenting with VMWare on our QA. I cannot give any good feedbacks on it.

The performance kinda sucks. (Atleast in our set up)

Embedded SQLs are SQLs written in the Application code itself. Usually everyone writes stored proc and calls them from application but some programmers like to code the sqls in the...