Common SQL Server Myths by Paul Randal

  http://www.sqlskills.com/blogs/paul/CommonSQLServerMyths.pdf This is a very good article by Paul – interesting read..  Enjoy! Similar blog post by CSS SQL Server Engineers at Microsoft – http://blogs.msdn.com/b/psssql/archive/2007/02/21/sql-server-urban-legends-discussed.aspx  — an interesting read as well. 

0

How to turn Reporting Services Features such as–Schedule Events and Report Delivery and Web Service and HTTP Access–On or Off

According to SQL CAT team article on best practices consideration on RS-Scale out deployment – http://sqlcat.com/technicalnotes/archive/2008/10/21/reporting-services-scale-out-deployment-best-practices.aspx “..To isolate your workloads, set your scheduling Reporting Services servers to Schedule Events and Report Delivery Enabled, and set your interactive Reporting Services servers to Web Service and HTTP Access Enabled. By default both options are enabled, so make…

0