My approach is to design the database with restrictions in place to begin with.  Use roles to restrict what data a user is allowed to access.  I expect (ie hope)...

Might not hurt to check out the Exchange error logs and see what those say.  Could be something that is easily corrected by reviewing the logs on the other side...

SSRS Standard, as far as I am aware, doesn't support clustering and only allows you to host it on 1 server.

I believe you would need to upgrade to Enterprise to...

You could use ISNUMERIC.

Personally, if I COULD I would be changing the application that puts the data into the system to validate it and refuse to store invalid data.

Failing that,...

I've been noticing this too.  Hopefully it gets fixed soon.

I DO get notifications to new private messages, but not to replies to forum posts...

Alternately, if you don't have a VS subscription, you could reach out to the company you purchased SQL Server 2012 from and they should be able to provide you with...

My opinion - I would do whatever works best for the tool you are using.  BUT I would also be careful about using a tool to monitor SQL error logs. ...

My advice - review the error and check the logs.

The error should tell you what is wrong, and in the event it doesn't, the logs should tell you what is...

Things that I would check are:

1 - does the service account have permissions to the folder AND file?

2 - does any other application or service have the file open at...

With our system, we had turned on successful login logging on one of our systems and had a HUGE performance hit to the database.  The problem was caused by how...

Without seeing an execution plan or ddl, I the below are just guesses.

Depending on the number of rows returned by your nested select, you may get better performance by changing...

Have you tried opening the master key by password and adding encryption by service master key?

GitHub.

GitHub has a LOT of open source projects that are looking for more developers.  It is generally unpaid work and the code owner could change the license and make it...

Not sure if it is just me or not, but I don't see what the data is supposed to look like...

BUT based on what you posted, I am thinking that if...

This to me looks like a homework type assignment or possibly an interview question, but I'll try to help without giving the answer away.

So my first step would be to...