A database administrator's primary job is to protect the data. Making assumptions is a very good way to put the data at risk. Like Sgt. Joe Friday used...

The questions still says:

[font="Courier New"]You are testing an application role in SQL Server 2005. You connect with SSMS, invoke the role, and then execute various queries and stored procedures. What...

You are correct that you must use sp_setapprole to invoke the app role, but if you do this without setting the cookie you cannot revert since the cookie is what...

Again, setting the cookie is an option that is required to revert. By default this option is set to false. The question is about how to revert and...

The question never says anything about actually using sp_setapprole to create the cookie, so you can't use sp_unsetapprole to revert. I think you need to read my post again....

The answer is absolutely wrong. You can't use sp_unsetapprole because the cookie was never set using sp_setapprole. If you activate the app role before setting the cookie using...

Nice ambiguity. A schema is a container or namespace, but can't actually own an object since it is not a user. The correct answer is to assign ownership...

Andy,

I'm not sure what you mean by "standard DBA type role" since I've seen everything from a web developer maintaining the MS Access based "data warehouse" to the systems analyst...

With the topics being covered at PASS this year and last, and the opportunity to only attend one conference during the year, TechEd and the MS BI conference seem like...

Using calculated members does not decrease processing time for the cube since only the definition is stored.  It may actually increase processing time since SSAS needs to recalculate the...

Answer B is actually the most correct since MOLAP is often used for dimensions with millions of members and the note in the question author's reference supports that as...

Vista Ultimate has been running great on my Inspiron 9400 since Vista went RTM.  The wireless networking tools are so much better than in XP.  UAC was pretty annoying for about the...

I have to agree with James.  Control characters are normally represented by the small square we see when looking at a carriage return in a varchar column.  There is...

Certification may not be the best measure of whether to hire someone, but don't bash the Microsoft Official Curriculum.  In my experience these classes are taught by an experienced...

Just-in-time manufacturing plants can run without their scheduling system, but for a particular auto manufacturer I worked at in the past, being without the scheduling system would have resulted in a...