.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

PPS vs StrategyCompanion Analyzer

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :SharePoint

Hi All,

I am using PerformancePoint in SharePoint 2010 to do the BI visulization, but I don't know people talk about the StrategyCompanion Analyzer to do the same thing, I am not sure what's the difference between them, or any benifit to select StrategyCompanion analyzer?

From the Analyzer's demo,  I can see I can do that in PerformancePoint as well, why we need Analyzer?


View Complete Post

More Related Resource Links

Microsoft StyleCop: Source Code Analyzer for C#

StyleCop is similar in many ways to Microsoft Code Analysis (specifically FxCop), but there are some important distinctions. FxCop performs its analysis on compiled binaries, while StyleCop analyzes the source code directly. For this reason, FxCop focuses more on the design of the code, while StyleCop focuses on layout, readability and documentation. Most of that information is stripped away during the compilation process, and thus cannot be analyzed by FxCop.

Utility Spotlight: 12 Steps To Faster Web Pages With Visual Round Trip Analyzer


Download Visual Round-trip Analyzer (VRTA) to uncover the root of your Web page loading problems and identify these 12 common ailments.

Jim Pierson

MSDN Magazine November 2008

Extreme ASP.NET: Tools of the Trade: SQL Server Profiler and Query Analyzer


In my last column, I discussed Microsoft® Application Center Test and how it could be used to measure the performance of your Web application (see Extreme ASP. NET: Tools of the Trade: Application Center Test).

Rob Howard

MSDN Magazine August 2005

Health Analyzer reports "Product / patch installation or server upgrade required." and I can't seem

