This is not something I've attempted myself, but there is documentation on how to set it up available on MSDN. That includes a step by step process along with the...

The only way to achieve anything like this is a combination of code and database design, regardless of your data platform. You're going to have to have an application server...

muralikrishna2489 (1/7/2015)

---

Hi Gila,

I dont know how to put a execution plan in SQL. I have created in Doc and attached.

Regarding UNION ALL, I was advised that Since both Changes and...

I have not set up a failover cluster using an Azure VM. I have set up an Availability Group and put individual databases into it. It does support the full...

One other point, I'm not sure what industry you're working in, but many, especially healthcare, now have criminal penalties if you expose personal data to people without permission or a...

Yeah, Sean makes an excellent point.

Remember, you're not building a backup plan. You're building a recovery plan.

If you want to use the dynamic management views to look for currently executing queries or procedures, instead of going off of sys.dm_exec_procedure_stats (or sys.dm_exec_query_stats), I'd suggest using sys.dm_exec_requests. That's...

The view is a good approach.

You could also look to adding an additional join to a table that lists the data you want (or don't want, I'd probably go...

What's the concern with taking more frequent full backups? Or maybe differentials?

The thing is, it's not just a question of backing up, it's also a question of restoring. When you...

And a Happy New Year to you as well. Seriously hoping to...

I'm just subscribed to all of it forever. Too much work to try to clean it out. If any one thread gets stupid (this one for example), I'll remove that...

Turn that around. You should only supply them a backup that has clean data. What's to keep a bad person from just taking the backup offsite and doing what they...

You can look at sys.dm_db_index_usage_stats to see how, or if, the index is being accessed. Just note that the statistics are reset if the server is restarted, or the database...

Yeah, he was almost pretty once. Almost.

There's no way I know of to disable menu options inside of SQL Server Management Studio. The tool is what it is. Permissions given within a server instance will allow...