http://mscrmblog.net Latest news, information and help on Microsoft Dynamics CRM, Microsoft Sharepoint Server (& WSS), Server 2003/2008 and VMWare. Wed, 25 Jan 2012 02:18:41 +0000 http://backend.userland.com/rss092 en Developer Dashboard is one of the hidden features in SharePoint 2010. It is turned off by default. Enabling this feature will help you get critical information such as Execution time, log ID, critical events, database queries, service calls, SPRequest allocation and webpart events. Developer Dashboard Modes: 'On' Mode: STSADM: stsadm -o setproperty -pn developer-dashboard ... http://mscrmblog.net/2011/07/10/sharepoint-2010-developer-dashboard/ http://mscrmblog.net/2011/07/08/failures-in-sharepoint/ sounds simple dosen't it - my objective is to run an estimate report and render to PDF all from the click of a button as shown in the screenshot below: Heres the code -- string oppID ... http://mscrmblog.net/2010/12/09/generatingrendering-a-pdf-from-a-sql-reporting-services-report-crm-4/ ahhh sql reports -- i mean come on this sounds like a simple parameter problem -- however what seems to be the problem here is that in the report i was requesting from sql srs web services for CRM4 -- you must define data source credentials with the datasource name ... http://mscrmblog.net/2010/12/09/this-report-requires-a-default-or-user-defined-value-for-the-report-parameter-parameter-to-run-or-subsribe-to-this-report-you-must-provide-a-parameter-value/ You will get this error with SQLSRS if you are using the ReportExection URL with webservices. the correct URL is: http:///reportserver/ReportService.asmx http://mscrmblog.net/2010/12/09/server-did-not-recognize-value-of-http-header-soapaction-httpschemasmicrosoftcomsqlserver200312reportingreportingservicesrender/ Adding a Page Number to a Footer To display a page number in the header or footer of a report, create a text box in the footer and add the following expression: =Globals.PageNumber & " of " & Globals.TotalPages http://mscrmblog.net/2010/10/04/srs-add-a-page-no-to-each-page/ /sbin/iptables -A INPUT -p tcp -s --dport 80 -j DROP /sbin/iptables -A INPUT -p tcp -s --dport 443 -j DROP http://mscrmblog.net/2010/10/04/linux-quickly-block-an-ip-address-from-httphttps-access-using-iptables/ MySQL: Running a SQL script from the command line: mysql mydatabase -u -p < /home/mysqlscript.sql MySQL: Stopping a long query: mysqladmin processlist Get the id from the first column then run: mysqladmin kill http://mscrmblog.net/2010/10/04/two-quick-mysql-tips/ c:\windows\system32\oobe\msoobe.exe /a http://mscrmblog.net/2010/10/04/activating-windows-shortcut-command/ Paste the following into the powershell command prompt: Get-MailboxStatistics -Database "mailbox database" | Sort -Property DisplayName | ft DisplayName, @{expression={$_.totalitemsize.value.ToMB()};label="Mailbox Size(MB)"}, itemcount > c:\mailboxes.txt a text file located at c:\mailboxes.txt should now contain the mailbox size information with item counts for each user. http://mscrmblog.net/2010/10/04/get-mailbox-sizes-in-exchange-2007-using-powershell/