The text of the error is: On server SHAREPOINTSERVER, once all required products and/or patches are installed, perform an upgrade by either running PSConfigUI.exe or by executing the command "PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures". If a former upgrade attempt has failed, you may need to resolve upgrade specific issues before attempting upgrade again. Refer to the upgrade status page (http://sharepointserver:XXXX/_admin/UpgradeStatus.aspx) for information about current and prior upgrade attempts, and to determine issues that may be preventing upgrade from succeeding. For more information about this rule, see "http://go.microsoft.com/fwlink/?LinkID=142700". So I went to the server in question and ran the command line quoted in the error message and then I get this error back: Configuration of SharePoint Products failed. Configuration must be performed before you use SharePoint Products. For further details, see the diagnostic log located at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\1 4\LOGS\PSCDiagnostics_....log and the application event log. So fine, I look into the event log and get this: Failed to initiate the upgrade sequence. An exception of type System.IO.IOException was thrown. Additional exception information: Access to the path 'C:\ProgramData\Microsoft\SharePoi

Query Analyzer

Hi, I encountered a problem which the result different compare in query analyzer with result calling from user-defined function. I describe more on my problem. I have a stored procedure name SP1 and a user-defined function name Function1. When I copy out the Function1 run in query analyzer, the result is as my expected. While when the SP1 call Function1, the result is wrong. And I double check the code at both side are same. And even I copy the code at query analyzer which return correct result to the Function1. But the result still wrong. Anyone know why? Thanks.   Regards, ling      

Health Analyzer - Missing server side dependencies errors after doing in-place upgrade

I have a SharePoint 2010 application server & web server. After performing an in-place upgrade, I get the following errors in my Health Analyzer - Missing server side dependencies:   [MissingFeature] Database [Intranet_WSS_Content_Corporate_11000] has reference(s) to a missing feature: Id = [3fbd49d6-a25a-4f2f-89d6-1b0fd979435b]. The feature with Id 3fbd49d6-a25a-4f2f-89d6-1b0fd979435b is referenced in the database [Intranet_WSS_Content_Corporate_11000], but is not installed on the current farm. The missing feature may cause upgrade to fail. Please install any solution which contains the feature and restart upgrade if necessary. [MissingFeature] Database [Intranet_WSS_Content_Corporate_11000] has reference(s) to a missing feature: Id = [03ccceb8-6c39-4b02-870a-41ef6a93979d]. The feature with Id 03ccceb8-6c39-4b02-870a-41ef6a93979d is referenced in the database [Intranet_WSS_Content_Corporate_11000], but is not installed on the current farm. The missing feature may cause upgrade to fail. Please install any solution which contains the feature and restart upgrade if necessary. [MissingFeature] Database [Intranet_WSS_Content_Corporate_11000] has reference(s) to a missing feature: Id = [747755cd-d060-4663-961c-9b0cc43724e9]. The feature with Id 747755cd-d060-4663-961c-9b0cc43724e9 is referenced in the database [Intranet_WSS_Content_Corporate_11000], but is not insta

Highlight Opening and Closing Parenthisis in Query Analyzer 2008

I'd like to have my parenthisis highlighted when I select either the opening or closing one. How do I turn that ON?

SQL Server 2008 - Best Practices Analyzer

Is there a version of SQL Server 2008 Best Practices Analyzer available for download?   If not, can I use BPA for SQL Server 2005 to run a DB assessment on a SQL Server 2008 database?  Please let me know what your recommendation is?


different results return from .NET and sql query analyzer



Below is my code how to get the records from a stored procedure. I can get the correct results from sql query analyzer, but less results in .NET. Why it happened? How to solve it? Thank.

strSQL = "EXECUTE sp_Collection '" & strRECID &"','" & strPayPeriodFrom & "','" & strPayPeriodTo & "','" & intPayDays & "' "

objDB = DatabaseFactory.CreateDatabase()
            objDS = objDB.ExecuteDataSet(CommandType.Text, strSQL)

objDB = DatabaseFactory.CreateDatabase()

 objDS = objDB.ExecuteDataSet(CommandType.Text, strSQL)

*NOTE: connected to correct database

Beseline Configuration Analyzer Error


Hi Folks,

I was trying to get analysis by Microsoft Baseline Configuration Analyzer 2.0 for our SQL Server 2008 installation using SQL Server 2008Rs BPA.
Now, I am running this BCA from my workstation, so I am selecting "connect to another computer" option, I am sure that I am administrator of that remote machine and this local machine. But to be sure, I feed my ID and PWD in required fields too.
After this much configuration when I try to run BPA, it gives me error

The specified module "baselineconfigurationanalyzer" Was not loaded because no valid module file was found in any module directory

I have checked that everything is 64bit (my workstation, remote server, BPA). I have also setup WinRM to accept remote connection to remote server. I tried to google this error but it seem that nobody had this before (or it displays lots of wrong results because of my long string)

Is there any suggestion for me ??


Looking for Client Query Analyzer (SQL Server 2008) or Equivalent Reporting Tools


I've recently upgraded from SQL Server 2000 to SQL Server 2008.  My accounting and marketing team is skilled and has been using SQL Query Analyzer for years to run smaller queries and build small Crystal Reports.  Unfortunately Query Analyzer is now bundled into the management studio.  That's a bit too much software for this level of power users.

Is there a client-side query analyzer for SQL Server 2008?  I'd rather use a Microsoft product than a 3rd party tool, but I suppose I could do that too.  Looking for something simple that will:

1.  Show users the database tables and/or views

2.  Run queries

Perhaps query analyzer isn't the way to go and my team needs a different reporting system.  If this is the way MS is heading, could you direct me towards a product or service that allows power users to get the information they need?  They will still need to look at raw data to build Crystal Reports though.

SQL Server 2008r2 Best Practice Analyzer report error


Hi All,

recently I was playing with SQL Server 2008r2 BPA. I have installed Baseline Configuration Analyzer in my workstation and my server has BPA installed.

Now when ever I try to run analysis on my workstation. I always get following errors,

1. User is not a member of Administrators group on remote machine, OR

2. Powershell Remoting is not Enabled on Remote Server


Now I am sure that I am Admin of that server machine and I have enabled the PS Remoting (because when I try to rerun the commands to enable remoting in PS it says it is enabled). Also, I can run BPA on my server if I run it locally (by logging into the server m/c).

If any one has any suggestion, I will really appreciate it.



Microsoft Baseline Configuration Analyzer 2.0 IA64 support?


I am trying to run SQL Server BPA against a SQL Server 2008 R2 instance on Server 2008 r2.  It is IA64. 

Is MCBA not supported IA64?

thank you

Sharepoint: Health Analyzer has detected some critical issues that require attention "Severity 1"


·           I have been struggling with this issue for a few weeks, if anyone can help me resolve it, it would be so appreciated. I am currently running SharePoint 2010 Foundation on Windows Server 2008 R2. 




Sharepoint: Health Analyzer has detected some critical issues that require attention, doesn't allow


I have been struggling with this issue for many days, if anyone can help me resolve it, it would be so appreciated. I am currently running SharePoint 2010 Foundation on Windows Server 2008 R2.

I had set-up a SharePoint foundation Extranet web portal on a single server configuration (one computer) and it was functioning just fine. I moved the server to another physical location to demo it, I connected it the same way I do at my home but at this location it was on a  different internet service provider. As soon as I connected the server thru the Ethernet port to to cable modem box I immediately got a "Health Analyzer error" in the SharePoint Central Administration Window and all my ports (port 80 and 8080) were blocked.

I returned back to my home and reconnected the server computer to my home modem in the same exact way I did before (when it was functioning) and the "Health Analyzer error" in the SharePoint Central Administration Window still is displayed and all the Extranet/internet ports (port 80 and 8080) are still blocked.

I checked on the server using the "IIS manager" and the sharepoint site still functions fine on the server. Problem is I cant access it anymore from the Extranet/internet due to the ports being blocked now.

The Healt

SharePoint Health Analyzer Alert: Application Pool Memory Limit


I receive the below alert in the SharePoint Health Analyzer alerts. Looking at the application pools on my WFE (and my app server), nothing is configured to have a memory limit. I'm wondering if this is maybe a permission issue? My permissions appear to be the same as my other 2010 farm, which does not have this issue and the same setup steps were taken. I don't see any messages in the event log on either server that look to be related.

Has anyone else seen this and resolved it? Or do you have any other tips for things I can look into to resolve it? Thanks in advance.


Application pools recycle when memory limits are exceeded.


0 - Rule Execution Failure




Web Application Configuration Analyzer 2.0

The Web Application Configuration Analyzer (WACA) is a tool that scans a server against a set of best practices recommended for pre-production and production servers. The list of best practices is derived from the Microsoft Information Security & Risk Management Deployment Review Standards used internally at Microsoft to harden production and pre-production environments for line [...] Read More......(read more)
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend