What role will BI play and how will BI change in the new era of ubiquitous computing?
BI is evolving from its roots as a point solution for business analysts to playing a significant role in transforming businesses to be able to respond to new competitive pressures. In anticipation of an economic recovery, businesses are shifting their focus from survival to revival and investing in infrastructure modernization. Business priorities are driving a new generation data warehouse and BI environment.
Based on HP research and experiences with Global 1000 companies, HP has examined and identified the top 10 trends in business intelligence for 2010. Read about new technologies that will shape BI in the future, including cloud computing, semantic technologies, advanced analytics and social computing. Learn where companies are focusing their BI investment.
Download our free white paper now.
VTL Consulting's expertise on design infrastructure, architecture and implementation for Dynamics ERP, Business Intelligence and AI Data solutions. Our infrastructure and architecture solutions focus on-premises and Highly Secure, Reliable, and Scalable Cloud solutions with Azure and AWS. Website: www.vtlconsulting.net Phone:(949) 415-8851 Email: info@vtlconsulting.net
Monday, February 22, 2010
Friday, February 19, 2010
FAST for SharePoint 2010... What You Need to Know - February 23rd 2010
FAST for SharePoint 2010... What You Need to Know - February 23rd 2010
This FREE one-hour webcast offers a deep dive into the exciting new features and architecture of FAST for SharePoint 2010, with many live demos throughout the presentation.
Join Jeff Fried, Senior Project Manager at Microsoft for an in-depth look at the capabilities of Microsoft high-end search technology. Jeff will present how FAST enables a rich "conversational" user experience, and will breakdown the features targeted to end-users, IT professionals, and developers. Topics covered will include:
- Customizable content processing
- Automatic entity extraction
- Configurable relevance ranking
- User context
- Architecture and administration
- And more!
At the end of the event we will officially launch our new webcast and blog series about Microsoft Enterprise Search 2010, and invite you to subscribe to learn about a new in-depth topic every week.
Sponsor: Microsoft and BA-Insight
When: February 23rd 2010
USA at 2pm EST - Register Now: https://www2.gotomeeting.com/register/165961707
Europe at 1:00 PM GMT - Register Now: https://www2.gotomeeting.com/register/424143203
This FREE one-hour webcast offers a deep dive into the exciting new features and architecture of FAST for SharePoint 2010, with many live demos throughout the presentation.
Join Jeff Fried, Senior Project Manager at Microsoft for an in-depth look at the capabilities of Microsoft high-end search technology. Jeff will present how FAST enables a rich "conversational" user experience, and will breakdown the features targeted to end-users, IT professionals, and developers. Topics covered will include:
- Customizable content processing
- Automatic entity extraction
- Configurable relevance ranking
- User context
- Architecture and administration
- And more!
At the end of the event we will officially launch our new webcast and blog series about Microsoft Enterprise Search 2010, and invite you to subscribe to learn about a new in-depth topic every week.
Sponsor: Microsoft and BA-Insight
When: February 23rd 2010
USA at 2pm EST - Register Now: https://www2.gotomeeting.com/register/165961707
Europe at 1:00 PM GMT - Register Now: https://www2.gotomeeting.com/register/424143203
Top Ten Trends in Business Intelligence 2010
Top Ten Trends in Business Intelligence 2010
ARCHIVE NOW AVAILABLE ON-DEMAND:
Click here to view the event
Attend the event at the link provided above.
Click here to download the Top Ten Trends for BI 2010 white paper.
https://event.on24.com/eventRegistration/EventLobbyServlet?target=registration.jsp&eventid=190820&sessionid=1&key=047FC45BD2D871EB918D2A38C1BE5B11&sourcepage=register
ARCHIVE NOW AVAILABLE ON-DEMAND:
Click here to view the event
Attend the event at the link provided above.
Click here to download the Top Ten Trends for BI 2010 white paper.
https://event.on24.com/eventRegistration/EventLobbyServlet?target=registration.jsp&eventid=190820&sessionid=1&key=047FC45BD2D871EB918D2A38C1BE5B11&sourcepage=register
Wednesday, February 17, 2010
SQLSaturday returns to Redmond, WA, Saturday, June 12, 2010, in the Microsoft Commons
Welcome to SQLSaturday #43
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Jun 12 2010 at Building: THE MIXER, 15255 NE 40th Street, North Commons, REDMOND, WA 98052.
Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleages know about the event.
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Jun 12 2010 at Building: THE MIXER, 15255 NE 40th Street, North Commons, REDMOND, WA 98052.
Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleages know about the event.
Tuesday, February 16, 2010
Looking for Dynamics AX Software Developer
VTL Consulting is the system integrator for the Microsoft platform, Application Development, Application Maintenance, and Infrastructure Operations services to a variety of clients utilizing the broad spectrum of Microsoft-based technologies and tools.
As a Dynamics AX Software Developer, you will be working with the IT team to modify existing and design brand-new reports. You will define and execute activities to ensure all project deliverables meet customer expectations as they are created. You may also have some responsibility for sales planning, helps to identify client needs and assists to develop the proposal and supports the sales promotions at clients.
Responsibilities:
Understanding the Software Development Lifecycle (SDLC)
* Facilitate Artifact Review/Inspection meetings
* Add new AX features if needed
* Design and develop new reports using SQL Server Reporting Service (SSRS)
* Understand and participate in SDLC
* Work with all SDLC related teams and resolve conflicts surrounding issues and resolutions.
* Articulate the value QA adds to all phases of the SDLC
* Own Reporting Planning and Development Tasks with minimal supervision
* Design, create, edit and update existing reports
* Develop a high-performing AX and SQL reports, motivated work group by applying interpersonal communication and collaboration skills to achieve project goals and realize value.
* Help to identify client needs to support the sales effort.
Qualifications
Minimum Requirements:
Consulting Project Experience
* Familiarity with the entire life cycle of a development project
* Resolving conflicts between projects
* Reporting status to customers and sponsors
Technical Experience:
*Demonstrated expertise using Dynamics AX, Visual Studio.NET, C#, .NET and SQL in all aspects of the software development lifecycle
*C# test automation coding
* Enterprise custom software development experience
Project management methodologies:
* Strong communication and time-management skills for dealing with off-shore team management
* Excellent leadership, communication and interpersonal skills
Education:
* Bachelors Degree in Computer Science or related
Must be currently eligible to work in the United States
Preferred Qualifications:
* Account Management/Customer Relationship Management-type experience
* Experience managing multiple small consulting projects in parallel
* Proven ability to sell consulting services to new and existing customers
* Relevant industry knowledge
Primary Location: United States-Washington- Bellevue
Travel: No
As a Dynamics AX Software Developer, you will be working with the IT team to modify existing and design brand-new reports. You will define and execute activities to ensure all project deliverables meet customer expectations as they are created. You may also have some responsibility for sales planning, helps to identify client needs and assists to develop the proposal and supports the sales promotions at clients.
Responsibilities:
Understanding the Software Development Lifecycle (SDLC)
* Facilitate Artifact Review/Inspection meetings
* Add new AX features if needed
* Design and develop new reports using SQL Server Reporting Service (SSRS)
* Understand and participate in SDLC
* Work with all SDLC related teams and resolve conflicts surrounding issues and resolutions.
* Articulate the value QA adds to all phases of the SDLC
* Own Reporting Planning and Development Tasks with minimal supervision
* Design, create, edit and update existing reports
* Develop a high-performing AX and SQL reports, motivated work group by applying interpersonal communication and collaboration skills to achieve project goals and realize value.
* Help to identify client needs to support the sales effort.
Qualifications
Minimum Requirements:
Consulting Project Experience
* Familiarity with the entire life cycle of a development project
* Resolving conflicts between projects
* Reporting status to customers and sponsors
Technical Experience:
*Demonstrated expertise using Dynamics AX, Visual Studio.NET, C#, .NET and SQL in all aspects of the software development lifecycle
*C# test automation coding
* Enterprise custom software development experience
Project management methodologies:
* Strong communication and time-management skills for dealing with off-shore team management
* Excellent leadership, communication and interpersonal skills
Education:
* Bachelors Degree in Computer Science or related
Must be currently eligible to work in the United States
Preferred Qualifications:
* Account Management/Customer Relationship Management-type experience
* Experience managing multiple small consulting projects in parallel
* Proven ability to sell consulting services to new and existing customers
* Relevant industry knowledge
Primary Location: United States-Washington- Bellevue
Travel: No
Data Quality for Operational BI
Operational BI can only be successful if data meets quality expectations and is understood by the business community
Operational business intelligence shares many characteristics with traditionalBI, but it also differs in many ways, the most dramatic of which is the timeliness of the data acquisition and integration process. Traditional BI can often rely on overnight or intraday batch processing for collecting and processing the data. To meet operational BI needs, the update cycles repeatedly require more frequent processing of the data and do not allow for a batch processing cycle. This has several implications with respect to ensuring data quality, two of which are governance/data stewardship and source data quality.
Governance and Data Stewardship
Best practices for a BI project dictate effective governance structures as well as a robust data stewardship program. While this may the best practice, many companies have BI programs that deliver value yet do not have adequate governance or stewardship. (I don't condone that approach.) To understand how this can happen, we need to examine the impact of governance and stewardship on both the project and the result. The first of these two impacts applies equally to both traditional and operational BI initiatives. The second is more problematic for operational BI projects.
•Absence of effective leadership impacts the project by lengthening the time required to reach an understanding of the data definitions, business rules and quality expectations. While this is painful to the project team, once the agreement is reached, appropriate logic can be developed to correctly bring the data into the data warehouse.
•Even without effective governance and stewardship, once the business rules for migrating data are established, (batch) extract, transform and load policies can be developed to address data quality deficiencies. This is not always the case for operational BI. If the data needs to be loaded on a near real-time basis, error correction logic often cannot be incorporated into the data movement code. There simply isn't time to do the error correction, and often the data required to perform the correction (e.g., reference data) is not available at the same time that the transactions are being processed. To alleviate this problem, the source systems and business processes must be adjusted to prevent the errors from occurring within the data. Changes there are well beyond the scope and authority of the data warehouse team. Strong leadership (i.e., governance and stewardship) is required to determine, implement and enforce whatever changes are needed. Without strong support, the data sources will not be adjusted and the data quality deficiencies will propagate into the operational BI environment.
Source Data Quality
As previously explained, errors in the source data at the source must be addressed for operational BI to succeed. But how do we know the condition of the data?
The condition of the source data is analyzed using data profiling (a.k.a. source data analysis). Data profiling provides a systematic way of examining the source data to identify quality deficiencies, which would either impede the data acquisition and aggregation processes or generate erroneous or misleading BI results. Both strategic and operational BI development methodologies include data profiling. The difference lies in the options that can be pursued.
With traditional BI, errors that are found in the data can be corrected as part of the ETL process. This is possible due to the nature of the ETL jobs (batch) and their frequency (often daily). For any errors detected during data profiling, the project team could opt to correct the data within the ETL process.
With operational BI, there may not be an ETL process. Depending on the desired data latency, data cleansing logic within the data capture and integration is limited. For these applications, at least some of the errors detected during the data profiling need to be addressed within the source system environment, and the source system may need to be enhanced to prevent erroneous data from being stored. This requires the data profiling process to include thorough root-cause analysis.
Success in an operational BI environment requires people to trust the results they receive, and that is only accomplished if the data meets quality expectations and is understood by the business community.
Two of the ways the operational BI environment differs from the traditional BI environment are the criticality of effective governance and data stewardship and of the data profiling work.
Business intelligence
Business intelligence (BI) has been referred to as the process of making better decisions through the use of people, processes, data and related tools and methodologies. The roots of business intelligence are found in relational databases, data warehouses and data marts that help organize historical information in the hands of business analysts to generate reporting that informs executives and senior departmental managers of strategic and tactical trends and opportunities.
In recent years, business intelligence has also come to rely on near real-time operational data found in systems including enterprise resource planning (ERP), customer relationship management (CRM), supply chain, marketing and other databases. “Operational” BI is meant to provision many more functions in the organization with role-specific dashboards and scorecards and is increasingly tied to the topics of performance management and business process management. Inherent to any form of BI is the notion of data quality, consistent and dependable data and the processes involved in its creation and maintenance.
Data Quality
If there is a single pitfall that undermines any given data management initiative, it is most likely to be found in the realm of data quality, a requirement for sound decision-making. Whether in combination or by themselves, databases are almost certain to contain entry errors, multiple common entries and other redundancies that inevitably lead to incorrect or incomplete identifications of customers, products and locations. Thus, data quality is a critical prerequisite to any BI initiative that would otherwise skew or obfuscate meaning in the reporting and analytic outputs of databases, reporting tools, dashboards and scorecards.
Operational business intelligence shares many characteristics with traditionalBI, but it also differs in many ways, the most dramatic of which is the timeliness of the data acquisition and integration process. Traditional BI can often rely on overnight or intraday batch processing for collecting and processing the data. To meet operational BI needs, the update cycles repeatedly require more frequent processing of the data and do not allow for a batch processing cycle. This has several implications with respect to ensuring data quality, two of which are governance/data stewardship and source data quality.
Governance and Data Stewardship
Best practices for a BI project dictate effective governance structures as well as a robust data stewardship program. While this may the best practice, many companies have BI programs that deliver value yet do not have adequate governance or stewardship. (I don't condone that approach.) To understand how this can happen, we need to examine the impact of governance and stewardship on both the project and the result. The first of these two impacts applies equally to both traditional and operational BI initiatives. The second is more problematic for operational BI projects.
•Absence of effective leadership impacts the project by lengthening the time required to reach an understanding of the data definitions, business rules and quality expectations. While this is painful to the project team, once the agreement is reached, appropriate logic can be developed to correctly bring the data into the data warehouse.
•Even without effective governance and stewardship, once the business rules for migrating data are established, (batch) extract, transform and load policies can be developed to address data quality deficiencies. This is not always the case for operational BI. If the data needs to be loaded on a near real-time basis, error correction logic often cannot be incorporated into the data movement code. There simply isn't time to do the error correction, and often the data required to perform the correction (e.g., reference data) is not available at the same time that the transactions are being processed. To alleviate this problem, the source systems and business processes must be adjusted to prevent the errors from occurring within the data. Changes there are well beyond the scope and authority of the data warehouse team. Strong leadership (i.e., governance and stewardship) is required to determine, implement and enforce whatever changes are needed. Without strong support, the data sources will not be adjusted and the data quality deficiencies will propagate into the operational BI environment.
Source Data Quality
As previously explained, errors in the source data at the source must be addressed for operational BI to succeed. But how do we know the condition of the data?
The condition of the source data is analyzed using data profiling (a.k.a. source data analysis). Data profiling provides a systematic way of examining the source data to identify quality deficiencies, which would either impede the data acquisition and aggregation processes or generate erroneous or misleading BI results. Both strategic and operational BI development methodologies include data profiling. The difference lies in the options that can be pursued.
With traditional BI, errors that are found in the data can be corrected as part of the ETL process. This is possible due to the nature of the ETL jobs (batch) and their frequency (often daily). For any errors detected during data profiling, the project team could opt to correct the data within the ETL process.
With operational BI, there may not be an ETL process. Depending on the desired data latency, data cleansing logic within the data capture and integration is limited. For these applications, at least some of the errors detected during the data profiling need to be addressed within the source system environment, and the source system may need to be enhanced to prevent erroneous data from being stored. This requires the data profiling process to include thorough root-cause analysis.
Success in an operational BI environment requires people to trust the results they receive, and that is only accomplished if the data meets quality expectations and is understood by the business community.
Two of the ways the operational BI environment differs from the traditional BI environment are the criticality of effective governance and data stewardship and of the data profiling work.
Business intelligence
Business intelligence (BI) has been referred to as the process of making better decisions through the use of people, processes, data and related tools and methodologies. The roots of business intelligence are found in relational databases, data warehouses and data marts that help organize historical information in the hands of business analysts to generate reporting that informs executives and senior departmental managers of strategic and tactical trends and opportunities.
In recent years, business intelligence has also come to rely on near real-time operational data found in systems including enterprise resource planning (ERP), customer relationship management (CRM), supply chain, marketing and other databases. “Operational” BI is meant to provision many more functions in the organization with role-specific dashboards and scorecards and is increasingly tied to the topics of performance management and business process management. Inherent to any form of BI is the notion of data quality, consistent and dependable data and the processes involved in its creation and maintenance.
Data Quality
If there is a single pitfall that undermines any given data management initiative, it is most likely to be found in the realm of data quality, a requirement for sound decision-making. Whether in combination or by themselves, databases are almost certain to contain entry errors, multiple common entries and other redundancies that inevitably lead to incorrect or incomplete identifications of customers, products and locations. Thus, data quality is a critical prerequisite to any BI initiative that would otherwise skew or obfuscate meaning in the reporting and analytic outputs of databases, reporting tools, dashboards and scorecards.
Monday, February 15, 2010
Configure forms-based authentication for a claims-based Web application (SharePoint Server 2010)
The procedures in this article provide guidance to:
Enable you to configure forms-based authentication for a Microsoft SharePoint Server 2010 claims-based Web application.
Help you upgrade existing Office SharePoint Server 2007 Web applications that were configured to use forms-based authentication to work with SharePoint Server 2010.
After upgrading to SharePoint Server 2010, your Microsoft Office SharePoint Server 2007 Web applications will be configured for legacy login. For Office SharePoint Server 2007 Web applications that were configured to use Windows authentication, there are no additional steps required for upgrade. However, for Office SharePoint Server 2007 Web applications that were configured to use forms-based authentication, or Web SSO authentication, you must first convert to claims authentication before the Office SharePoint Server 2007 Web applications can be used in SharePoint Server 2010. After you convert you Office SharePoint Server 2007 Web applications to claims authentication, configure your Web application zones for forms-based authentication (or Web SSO authentication, as appropriate). The final step is to migrate users and permissions to SharePoint Server 2010
In this article:
Convert Web applications to claims authentication
Configure a forms-based Web application to use an LDAP provider by using Central Administration
Configure the LDAP Web.Config files
Configure a forms-based Web application to use an LDAP provider by using Windows PowerShell
Migrate users and permissions from SharePoint Server 2007 to SharePoint Server 2010
Convert Web applications to claims authentication
Perform the steps in the following procedure to use Windows PowerShell to convert existing Web applications to claims authentication.
To convert Web applications to claims authentication
1.Verify that you meet the following minimum requirements: You are a member of the SharePoint_Shell_Access role on the configuration database and a member of the WSS_ADMIN_WPG local group on the computer where SharePoint 2010 Products is installed.
2.On the Start menu, click All Programs.
3.Click Microsoft SharePoint 2010 Products.
4.Click SharePoint 2010 Management Shell.
5.From the Windows PowerShell command prompt (that is, PS C:\>), type the following and press ENTER:
Copy Code $w = Get-SPWebApplication "http:///"
$w.UseClaimsAuthentication = True;
$w.Update()Note:
We recommend that you use Windows PowerShell when performing command-line administrative tasks. The Stsadm command-line tool has been deprecated, but is included to support compatibility with previous product versions.
Configure a forms-based Web application to use an LDAP provider by using Central Administration
Perform the steps in the following procedure to use Central Administration to configure forms-based authentication for a claims-based Web application.
To configure forms-based authentication for a claims-based Web application by using Central Administration
1.Verify that the user account that is performing this procedure is a site collection administrator.
2.In Central Administration, under Application Management, select Manage Web Applications.
3.On the ribbon, select New.
4.In the Authentication section of the New Web Application dialog box, select Claims Based Authentication.
5.In the Authentication Type section, select Enable ASP.NET Membership and Role Provider.
6.Type a membership provider name and a role manager name. In the example Web.Config file depicted in this article, the name of the membership provider is membership, and the name of the role manager is rolemanager.
7.Click OK to create the Web application.
Configure the LDAP Web.Config files
After you have successfully created the Web application (described in the preceding procedure), modify the following Web.Config files:
The Central Administration Web application Web.Config file
The Security Token Service Web.Config file
The forms-based authentication claims-based Web application Web.Config file
To configure the Central Administration Web.Config file
1.Open IIS Manager by typing INETMGR at a command prompt.
2.Go to the SharePoint Central Administration site in IIS.
3.Right-click SharePoint Central Administration and select Explore.
4.Open the Web.Config file.
5.Find thesection and add the following entry:
Copy Code
type="Microsoft.Office.Server.Security.LdapMembershipProvider, Microsoft.Office.Server, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"
server="yourserver.com"
port="389"
useSSL="false"
userDNAttribute="distinguishedName"
userNameAttribute="sAMAccountName"
userContainer="OU=UserAccounts,DC=redmond,DC=corp,DC=microsoft,DC= distinguishedName (of your userContainer)"
userObjectClass="person"
userFilter="(ObjectClass=person)"
scope="Subtree"
otherRequiredUserAttributes="sn,givenname,cn" />
type="Microsoft.Office.Server.Security.LdapRoleProvider, Microsoft.Office.Server, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"
server="yourserver.com"
port="389"
useSSL="false"
groupContainer="DC=redmond,DC=corp,DC=microsoft,DC= distinguishedName (of your groupContainer)"
groupNameAttribute="cn"
groupNameAlternateSearchAttribute="samAccountName"
groupMemberAttribute="member"
userNameAttribute="sAMAccountName"
dnAttribute="distinguishedName"
groupFilter="((ObjectClass=group)"
userFilter="((ObjectClass=person)"
scope="Subtree" />
Important:
After you have added the preceding entry, save and close the Web.Config file.
To configure the Security Token Service Web.Config file
1.Open IIS Manager by typing INETMGR at a command prompt.
2.Go to the SharePoint Web Services site.
3.Go to the SecurityTokenServiceAppliction sub-site.
4.Right-click SharePoint Central Administration and select Explore.
5.Open the Web.Config file.
6.Find thesection and add the following entry:
Copy Code
type="Microsoft.Office.Server.Security.LdapMembershipProvider, Microsoft.Office.Server, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"
server="yourserver.com"
port="389"
useSSL="false"
userDNAttribute="distinguishedName"
userNameAttribute="sAMAccountName"
userContainer="OU=UserAccounts,DC=redmond,DC=corp,DC=microsoft,DC=com"
userObjectClass="person"
userFilter="(&(ObjectClass=person))"
scope="Subtree"
otherRequiredUserAttributes="sn,givenname,cn" />
type="Microsoft.Office.Server.Security.LdapRoleProvider, Microsoft.Office.Server, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"
server="yourserver.com"
port="389"
useSSL="false"
groupContainer="DC=redmond,DC=corp,DC=microsoft,DC=com"
groupNameAttribute="cn"
groupNameAlternateSearchAttribute="samAccountName"
groupMemberAttribute="member"
userNameAttribute="sAMAccountName"
dnAttribute="distinguishedName"
groupFilter="(&(ObjectClass=group))"
userFilter="(&(ObjectClass=person))"
scope="Subtree" />
Important:
After you have added the preceding entry, save and close the Web.Config file.
To configure the forms-based authentication claims-based Web application Web.Config file
1.Open IIS Manager by typing INETMGR at a command prompt.
2.Go to the Claims Forms site.
3.Right-click Claims Forms and select Explore.
4.Open the Web.Config file.
5.Find thesection.
6.Find thesection and add the following entry:
Copy Code
type="Microsoft.Office.Server.Security.LdapMembershipProvider, Microsoft.Office.Server, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"
server="yourserver.com"
port="389"
useSSL="false"
userDNAttribute="distinguishedName"
userNameAttribute="sAMAccountName"
userContainer="OU=UserAccounts,DC=redmond,DC=corp,DC=microsoft,DC=com"
userObjectClass="person"
userFilter="(&(ObjectClass=person))"
scope="Subtree"
otherRequiredUserAttributes="sn,givenname,cn" />Find thesection and add the following entry:
Copy Code
type="Microsoft.Office.Server.Security.LdapRoleProvider, Microsoft.Office.Server, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"
server="yourserver.com"
port="389"
useSSL="false"
groupContainer="DC=redmond,DC=corp,DC=microsoft,DC=com"
groupNameAttribute="cn"
groupNameAlternateSearchAttribute="samAccountName"
groupMemberAttribute="member"
userNameAttribute="sAMAccountName"
dnAttribute="distinguishedName"
groupFilter="(&(ObjectClass=group))"
userFilter="(&(ObjectClass=person))"
scope="Subtree" />Important:
After you have added the preceding entry, save and close the Web.Config file.
Warning:
Do not overwrite any existing entries in this Web.Config file.
Configure a forms-based Web application to use an LDAP provider by using Windows PowerShell
Perform the steps in the following procedure to use Windows PowerShell to configure forms-based authentication for a claims-based Web application.
To configure a forms-based Web application to use an LDAP provider by using Windows PowerShell
1.Verify that you meet the following minimum requirements: You are a member of the SharePoint_Shell_Access role on the configuration database and a member of the WSS_ADMIN_WPG local group on the computer where SharePoint 2010 Products is installed.
2.On the Start menu, click All Programs.
3.Click Microsoft SharePoint 2010 Products.
4.Click SharePoint 2010 Management Shell.
5.From the Windows PowerShell command prompt (that is, PS C:\>), type the following and press ENTER:
Copy Code >$ap = New-SPAuthenticationProvider -Name "ClaimsForms" -ASPNETMembershipProvider "membership" -ASPNETRoleProviderName "rolemanager"
>$wa = New-SPWebApplication -Name "Claims Windows Web App" -ApplicationPool "Claims App Pool" -ApplicationPoolAccount "redmond\appool"
-Url http://servername -Port 80 -AuthenticationProvider $apNote:
The value of the ApplicationPoolAccount parameter must be a managed account on the farm.
6.After you have successfully created an authentication provider and a Web application, modify the following Web.Config files using the sample entries provided in the "Configure the LDAP Web.Config files" section of this article:
The Central Administration Web application Web.Config file
The Security Token Service Web.Config fil
The forms-based authentication claims-based Web application Web.Config file
7.After you have modified the Web.Config files, create a SPClaimsPrinciple and a site collection, as shown in the following example:
Copy Code >$cp = New-SPClaimsPrincipal -Identity "membership:SiteOwner" -IdentityType FormsUser
>$sp = New-SPSite http://servername:port -OwnerAlias $cp.Encode() -Template "STS#0"Note:
We recommend that you use Windows PowerShell when performing command-line administrative tasks. The Stsadm command-line tool has been deprecated, but is included to support compatibility with previous product versions.
Migrate users and permissions from SharePoint Server 2007 to SharePoint Server 2010
Perform the steps in the following procedure to use Windows PowerShell to migrate users and permissions.
To migrate users and permissions from SharePoint Server 2007 to SharePoint Server 2010
1.Verify that you meet the following minimum requirements: You are a member of the SharePoint_Shell_Access role on the configuration database and a member of the WSS_ADMIN_WPG local group on the computer where SharePoint 2010 Products is installed.
2.On the Start menu, click All Programs.
3.Click Microsoft SharePoint 2010 Products.
4.Click SharePoint 2010 Management Shell.
5.From the Windows PowerShell command prompt (that is, PS C:\>), type the following and press ENTER:
Copy Code $w = Get-SPWebApplication "http:///"
$w.MigrateUsers(True)Note:
We recommend that you use Windows PowerShell when performing command-line administrative tasks. The Stsadm command-line tool has been deprecated, but is included to support compatibility with previous product version.
Enable you to configure forms-based authentication for a Microsoft SharePoint Server 2010 claims-based Web application.
Help you upgrade existing Office SharePoint Server 2007 Web applications that were configured to use forms-based authentication to work with SharePoint Server 2010.
After upgrading to SharePoint Server 2010, your Microsoft Office SharePoint Server 2007 Web applications will be configured for legacy login. For Office SharePoint Server 2007 Web applications that were configured to use Windows authentication, there are no additional steps required for upgrade. However, for Office SharePoint Server 2007 Web applications that were configured to use forms-based authentication, or Web SSO authentication, you must first convert to claims authentication before the Office SharePoint Server 2007 Web applications can be used in SharePoint Server 2010. After you convert you Office SharePoint Server 2007 Web applications to claims authentication, configure your Web application zones for forms-based authentication (or Web SSO authentication, as appropriate). The final step is to migrate users and permissions to SharePoint Server 2010
In this article:
Convert Web applications to claims authentication
Configure a forms-based Web application to use an LDAP provider by using Central Administration
Configure the LDAP Web.Config files
Configure a forms-based Web application to use an LDAP provider by using Windows PowerShell
Migrate users and permissions from SharePoint Server 2007 to SharePoint Server 2010
Convert Web applications to claims authentication
Perform the steps in the following procedure to use Windows PowerShell to convert existing Web applications to claims authentication.
To convert Web applications to claims authentication
1.Verify that you meet the following minimum requirements: You are a member of the SharePoint_Shell_Access role on the configuration database and a member of the WSS_ADMIN_WPG local group on the computer where SharePoint 2010 Products is installed.
2.On the Start menu, click All Programs.
3.Click Microsoft SharePoint 2010 Products.
4.Click SharePoint 2010 Management Shell.
5.From the Windows PowerShell command prompt (that is, PS C:\>), type the following and press ENTER:
Copy Code $w = Get-SPWebApplication "http://
$w.UseClaimsAuthentication = True;
$w.Update()Note:
We recommend that you use Windows PowerShell when performing command-line administrative tasks. The Stsadm command-line tool has been deprecated, but is included to support compatibility with previous product versions.
Configure a forms-based Web application to use an LDAP provider by using Central Administration
Perform the steps in the following procedure to use Central Administration to configure forms-based authentication for a claims-based Web application.
To configure forms-based authentication for a claims-based Web application by using Central Administration
1.Verify that the user account that is performing this procedure is a site collection administrator.
2.In Central Administration, under Application Management, select Manage Web Applications.
3.On the ribbon, select New.
4.In the Authentication section of the New Web Application dialog box, select Claims Based Authentication.
5.In the Authentication Type section, select Enable ASP.NET Membership and Role Provider.
6.Type a membership provider name and a role manager name. In the example Web.Config file depicted in this article, the name of the membership provider is membership, and the name of the role manager is rolemanager.
7.Click OK to create the Web application.
Configure the LDAP Web.Config files
After you have successfully created the Web application (described in the preceding procedure), modify the following Web.Config files:
The Central Administration Web application Web.Config file
The Security Token Service Web.Config file
The forms-based authentication claims-based Web application Web.Config file
To configure the Central Administration Web.Config file
1.Open IIS Manager by typing INETMGR at a command prompt.
2.Go to the SharePoint Central Administration site in IIS.
3.Right-click SharePoint Central Administration and select Explore.
4.Open the Web.Config file.
5.Find the
Copy Code
type="Microsoft.Office.Server.Security.LdapMembershipProvider, Microsoft.Office.Server, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"
server="yourserver.com"
port="389"
useSSL="false"
userDNAttribute="distinguishedName"
userNameAttribute="sAMAccountName"
userContainer="OU=UserAccounts,DC=redmond,DC=corp,DC=microsoft,DC= distinguishedName (of your userContainer)"
userObjectClass="person"
userFilter="(ObjectClass=person)"
scope="Subtree"
otherRequiredUserAttributes="sn,givenname,cn" />
type="Microsoft.Office.Server.Security.LdapRoleProvider, Microsoft.Office.Server, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"
server="yourserver.com"
port="389"
useSSL="false"
groupContainer="DC=redmond,DC=corp,DC=microsoft,DC= distinguishedName (of your groupContainer)"
groupNameAttribute="cn"
groupNameAlternateSearchAttribute="samAccountName"
groupMemberAttribute="member"
userNameAttribute="sAMAccountName"
dnAttribute="distinguishedName"
groupFilter="((ObjectClass=group)"
userFilter="((ObjectClass=person)"
scope="Subtree" />
Important:
After you have added the preceding entry, save and close the Web.Config file.
To configure the Security Token Service Web.Config file
1.Open IIS Manager by typing INETMGR at a command prompt.
2.Go to the SharePoint Web Services site.
3.Go to the SecurityTokenServiceAppliction sub-site.
4.Right-click SharePoint Central Administration and select Explore.
5.Open the Web.Config file.
6.Find the
Copy Code
type="Microsoft.Office.Server.Security.LdapMembershipProvider, Microsoft.Office.Server, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"
server="yourserver.com"
port="389"
useSSL="false"
userDNAttribute="distinguishedName"
userNameAttribute="sAMAccountName"
userContainer="OU=UserAccounts,DC=redmond,DC=corp,DC=microsoft,DC=com"
userObjectClass="person"
userFilter="(&(ObjectClass=person))"
scope="Subtree"
otherRequiredUserAttributes="sn,givenname,cn" />
type="Microsoft.Office.Server.Security.LdapRoleProvider, Microsoft.Office.Server, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"
server="yourserver.com"
port="389"
useSSL="false"
groupContainer="DC=redmond,DC=corp,DC=microsoft,DC=com"
groupNameAttribute="cn"
groupNameAlternateSearchAttribute="samAccountName"
groupMemberAttribute="member"
userNameAttribute="sAMAccountName"
dnAttribute="distinguishedName"
groupFilter="(&(ObjectClass=group))"
userFilter="(&(ObjectClass=person))"
scope="Subtree" />
Important:
After you have added the preceding entry, save and close the Web.Config file.
To configure the forms-based authentication claims-based Web application Web.Config file
1.Open IIS Manager by typing INETMGR at a command prompt.
2.Go to the Claims Forms site.
3.Right-click Claims Forms and select Explore.
4.Open the Web.Config file.
5.Find the
6.Find the
Copy Code
type="Microsoft.Office.Server.Security.LdapMembershipProvider, Microsoft.Office.Server, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"
server="yourserver.com"
port="389"
useSSL="false"
userDNAttribute="distinguishedName"
userNameAttribute="sAMAccountName"
userContainer="OU=UserAccounts,DC=redmond,DC=corp,DC=microsoft,DC=com"
userObjectClass="person"
userFilter="(&(ObjectClass=person))"
scope="Subtree"
otherRequiredUserAttributes="sn,givenname,cn" />Find the
Copy Code
type="Microsoft.Office.Server.Security.LdapRoleProvider, Microsoft.Office.Server, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"
server="yourserver.com"
port="389"
useSSL="false"
groupContainer="DC=redmond,DC=corp,DC=microsoft,DC=com"
groupNameAttribute="cn"
groupNameAlternateSearchAttribute="samAccountName"
groupMemberAttribute="member"
userNameAttribute="sAMAccountName"
dnAttribute="distinguishedName"
groupFilter="(&(ObjectClass=group))"
userFilter="(&(ObjectClass=person))"
scope="Subtree" />Important:
After you have added the preceding entry, save and close the Web.Config file.
Warning:
Do not overwrite any existing entries in this Web.Config file.
Configure a forms-based Web application to use an LDAP provider by using Windows PowerShell
Perform the steps in the following procedure to use Windows PowerShell to configure forms-based authentication for a claims-based Web application.
To configure a forms-based Web application to use an LDAP provider by using Windows PowerShell
1.Verify that you meet the following minimum requirements: You are a member of the SharePoint_Shell_Access role on the configuration database and a member of the WSS_ADMIN_WPG local group on the computer where SharePoint 2010 Products is installed.
2.On the Start menu, click All Programs.
3.Click Microsoft SharePoint 2010 Products.
4.Click SharePoint 2010 Management Shell.
5.From the Windows PowerShell command prompt (that is, PS C:\>), type the following and press ENTER:
Copy Code >$ap = New-SPAuthenticationProvider -Name "ClaimsForms" -ASPNETMembershipProvider "membership" -ASPNETRoleProviderName "rolemanager"
>$wa = New-SPWebApplication -Name "Claims Windows Web App" -ApplicationPool "Claims App Pool" -ApplicationPoolAccount "redmond\appool"
-Url http://servername -Port 80 -AuthenticationProvider $apNote:
The value of the ApplicationPoolAccount parameter must be a managed account on the farm.
6.After you have successfully created an authentication provider and a Web application, modify the following Web.Config files using the sample entries provided in the "Configure the LDAP Web.Config files" section of this article:
The Central Administration Web application Web.Config file
The Security Token Service Web.Config fil
The forms-based authentication claims-based Web application Web.Config file
7.After you have modified the Web.Config files, create a SPClaimsPrinciple and a site collection, as shown in the following example:
Copy Code >$cp = New-SPClaimsPrincipal -Identity "membership:SiteOwner" -IdentityType FormsUser
>$sp = New-SPSite http://servername:port -OwnerAlias $cp.Encode() -Template "STS#0"Note:
We recommend that you use Windows PowerShell when performing command-line administrative tasks. The Stsadm command-line tool has been deprecated, but is included to support compatibility with previous product versions.
Migrate users and permissions from SharePoint Server 2007 to SharePoint Server 2010
Perform the steps in the following procedure to use Windows PowerShell to migrate users and permissions.
To migrate users and permissions from SharePoint Server 2007 to SharePoint Server 2010
1.Verify that you meet the following minimum requirements: You are a member of the SharePoint_Shell_Access role on the configuration database and a member of the WSS_ADMIN_WPG local group on the computer where SharePoint 2010 Products is installed.
2.On the Start menu, click All Programs.
3.Click Microsoft SharePoint 2010 Products.
4.Click SharePoint 2010 Management Shell.
5.From the Windows PowerShell command prompt (that is, PS C:\>), type the following and press ENTER:
Copy Code $w = Get-SPWebApplication "http://
$w.MigrateUsers(True)Note:
We recommend that you use Windows PowerShell when performing command-line administrative tasks. The Stsadm command-line tool has been deprecated, but is included to support compatibility with previous product version.
SharePoint and Mobile?
NEW! SharePoint Workspace Mobile
Take your files on SharePoint offline on your phone with Microsoft SharePoint Workspace Mobile 2010! You can browse document libraries and lists right from your phone. As well you can open, edit and sync documents directly for viewing or editing in the various mobile office apps like Word 2010, Excel 2010, and PowerPoint2010, and sync to SharePoint 2010.
The coolest part is the ability to sync documents and folders to your windows mobile phone (6.5 and higher).
You’ll be impressed with Powerpoint’s 2010 presentation companion where you can advance slides from your phone with your blue tooth enabled phone.
With OneNote 2010 Mobile you can take notes, voice or text on your phone and sync to your Windows 7 PC with WinMo device center. Conversation view in Outlook 2010 mobile will be nice as well as the new company directory based searching UI.
The Top 10 Benefits of Office Mobile 2010 goes into more detail.
You can actually see in the diagram on the right of SharePoint Workspace 2010 Mobile the icon rich interface with the sync setup on folders and files.
As with the browser and search wars, it aint over till it’s over!
I remember a company meeting a few years ago where Ballmer asked the crowd, does anyone here use google? After explaining how google made money off of every search whether you clicked on the ads or not, and then explaining the advancements in MSN search now Bing.com and asked now who will use google. He then explained that it was an IQ question, and those that raised their hands failed that IQ question.
Mobile today in SharePoint 2007 compared with SharePoint 2010
As mentioned before there are built in mobile views with WSS 3.0 and SharePoint Server 2007. In fact there’s actually a good explanation of how mobile views work with the blog template vs other templates on MSDN.
There is an entire node on Mobile development in SharePoint 2007 and new content for mobile development in SharePoint 2010 Jan Tielens introduces the topic of SharePoint 2007 mobile views in his post SharePoint 2007 on mobile devices.
See the mobile views for yourself. Essentially the easiest way to get at the riches of the mobile views for navigation.
WSS 3.0: http://www.sharepointjoel.com/_layouts/mobile/mbllists.aspx
Not only do you get a richer look and feel, you can see site further recursive navigation is included, a new filter for locating content in a large list to increase findability.
The scenarios are better served in the mobile experience. While it’s far from perfect, the simple mobile views have been cleaned up and redesigned to focus more on the lightweight browsing experience. You can even imagine the mobile views being used for remote employees to address bandwidth issues when working with SharePoint 2010.
Take your files on SharePoint offline on your phone with Microsoft SharePoint Workspace Mobile 2010! You can browse document libraries and lists right from your phone. As well you can open, edit and sync documents directly for viewing or editing in the various mobile office apps like Word 2010, Excel 2010, and PowerPoint2010, and sync to SharePoint 2010.
The coolest part is the ability to sync documents and folders to your windows mobile phone (6.5 and higher).
You’ll be impressed with Powerpoint’s 2010 presentation companion where you can advance slides from your phone with your blue tooth enabled phone.
With OneNote 2010 Mobile you can take notes, voice or text on your phone and sync to your Windows 7 PC with WinMo device center. Conversation view in Outlook 2010 mobile will be nice as well as the new company directory based searching UI.
The Top 10 Benefits of Office Mobile 2010 goes into more detail.
You can actually see in the diagram on the right of SharePoint Workspace 2010 Mobile the icon rich interface with the sync setup on folders and files.
As with the browser and search wars, it aint over till it’s over!
I remember a company meeting a few years ago where Ballmer asked the crowd, does anyone here use google? After explaining how google made money off of every search whether you clicked on the ads or not, and then explaining the advancements in MSN search now Bing.com and asked now who will use google. He then explained that it was an IQ question, and those that raised their hands failed that IQ question.
Mobile today in SharePoint 2007 compared with SharePoint 2010
As mentioned before there are built in mobile views with WSS 3.0 and SharePoint Server 2007. In fact there’s actually a good explanation of how mobile views work with the blog template vs other templates on MSDN.
There is an entire node on Mobile development in SharePoint 2007 and new content for mobile development in SharePoint 2010 Jan Tielens introduces the topic of SharePoint 2007 mobile views in his post SharePoint 2007 on mobile devices.
See the mobile views for yourself. Essentially the easiest way to get at the riches of the mobile views for navigation.
WSS 3.0: http://www.sharepointjoel.com/_layouts/mobile/mbllists.aspx
Not only do you get a richer look and feel, you can see site further recursive navigation is included, a new filter for locating content in a large list to increase findability.
The scenarios are better served in the mobile experience. While it’s far from perfect, the simple mobile views have been cleaned up and redesigned to focus more on the lightweight browsing experience. You can even imagine the mobile views being used for remote employees to address bandwidth issues when working with SharePoint 2010.
Friday, February 12, 2010
Exploiting the Visual Studio 2010 Extensibility
Featured Event within the SharePoint 2010: Bits From the Edge Virtual Conference
Register now for this live event!
Visual Studio 2010 brings professional development to the footsteps of SharePoint. With a new managed extensibility model specific to SharePoint projects you can be in charge of your development experience.
Learn how to integrate Exploration, Content, Deployment focused extensions which take maximum advantage of the rich feature set provided by Visual Studio and MS-Build.
________________________________________
Join us for SharePoint 2010: Bits from the Edge, a free online one-day conference for developers of SharePoint products and technologies. Brought to you by SharePoint Connections, this conference brings industry experts to your desktop, offering free, technical SharePoint training.
________________________________________
This featured event within the SharePoint 2010: Bits from the Edge Virtual Conference on Tuesday, Feb. 16, 2010, which brings you and your team the advantages of a traditional trade show without any of the travel cost! Attend an educational session, ask questions, visit a trade show booth, interact with other industry professionals and pick up valuable literature - from a single registration and all from the comfort of your office and at no charge! Register here.
Exploiting the Visual Studio 2010 Extensibility
Tuesday, Feb. 16
2:30 PM ET / 11:30 AM PT
Duration: 60 Minutes
Wouter van Vugt
Wouter is a Microsoft MVP and independent expert on Office and SharePoint technologies. He has focused on SharePoint Foundation as a developer platform, wrote the world's first book on Open XML and is an author for MSDN. Wouter is a trainer with Critical Path Training.
Learn more and register from here:
http://www.vconferenceonline.com/shows/spring10/sharepoint/?CID=ded021010
Register now for this live event!
Visual Studio 2010 brings professional development to the footsteps of SharePoint. With a new managed extensibility model specific to SharePoint projects you can be in charge of your development experience.
Learn how to integrate Exploration, Content, Deployment focused extensions which take maximum advantage of the rich feature set provided by Visual Studio and MS-Build.
________________________________________
Join us for SharePoint 2010: Bits from the Edge, a free online one-day conference for developers of SharePoint products and technologies. Brought to you by SharePoint Connections, this conference brings industry experts to your desktop, offering free, technical SharePoint training.
________________________________________
This featured event within the SharePoint 2010: Bits from the Edge Virtual Conference on Tuesday, Feb. 16, 2010, which brings you and your team the advantages of a traditional trade show without any of the travel cost! Attend an educational session, ask questions, visit a trade show booth, interact with other industry professionals and pick up valuable literature - from a single registration and all from the comfort of your office and at no charge! Register here.
Exploiting the Visual Studio 2010 Extensibility
Tuesday, Feb. 16
2:30 PM ET / 11:30 AM PT
Duration: 60 Minutes
Wouter van Vugt
Wouter is a Microsoft MVP and independent expert on Office and SharePoint technologies. He has focused on SharePoint Foundation as a developer platform, wrote the world's first book on Open XML and is an author for MSDN. Wouter is a trainer with Critical Path Training.
Learn more and register from here:
http://www.vconferenceonline.com/shows/spring10/sharepoint/?CID=ded021010
Thursday, February 11, 2010
The SQL Server Health Check
My friend Brent Ozar, who is a top-notch SQL Server Professional, mentioned on his blog (http://www.brentozar.com/archive/2007/04/sql-server-health-check/comment-page-1/#comment-17520 ) that he brought in Microsoft Support to do a “Health Check”. There were some questions about what this actually entails – so I thought I would post that description here.
A SQL Server Health Check from Microsoft is an offering provided through our support and consulting branches. If you’ve purchased a Premier support agreement, you can use the hours you pay for to have someone come out and check out your systems using two basic vectors: standard best practices, and the best practices for your environment. Let me explain that a little further.
Microsoft Consulting Services (MCS) has an advanced set of tools and techniques to reach deep into your systems to evaluate them against a set of criteria that we establish for the best performance, safety and reliability for SQL Server. But your SQL Server Instances will be different than someone else’s, so the consultant will also spend some time in an interview with various teams to find out how you’re using the system. They’ll consult with experts in that area back at Redmond, and at the end of the engagement you get what I feel is the most valuable part of the exercise – the report. The report shows what was done, how it was done, what the findings are and what recommendations the consultant makes. It’s a thing of beauty.
You don’t have to have a Premier agreement to get a SQL Server Health Check, and companies other than Microsoft have versions of this as well. The prices vary, so if you want a Microsoft person then contact your local Microsoft office and ask for the Consulting Manager for your area. They will get you to the right person and you can work out the costs from there. If you take a hard look, most of the time the cost is well justified.
On a related note, I think it’s fantastic that Brent has the foresight to bring in “another pair of eyes” on his systems. Brent is actually in the program to gain a SQL Server “Master” certification – something only a few people in the world have. He works for a software development firm that creates fantastic products for – wait for it – SQL Server! He could evaluate his own systems, and of course he does. But he realizes that there’s always something more to learn, and someone out there may know one more little detail that he doesn’t. This is the mark of a very bright person.
A SQL Server Health Check from Microsoft is an offering provided through our support and consulting branches. If you’ve purchased a Premier support agreement, you can use the hours you pay for to have someone come out and check out your systems using two basic vectors: standard best practices, and the best practices for your environment. Let me explain that a little further.
Microsoft Consulting Services (MCS) has an advanced set of tools and techniques to reach deep into your systems to evaluate them against a set of criteria that we establish for the best performance, safety and reliability for SQL Server. But your SQL Server Instances will be different than someone else’s, so the consultant will also spend some time in an interview with various teams to find out how you’re using the system. They’ll consult with experts in that area back at Redmond, and at the end of the engagement you get what I feel is the most valuable part of the exercise – the report. The report shows what was done, how it was done, what the findings are and what recommendations the consultant makes. It’s a thing of beauty.
You don’t have to have a Premier agreement to get a SQL Server Health Check, and companies other than Microsoft have versions of this as well. The prices vary, so if you want a Microsoft person then contact your local Microsoft office and ask for the Consulting Manager for your area. They will get you to the right person and you can work out the costs from there. If you take a hard look, most of the time the cost is well justified.
On a related note, I think it’s fantastic that Brent has the foresight to bring in “another pair of eyes” on his systems. Brent is actually in the program to gain a SQL Server “Master” certification – something only a few people in the world have. He works for a software development firm that creates fantastic products for – wait for it – SQL Server! He could evaluate his own systems, and of course he does. But he realizes that there’s always something more to learn, and someone out there may know one more little detail that he doesn’t. This is the mark of a very bright person.
CA Free Trial Download
CA Free Trial Download
Create and maintain databases, data warehouses and enterprise data models with CA ERwin Data Modeler. Visualize data structures to effectively organize, manage and moderate data complexities, database technologies and the deployment environment
Click to Download
Create and maintain databases, data warehouses and enterprise data models with CA ERwin Data Modeler. Visualize data structures to effectively organize, manage and moderate data complexities, database technologies and the deployment environment
Click to Download
Tuesday, February 9, 2010
PerformancePoint Services overview (SharePoint Server 2010)
PerformancePoint Services overview (SharePoint Server 2010)Updated: 2009-11-12
[This article is pre-release documentation and is subject to change in future releases.]
PerformancePoint Services in Microsoft SharePoint Server 2010 is a performance management service that you can use to monitor and analyze your business. By providing flexible, easy-to-use tools for building dashboards, scorecards, and key performance indicators (KPIs), PerformancePoint Services can help individuals across an organization make informed business decisions that align with companywide objectives and strategy.
Dashboards, scorecards, KPIs, and reports help drive accountability. Integrated analytics help workers quickly move from monitoring information to analyzing it, and where appropriate, sharing it throughout the organization. Before PerformancePoint Services became part of Microsoft SharePoint Server 2010, Microsoft Office PerformancePoint Server 2007 was a standalone server.
Now the functionality of Microsoft Office PerformancePoint Server 2007 is available as an integrated part of the Office SharePoint Server Enterprise license. PerformancePoint Services retains much of the same features and functionality as its predecessor while including additional benefits, enhancements, and new functionality.
Note:
An upgrade wizard is now available, that moves database objects from the previous version, PerformancePoint Server 2007, to PerformancePoint Services.
PerformancePoint Services
The following is an overview of features for PerformancePoint Services.
Create interactive and context driven dashboards with scorecards, analytic reports and filters. Reports also integrate with SQL Server Reporting Services and Excel Services.
Create scorecards that bring together data from multiple data sources (including Analysis Services, SQL Server, SharePoint lists and Excel Services) to track and monitor key drivers of your business.
Use interactive analytic reports to identify driving forces and root causes, and apply filters to personalize your reports.
Integrate your business intelligence applications and information with other powerful SharePoint Server features, such as collaboration and content management.
New features and enhancements
The following is an overview of new features and enhancements.
PerformancePoint is a service in SharePoint Server. Dashboards and dashboard items are stored and secured within SharePoint Server lists and libraries, providing you with a single security and repository framework. The new architecture also takes advantage of SharePoint Server security framework, scalability, collaboration, backup and restore, and disaster recovery capabilities. You can also include and link PerformancePoint Services Web Parts together with other SharePoint Server Web Parts on the same page. The new architecture also streamlines security models that simplify access to report data.
The visualization Decomposition Tree is a new report type that you can use to quickly and visually break down higher-level data values from a multi-dimensional data set in order to understand the driving forces behind those values. The Decomposition Tree is available in scorecards and analytic reports rendered in your dashboards.
The KPI Details report is a new report type that displays contextually relevant information about KPIs, metrics, rows, columns, and cells within a scorecard. The KPI Details report works as a Web Part that links to a scorecard or individual KPI and can be added to dashboards or any SharePoint Server page.
Scorecards have been enhanced to make it easy for you to drill down and quickly access more detailed information. PerformancePoint scorecards also offer more flexible layout options, dynamic hierarchies, and calculated KPI features. Using this enhanced functionality, you can now create custom metrics that use multiple data sources. You also can sort, filter, and view variances between actual and target values to help you identify concerns or risks.
With Better Time Intelligence filtering capabilities you can create and use dynamic time filters that are always up to date. Other improved filters enhance the ability for dashboard users to quickly focus in on information that is most relevant.
SharePoint Web Parts can include and link to PerformancePoint Web Parts on the same page.
It’s easier to author and publish dashboard items using Dashboard Designer.
There is increased support for accessibility compliance in individual reports and scorecards.
Analytic reports have been enhanced to support value filtering, new chart types, and server-based conditional formatting.
Support for SQL Server Analysis Services 2008 and SQL Server 2008.
Retired features
PerformancePoint Services no longer supports Trend Charts, PivotTable reports, PivotChart reports, Analysis Services 2000, and 32-bit server architecture.
[This article is pre-release documentation and is subject to change in future releases.]
PerformancePoint Services in Microsoft SharePoint Server 2010 is a performance management service that you can use to monitor and analyze your business. By providing flexible, easy-to-use tools for building dashboards, scorecards, and key performance indicators (KPIs), PerformancePoint Services can help individuals across an organization make informed business decisions that align with companywide objectives and strategy.
Dashboards, scorecards, KPIs, and reports help drive accountability. Integrated analytics help workers quickly move from monitoring information to analyzing it, and where appropriate, sharing it throughout the organization. Before PerformancePoint Services became part of Microsoft SharePoint Server 2010, Microsoft Office PerformancePoint Server 2007 was a standalone server.
Now the functionality of Microsoft Office PerformancePoint Server 2007 is available as an integrated part of the Office SharePoint Server Enterprise license. PerformancePoint Services retains much of the same features and functionality as its predecessor while including additional benefits, enhancements, and new functionality.
Note:
An upgrade wizard is now available, that moves database objects from the previous version, PerformancePoint Server 2007, to PerformancePoint Services.
PerformancePoint Services
The following is an overview of features for PerformancePoint Services.
Create interactive and context driven dashboards with scorecards, analytic reports and filters. Reports also integrate with SQL Server Reporting Services and Excel Services.
Create scorecards that bring together data from multiple data sources (including Analysis Services, SQL Server, SharePoint lists and Excel Services) to track and monitor key drivers of your business.
Use interactive analytic reports to identify driving forces and root causes, and apply filters to personalize your reports.
Integrate your business intelligence applications and information with other powerful SharePoint Server features, such as collaboration and content management.
New features and enhancements
The following is an overview of new features and enhancements.
PerformancePoint is a service in SharePoint Server. Dashboards and dashboard items are stored and secured within SharePoint Server lists and libraries, providing you with a single security and repository framework. The new architecture also takes advantage of SharePoint Server security framework, scalability, collaboration, backup and restore, and disaster recovery capabilities. You can also include and link PerformancePoint Services Web Parts together with other SharePoint Server Web Parts on the same page. The new architecture also streamlines security models that simplify access to report data.
The visualization Decomposition Tree is a new report type that you can use to quickly and visually break down higher-level data values from a multi-dimensional data set in order to understand the driving forces behind those values. The Decomposition Tree is available in scorecards and analytic reports rendered in your dashboards.
The KPI Details report is a new report type that displays contextually relevant information about KPIs, metrics, rows, columns, and cells within a scorecard. The KPI Details report works as a Web Part that links to a scorecard or individual KPI and can be added to dashboards or any SharePoint Server page.
Scorecards have been enhanced to make it easy for you to drill down and quickly access more detailed information. PerformancePoint scorecards also offer more flexible layout options, dynamic hierarchies, and calculated KPI features. Using this enhanced functionality, you can now create custom metrics that use multiple data sources. You also can sort, filter, and view variances between actual and target values to help you identify concerns or risks.
With Better Time Intelligence filtering capabilities you can create and use dynamic time filters that are always up to date. Other improved filters enhance the ability for dashboard users to quickly focus in on information that is most relevant.
SharePoint Web Parts can include and link to PerformancePoint Web Parts on the same page.
It’s easier to author and publish dashboard items using Dashboard Designer.
There is increased support for accessibility compliance in individual reports and scorecards.
Analytic reports have been enhanced to support value filtering, new chart types, and server-based conditional formatting.
Support for SQL Server Analysis Services 2008 and SQL Server 2008.
Retired features
PerformancePoint Services no longer supports Trend Charts, PivotTable reports, PivotChart reports, Analysis Services 2000, and 32-bit server architecture.
TAS Extended Web Seminar: SharePoint Server 2010 Overview
TAS Extended Web Seminar: SharePoint Server 2010 Overview
These web seminars are brought to you by Technical Advisory Services team to enhance learning and develop additional technical Microsoft product knowledge. These web seminars are available to Gold Certified Partners, Certified Partners with ISV Competency and Empower partners. One TAS Advisory Hour will be deducted from your benefits, but there is no “out-of-pocket cost” to you. For more information about Technical Advisory Services go to:
https://partner.microsoft.com/US/supportsecurity/40012316
Agenda:
• What’s New in SharePoint 2010?
• Installation and Upgrade
• UI Changes and Service Applications
• Search
• External Content Type and BCS
• SharePoint Workspace 2010
• Security
• Monitoring, Logging, and Reporting
• Backup and Restore
• Multi-tenancy and Hosting
Presenter:
Maheshwar Mohanty - Partner Technical Consultant
These web seminars are brought to you by Technical Advisory Services team to enhance learning and develop additional technical Microsoft product knowledge. These web seminars are available to Gold Certified Partners, Certified Partners with ISV Competency and Empower partners. One TAS Advisory Hour will be deducted from your benefits, but there is no “out-of-pocket cost” to you. For more information about Technical Advisory Services go to:
https://partner.microsoft.com/US/supportsecurity/40012316
Agenda:
• What’s New in SharePoint 2010?
• Installation and Upgrade
• UI Changes and Service Applications
• Search
• External Content Type and BCS
• SharePoint Workspace 2010
• Security
• Monitoring, Logging, and Reporting
• Backup and Restore
• Multi-tenancy and Hosting
Presenter:
Maheshwar Mohanty - Partner Technical Consultant
Saturday, February 6, 2010
SQL Reporting Services data from SharePoint lists
Introduction
SharePoint lists are stored in a SQL Server database, so you would think that connecting SQL Reporting Services to a SharePoint 2007 list would be trivial, but it’s not. There are a number of pitfalls to be avoided that are not entirely clear and do not provide clear error messages. In this white paper, I’ll outline one approach to attach a report to a list. I’ll include common mistakes and ways to avoid them as well as tips for determining causes of problems you might find along the way.
There were a couple sites that helped me figure out how to get things wired up.
•RockStarGuys had nearly all the ducks in a row to get everything working. My problem was that their final query didn’t work. In fact, the new report wizard didn’t like their second query string at all, and I couldn’t get past that point in the wizard.
•While looking around for help on this query, I stumbled across a blog that shows a more detailed query. From this, I was able to come up with my actually working query text.
For complete article, please click on SQL Reporting Services data from SharePoint lists
SharePoint lists are stored in a SQL Server database, so you would think that connecting SQL Reporting Services to a SharePoint 2007 list would be trivial, but it’s not. There are a number of pitfalls to be avoided that are not entirely clear and do not provide clear error messages. In this white paper, I’ll outline one approach to attach a report to a list. I’ll include common mistakes and ways to avoid them as well as tips for determining causes of problems you might find along the way.
There were a couple sites that helped me figure out how to get things wired up.
•RockStarGuys had nearly all the ducks in a row to get everything working. My problem was that their final query didn’t work. In fact, the new report wizard didn’t like their second query string at all, and I couldn’t get past that point in the wizard.
•While looking around for help on this query, I stumbled across a blog that shows a more detailed query. From this, I was able to come up with my actually working query text.
For complete article, please click on SQL Reporting Services data from SharePoint lists
Tuesday, February 2, 2010
Free Hands-On SQL Server Analysis Services 2008 Step-by-Step Training.
Microsoft SQL Server Analysis Services (SSAS) is a multidimensional data server that provides online analytical processing (OLAP) and data mining services.
SSAS - provides fast, intuitive, top-down analysis of large quantities of data built on this unified data model, which can be delivered to users in multiple languages and currencies.
SSAS - lets end users analyze data by using a host of tools such as Microsoft Office Excel, SQL Server 2008
Reporting Services (SSRS), SharePoint 2010, Custom-developed applications, and third-party
tools. This training seminars series focuses on the OLAP functionality of SSAS, we are going to cover the process of developing basic SSAS cubes, measures and dimensions as well as administration and maintenance.
From: February 09, 2010
To: March 16, 2010
Time: from 06:30 PM to 09:00 PM
Where Microsoft New England District
Street: 201 Jones Rd. 6 floor, MPR C,
City: Waltham
State: MA
Country: US
Course Objectives
Implement dimensions in a cube.
Implement measures in a cube.
Implement a data source view.
Configure dimension usage in a cube.
Implement custom logic in a cube by using MDX
Implement storage design in a cube.
Deploy SSAS databases and objects.
Implement processing options.
Configure permissions and roles in SSAS.
Install and maintain an SSAS instance.
Diagnose and resolve performance issues
Day 1 Introduction to MS SQL Server Analysis Services 2008
This session will introduce the major concepts of OLAP and how to build multidimensional data structures (cubes) using SQL Server 2008.
Day 2 SQL Server Analysis Services and Enterprise Data Warehousing.
In this session we will look at the architecture, design principles and common practices for creating scalable Data Warehouses, discuss Business Architecture and Frameworks as foundation of OLAP.
Day 3 Developing SSAS Cubes (Part 1)
This seminar focuses on the OLAP functionality of SSAS, exploring the process of developing basic SSAS cubes and
dimensions.
Step 1: Creating Data Sources and Data Source Views
Step 2: Creating and Modifying SSAS Cubes
Day 4 Developing SSAS Cubes (Part 2)
Step 3: Creating and Modifying Dimensions
Step 4: Creating Measure Groups and Measures
Day 5 Extending SSAS Cubes
This seminar starts by discussing attribute and dimension relationships. You will learn how to extend the Unified Dimensional Model (UDM) with KPIs, actions, translations, and perspectives. And after describing the MDX query fundamentals, the we will explore MDX calculated members and named sets.
Step 1: Defining User Hierarchies and Dimension Relationships
Step 2: Creating KPIs, Actions, Translations, and Perspectives
Step 3: Creating Calculations and Queries by Using MDX
Day 6 Managing SSAS Storage, Processing, and Deployment
This seminar provides comprehensive coverage of SSAS storage options and optimization techniques. It also explores ways to partition measure groups to improve processing and query performance and describes ways to design and optimize cube aggregations.
Step 1: Defining Measure Group Partitions and Aggregations
Step 2: Deploying SSAS Objects
Step 3: Processing SSAS Objects
Day 7 Securing and Administering SSAS
In this seminar, you will learn how to use SSAS security features to protect data in the
cube. In addition, you will learn how to back up and restore databases and monitor the
health and performance of your SSAS installations.
Step 1: Setting Up SSAS Server Security
Step 2: Managing SSAS High Availability, Backups, and
Step 3: Managing SSAS Tuning and Logging
Step 4: Tracing and Monitoring SSAS Instances
For more information please visit http://www.bostonbi.org/ and for events calendar http://bostonbi.org/Events/Calendar.aspx
SSAS - provides fast, intuitive, top-down analysis of large quantities of data built on this unified data model, which can be delivered to users in multiple languages and currencies.
SSAS - lets end users analyze data by using a host of tools such as Microsoft Office Excel, SQL Server 2008
Reporting Services (SSRS), SharePoint 2010, Custom-developed applications, and third-party
tools. This training seminars series focuses on the OLAP functionality of SSAS, we are going to cover the process of developing basic SSAS cubes, measures and dimensions as well as administration and maintenance.
From: February 09, 2010
To: March 16, 2010
Time: from 06:30 PM to 09:00 PM
Where Microsoft New England District
Street: 201 Jones Rd. 6 floor, MPR C,
City: Waltham
State: MA
Country: US
Course Objectives
Implement dimensions in a cube.
Implement measures in a cube.
Implement a data source view.
Configure dimension usage in a cube.
Implement custom logic in a cube by using MDX
Implement storage design in a cube.
Deploy SSAS databases and objects.
Implement processing options.
Configure permissions and roles in SSAS.
Install and maintain an SSAS instance.
Diagnose and resolve performance issues
Day 1 Introduction to MS SQL Server Analysis Services 2008
This session will introduce the major concepts of OLAP and how to build multidimensional data structures (cubes) using SQL Server 2008.
Day 2 SQL Server Analysis Services and Enterprise Data Warehousing.
In this session we will look at the architecture, design principles and common practices for creating scalable Data Warehouses, discuss Business Architecture and Frameworks as foundation of OLAP.
Day 3 Developing SSAS Cubes (Part 1)
This seminar focuses on the OLAP functionality of SSAS, exploring the process of developing basic SSAS cubes and
dimensions.
Step 1: Creating Data Sources and Data Source Views
Step 2: Creating and Modifying SSAS Cubes
Day 4 Developing SSAS Cubes (Part 2)
Step 3: Creating and Modifying Dimensions
Step 4: Creating Measure Groups and Measures
Day 5 Extending SSAS Cubes
This seminar starts by discussing attribute and dimension relationships. You will learn how to extend the Unified Dimensional Model (UDM) with KPIs, actions, translations, and perspectives. And after describing the MDX query fundamentals, the we will explore MDX calculated members and named sets.
Step 1: Defining User Hierarchies and Dimension Relationships
Step 2: Creating KPIs, Actions, Translations, and Perspectives
Step 3: Creating Calculations and Queries by Using MDX
Day 6 Managing SSAS Storage, Processing, and Deployment
This seminar provides comprehensive coverage of SSAS storage options and optimization techniques. It also explores ways to partition measure groups to improve processing and query performance and describes ways to design and optimize cube aggregations.
Step 1: Defining Measure Group Partitions and Aggregations
Step 2: Deploying SSAS Objects
Step 3: Processing SSAS Objects
Day 7 Securing and Administering SSAS
In this seminar, you will learn how to use SSAS security features to protect data in the
cube. In addition, you will learn how to back up and restore databases and monitor the
health and performance of your SSAS installations.
Step 1: Setting Up SSAS Server Security
Step 2: Managing SSAS High Availability, Backups, and
Step 3: Managing SSAS Tuning and Logging
Step 4: Tracing and Monitoring SSAS Instances
For more information please visit http://www.bostonbi.org/ and for events calendar http://bostonbi.org/Events/Calendar.aspx
Monday, February 1, 2010
Win a trip to the 2010 Microsoft BI Conference in New Orleans!!!
Hi Everyone!
Exciting news on the PowerPivot front - Friday we launched the Excelerators Quiz and the Alpha Geek Challenge. Go now to the sites below and take the quiz to see if you’re anywhere near as good as Donald Farmer! Remember to post your results on Facebook and Twitter or even challenge a friend! Also spread the word to all your Alpha Geek pals to participate in our challenges for some great prizes!
We’ve been working hard to get these sites ready, and we want to hit the ground running. Go check it out for yourself, and have fun!
Please send this to your friends, colleagues, and family members! You can win awesome prizes -- a $250 shopping spree to the Microsoft store, an all-expense paid trip to the 2010 BI Conference in New Orleans and a 'hot date' with Donald Farmer!!!
For more info, you can read at http://www.vtlconsulting.net/News.aspx
Exciting news on the PowerPivot front - Friday we launched the Excelerators Quiz and the Alpha Geek Challenge. Go now to the sites below and take the quiz to see if you’re anywhere near as good as Donald Farmer! Remember to post your results on Facebook and Twitter or even challenge a friend! Also spread the word to all your Alpha Geek pals to participate in our challenges for some great prizes!
We’ve been working hard to get these sites ready, and we want to hit the ground running. Go check it out for yourself, and have fun!
Please send this to your friends, colleagues, and family members! You can win awesome prizes -- a $250 shopping spree to the Microsoft store, an all-expense paid trip to the 2010 BI Conference in New Orleans and a 'hot date' with Donald Farmer!!!
For more info, you can read at http://www.vtlconsulting.net/News.aspx
New online course "Data Governance for Business Leaders" by John Ladley
Many IM and governance initiatives originate in business areas, but the realities of sustaining governance need to be fully understood before change occurs. Solid business case, ongoing measures, and changing old data habits are essential to success.
Read more at http://www.elearningcurve.com/
Read more at http://www.elearningcurve.com/
Sharepoint 2010 review on ARN
http://www.arnnet.com.au/article/325494/review_sharepoint_server_2010_beta_pulls_it_all_together
This article gives some practical summaries of a few of the new features in Sharepoint 2010. I thought quite a nice read for partners wanting to see the headlines on some of the new features.
This article gives some practical summaries of a few of the new features in Sharepoint 2010. I thought quite a nice read for partners wanting to see the headlines on some of the new features.
VSTO 2008 Resource List
Here is a list of resources you can use to try to find answers to any questions you may have on using VSTO 3.0 (2008). There is a wealth of information here, and you’re sure to discover a lot of content that pertains to what you’re trying to do.
(For information on earlier versions of Visual Studio Tools for Office, please consult this post: http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/5f13a675-2972-4983-a6dd-9e32b459d422)
If you can’t seem to find what you’re looking for or still think you need some guidance or advice, then please feel free to post your question or issue in the forum.
Product-specific
Visual Studio Tools for Office Developer Portal on MSDN
http://msdn.microsoft.com/en-us/office/aa905533.aspx
VSTO 2008 Features and System Requirements
http://download.microsoft.com/download/9/a/e/9ae0f6cc-7032-408e-9ca7-989f9e4af4ec/VS2008Readme.htm
VSTO 2008 Guided Tour (Visual Studio 2008 Quick Tour of the Integrated Development Environment)
http://msdn.microsoft.com/en-us/office/ms165088.aspx
VSTO 2008 On-line Documentation (MSDN Library)
http://msdn.microsoft.com/en-us/library/d2tx7z6d.aspx
Access Developer Extensions (ADE) for Access 2007
The ADE are no longer part of the Visual Studio Tools for Office. They’re available as a free download. More information here:
http://msdn.microsoft.com/en-us/office/bb229700.aspx
MSDN Subscriptions Site
VSTO 2008 is included in the Professional and higher subscription types. This page shows a comparison of these subscriptions.
http://msdn.microsoft.com/en-us/subscriptions/aa718657.aspx
Further Information
Here are some other resources you can tap for further information on VSTO 2008.
VSTO Blogs
•VSTO Team Blog – http://blogs.msdn.com/vsto•Eric Carter (VSTO Team Member) - http://blogs.msdn.com/eric_carter/•Misha Shneerson (VSTO Team Member)
http://blogs.msdn.com/mshneer/default.aspx•Andrew Whitechapel (VSTO Team Member)
http://blogs.msdn.com/andreww/default.aspx•John Durant (VSTO Team Member) -
https://blogs.msdn.com/johnrdurant/default.aspx•Paul Stubbs (VSTO Team Member)
http://blogs.msdn.com/pstubbs/•Mike Hernandez (former VSTO Product Manager)
http://blogs.msdn.com/mikeh/default.aspx•Kathleen McGrath (Author “VSTO for Mere Mortals”)
http://blogs.msdn.com/kathleen•Office Zealot Site (VSTO MVP Chris Kunicki)
http://www.officezealot.com/VSTO/bloghome.aspx•GotDotNet.com Site – http://blogs.gotdotnet.com/
Technical Articles and Books
What’s New in VSTO 2008
http://msdn.microsoft.com/en-us/library/86bkz018.aspx
VSTO 2008 Deployment
•Deployment overview for VSTO 2008 solutions
http://msdn.microsoft.com/en-us/library/bb157879.aspx•Deploying an Office 2007 solution with an MSI instead of ClickOnce
http://blogs.msdn.com/vsto/archive/2008/04/10/deploying-an-office-solution-using-windows-installer-mary-lee.aspx
http://msdn.microsoft.com/en-us/library/cc563937.aspx
http://msdn.microsoft.com/en-us/library/cc616991.aspx•Deploying an Office 2007 Add-in to “all users”
http://blogs.msdn.com/mshneer/archive/2007/09/04/deploying-your-vsto-add-in-to-all-users-part-i.aspx
Complete list of VSTO technical articles and video “How to” on MSDN
http://msdn.microsoft.com/en-us/library/bb871648.aspx
VSTO for Mere Mortals This book is written by former VSTO team members Kathleen McGrath and Paul Stubbs. It targets VB.NET as the language and VSTO 2005, including Add-ins created using SE.
http://www.awprofessional.com/bookstore/product.asp?isbn=0321426711&rl=1
Visual Studio Tools for Office 2007: VSTO for Excel, Word and Outlook (March 2009) This is a book written by VSTO team member Eric Carter and former team member Eric Lippert. It is a re-write of the 2005 edition, targeting VSTO 2008 and Office 2007. It covers advanced topics in Office development and VSTO technology, as well as the basics of using VSTO. Code samples and discussion revolve around using C#, but the basic discussion also apply to VB.NET. Publisher: Addison-Wesley; ISBN 978-0-321-53321-0.
(For information on earlier versions of Visual Studio Tools for Office, please consult this post: http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/5f13a675-2972-4983-a6dd-9e32b459d422)
If you can’t seem to find what you’re looking for or still think you need some guidance or advice, then please feel free to post your question or issue in the forum.
Product-specific
Visual Studio Tools for Office Developer Portal on MSDN
http://msdn.microsoft.com/en-us/office/aa905533.aspx
VSTO 2008 Features and System Requirements
http://download.microsoft.com/download/9/a/e/9ae0f6cc-7032-408e-9ca7-989f9e4af4ec/VS2008Readme.htm
VSTO 2008 Guided Tour (Visual Studio 2008 Quick Tour of the Integrated Development Environment)
http://msdn.microsoft.com/en-us/office/ms165088.aspx
VSTO 2008 On-line Documentation (MSDN Library)
http://msdn.microsoft.com/en-us/library/d2tx7z6d.aspx
Access Developer Extensions (ADE) for Access 2007
The ADE are no longer part of the Visual Studio Tools for Office. They’re available as a free download. More information here:
http://msdn.microsoft.com/en-us/office/bb229700.aspx
MSDN Subscriptions Site
VSTO 2008 is included in the Professional and higher subscription types. This page shows a comparison of these subscriptions.
http://msdn.microsoft.com/en-us/subscriptions/aa718657.aspx
Further Information
Here are some other resources you can tap for further information on VSTO 2008.
VSTO Blogs
•VSTO Team Blog – http://blogs.msdn.com/vsto•Eric Carter (VSTO Team Member) - http://blogs.msdn.com/eric_carter/•Misha Shneerson (VSTO Team Member)
http://blogs.msdn.com/mshneer/default.aspx•Andrew Whitechapel (VSTO Team Member)
http://blogs.msdn.com/andreww/default.aspx•John Durant (VSTO Team Member) -
https://blogs.msdn.com/johnrdurant/default.aspx•Paul Stubbs (VSTO Team Member)
http://blogs.msdn.com/pstubbs/•Mike Hernandez (former VSTO Product Manager)
http://blogs.msdn.com/mikeh/default.aspx•Kathleen McGrath (Author “VSTO for Mere Mortals”)
http://blogs.msdn.com/kathleen•Office Zealot Site (VSTO MVP Chris Kunicki)
http://www.officezealot.com/VSTO/bloghome.aspx•GotDotNet.com Site – http://blogs.gotdotnet.com/
Technical Articles and Books
What’s New in VSTO 2008
http://msdn.microsoft.com/en-us/library/86bkz018.aspx
VSTO 2008 Deployment
•Deployment overview for VSTO 2008 solutions
http://msdn.microsoft.com/en-us/library/bb157879.aspx•Deploying an Office 2007 solution with an MSI instead of ClickOnce
http://blogs.msdn.com/vsto/archive/2008/04/10/deploying-an-office-solution-using-windows-installer-mary-lee.aspx
http://msdn.microsoft.com/en-us/library/cc563937.aspx
http://msdn.microsoft.com/en-us/library/cc616991.aspx•Deploying an Office 2007 Add-in to “all users”
http://blogs.msdn.com/mshneer/archive/2007/09/04/deploying-your-vsto-add-in-to-all-users-part-i.aspx
Complete list of VSTO technical articles and video “How to” on MSDN
http://msdn.microsoft.com/en-us/library/bb871648.aspx
VSTO for Mere Mortals This book is written by former VSTO team members Kathleen McGrath and Paul Stubbs. It targets VB.NET as the language and VSTO 2005, including Add-ins created using SE.
http://www.awprofessional.com/bookstore/product.asp?isbn=0321426711&rl=1
Visual Studio Tools for Office 2007: VSTO for Excel, Word and Outlook (March 2009) This is a book written by VSTO team member Eric Carter and former team member Eric Lippert. It is a re-write of the 2005 edition, targeting VSTO 2008 and Office 2007. It covers advanced topics in Office development and VSTO technology, as well as the basics of using VSTO. Code samples and discussion revolve around using C#, but the basic discussion also apply to VB.NET. Publisher: Addison-Wesley; ISBN 978-0-321-53321-0.
Subscribe to:
Posts (Atom)