The idea is not bad. It needs to monitor all services, SSIS, SSRS, SSAS and multiple named instances.

http://www.sqlsaturday.com/308/Sessions/Details.aspx?sid=17746

http://www.sqlsaturday.com/308/Sessions/Details.aspx?sid=17746

http://www.sqlsaturday.com/308/Sessions/Details.aspx?sid=17746

http://www.sqlsaturday.com/308/Sessions/Details.aspx?sid=17746

However, the bulk-logged recovery model increases the risk of data loss for these bulk-copy operations, because bulk logging operations prevents recapturing changes on a transaction-by-transaction basis. If a log backup...

http://dbace.us/repriser/houstonsqlpassvideo.html

SQL Saturday #308

You lose some flexibility with that linkserver:-D

Index rebuild online is only available in Enterprise Edition

http://msdn.microsoft.com/en-us/library/cc645993.aspx

Online does not mean it does not lock. It is "almost online".

Rule of thumb:

5%-30% fragmentation - use reorg

30%-100% fragmentation -...

1) You can see how I used Powershell to accomplish this kind of things from one centralized server pulling at SQLSaturday#308.

2) If the VBScript agent has to be delivered to...

http://dbace.us

Actually on SQLSaturday#308, I will show you how to generate a restore script from MSDB using T-SQL.

I wrote this and use it for many years on many jobs.

Two...

"Both" will be great.

Microsoft SharePoint team needs to communicate with SQL Server team, vice versus. Parallelism is a good feature to use, not to surppess.

Definitely. I agree with everything in this article. I am glad Erin writes this article as DBA best practice guide.

Alternatively, you could record troubled server by checking counters for CPU,...

If you don't want to distribute so much memory on SQL Server usage, just lower the Max memory. You can also issue commands to clear buffer and procedure cache in...