An alternative may be to use the auditing features? You can't making it possible to fully administer the database while making it impossible to read the data, but...

Based on this error, I'd suspect

1) The Maximum Memory setting is ridiculously low (the setting in SSMS is in MB)

2) I also see an option to set Index creation memory....

This is likely due to security restrictions on the email server designed to prevent other servers from being used as spam robots. Try bringing this up with administrator...

Jeff Moden (8/12/2014)

You forgot some important points such as abstraction and performance. 😉 And not just performance of the code, either. A stored procedure that provides the correct...

There is no right or wrong answer to this question.

The advantage of accessing data through storied procedure only include

1) Security. If a user is in db_datareader role...

SQL and T-SQL may not technically be exactly the same thing, but they are often used interchangeably and people reading a resume may not be clear on the distinctions. If...

If that's required to make a SQL instance installed before joining a domain function with other network resources just like one installed on a domain member server that's great.

Someone needs to have permission on the stored procedure otherwise only sa or someone in the db_owner role will be able to run it. The usual procedure is to grant...

Back to the topic of dealing with agencies.... I've only worked before as an FTE with benefits. Although I've talked to staffing agencies before, I have taken contracting...

Classic left-hand/right hand situation.

The left hand can't figure out why SQL Server Database Mail doesn't work, and the right hand can't figure out why an anti-virus program alarms like crazy...

I may have said this earlier and I'll say it again - if mail won't send and you know the settings are correct because they match a different server that...

If you're just starting with certifications, why not start with an exam on a product you have experience with already? Since these exams assume 1-2 years of experience,...

The distinction doesn't make a lot of sense to me either.

My impression is that a DBA would be skilled in installation, backup/restore, security configuration and other Administrative functions, but not...

To be honest, if you can pass the 70-461 Exam by August 1 after knowing nothing about on July 1 then you should be your boss's boss.

Still, it is worth...

Turning off all firewalls will allow you to move through the exercises more quickly because you won't have to deal with firewall issues. I believe for the most...