Home

Friday, August 30, 2013

SPS NH: Search Driven Design Patterns for SharePoint 2013

Event:
SharePoint Saturday NH
Saturday, September 21, 2013

Session Title:
Search Driven Design Patterns for SharePoint 2013

Abstract:
First, we will discuss SharePoint portal design flaws, related deficiencies, and challenges that exist with SharePoint in the enterprise.  We will discuss the Search platform and redefine what it means to us and how we leverage it.  We will take a tour of a Search Driven portal and review the configuration of Managed Properties, Result Sources, Query Rules, Search Results Web Parts, Display Templates, Search Boxes, and Search Pages.  Next, we will construct Search Driven components using creative techniques and reflect on the benefits of the overall approach that we followed, comparing and contrasting with other design patterns.  Finally, we will take a step back and discuss the future of Search and how to align SharePoint Search with the overarching Enterprise Architecture strategy.

This session provides practical guidance and best practices for SharePoint 2013 and SharePoint 2010 portal design, content management design, and search configuration based on real world lessons learned.  The demonstrations and technical deep dives showcase Search Driven Design Patterns in motion while providing instructions for how to build a Search Driven portal.

Slides:
Search Driven Design Patterns for SharePoint 2013.pdf

Saturday, August 17, 2013

Windows Server 2012, Windows 8, Product Key and Activate


Description

The "Change product key" link is not visible in Windows Server 2012 or Windows Server 2008 and the license is not activated.


Solution

Enter a Product Key and Activate Windows.

1)  All Apps, Run, slui.exe 0x3, click OK

2)  Type Product Key, click Activate


Reference

Microsoft Support (2013).  "Change product key" link is not available in Windows 8 or in Windows Server 2012.  Retrieved August 17, 2013 from http://support.microsoft.com/kb/2750773

TechNet (2013).  Slmgr.vbs Options.  Retrieved August 17, 2013 from http://technet.microsoft.com/en-us/library/ff793433.aspx

Sunday, August 11, 2013

Error: SQL Server: Unable to Shrink Transaction Log, "Could not locate file for database..."



Description

You attempt to shrink a transaction log file associated with a SQL Server database, but you receive in error:

"Could not locate file 'Transaction Log Name' for database
'Database Name' in sys.database_files. The file either does not exist, or was dropped."



Solution


1)  Run SP_HelpFile to get the correct name of the transaction log file.

USE Database Name
EXEC sp_helpfile

(TechNet, 2013)

This will return the following information about the database files, including the associated transation log(s):  Name, FileId, FileName, FileGroup, Size, MaxSize, Growth, Usage



2)  Run the Transact-SQL statement again, using the correct Transaction Log Name.  You can find this in the Name column of the SP_HelpFile query results set.

USE [Database Name]
 GO
ALTER DATABASE Database Name SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(Transaction Log Name, 1)
ALTER DATABASE Database Name SET RECOVERY FULL WITH NO_WAIT
 GO

(TechNet, 2013)



3)  Verify that there are configured, scheduled, and enabled SQL Server Backup jobs in place for:

a) Full Database Backup
b) Transaction Log Backup *Important for Full Recovery Model*



Reference

TechNet (2013).  Backup Under the Full Recovery Model.  Retrieved August 11, 2013 from http://technet.microsoft.com/en-us/library/ms190217%28v=sql.105%29.aspx

TechNet (2013).  DBCC SHRINKFILE (Transact-SQL).  Retrieved August 11, 2013 from http://technet.microsoft.com/en-us/library/ms189493.aspx

TechNet (2013).  Recovery Models and Transaction Log Management.  Retrieved August 11, 2013 from http://technet.microsoft.com/en-us/library/ms366344%28v=sql.105%29.aspx

TechNet (2013).  sp_helpfile.  Retrieved August 11, 2013 from http://technet.microsoft.com/en-us/library/aa933456%28v=sql.80%29.aspx

Monday, July 29, 2013

Installing .NET framework (Netfx3) on Windows Server 2012 using PowerShell


Description

The purpose of this post is to provide instructions for installing .NET framework (NetFx3) on Windows Server 2012 using PowerShell.

.NET Framework is a requirement for SQL Server 2012.  If this has not been installed prior to a SQL Server 2012 installation, then an error message will surface during the installation process.  It is recommended to run the PowerShell command for installing Netfx3 prior to beginning the SQL Server installation.


Solution

1.  Make the Windows Server 2012 media (DVD) available.  For this example, I mounted a DVD drive on drive letter Z.

2.  Open Windows PowerShell as an Administrator.

3.  Run the following PowerShell command, replacing the source details with those specific to your environment.


PS C:\Windows\system32> dism /online /enable-feature /all /featurename:NetFx3 /source:z:\sources\sxs






Reference

Microsoft TechNet (February, 2012).  DISM - Deployment Image Servicing and Management Technical Reference.  Retrieved July 29, 2013 from http://technet.microsoft.com/en-us/library/hh824821.aspx

Microsoft TechNet (February, 2012).  Use DISM in Windows PowerShell.  Retrieved July 29, 2013 from http://technet.microsoft.com/en-us/library/hh825010.aspx

Verbeeck, K. (April, 2013).  Error while enabling Windows Feature: Netfx3.  Retrieved July 29, 2013 from http://www.sqlservercentral.com/blogs/koen-verbeeck/2013/04/29/error-while-enabling-windows-feature-netfx3

Thursday, July 18, 2013

SQL Server 2012: Find SQL Server Collation


Description

How to retrieve collation information for SQL Server 2012.


Solution

During the set up of SQL Server 2012, the default collations are as follows (as shown below):


Database Engine:  SQL_Latin1_General_CP1_CI_AS

Analysis Services:  Latin1_General_CI_AS





To retrieve the collation of the Database Engine for an existing SQL Server instance:

SELECT CONVERT (varchar, SERVERPROPERTY('collation'));

 
To retrieve  the collation of databases attached to the SQL Server instance:

SELECT name, collation_name FROM sys.databases;

(MSDN, 2012)



Reference

MSDN (2012).  View Collation Information.  Retrieved July 18, 2013 from http://msdn.microsoft.com/en-us/library/hh230914.aspx

Wednesday, July 03, 2013

Issue: Windows Server 2012, JavaScript Blocked on Internet Explorer


Description

On a Windows Server 2012 system, JavaScript is being blocked in Internet Explorer.



Solution

1. Open Server Manager.


2.  Click "Local Server"



3.  In the Properties section, locate "IE Enhanced Security Configuration."  It is currently set to "On."  Click "On" to open a dialog window.



4.  Change the "Internet Explorer Enhanced Security Configuration" settings to Off as needed.  Click OK and close Server Manager.

Tuesday, June 11, 2013

SPS NYC: Search Driven Design Patterns for SharePoint 2013

Event:
SharePoint Saturday NYC
Saturday, July 27, 2013

Session Title:
Search Driven Design Patterns for SharePoint 2013

Abstract:
First, we will step back and examine some SharePoint related deficiencies, common portal design flaws, and challenges that exist in the enterprise.  Next, we will align ourselves with an overarching Enterprise Architecture strategy and redefine the role of SharePoint Search in the organization.  From there, we will design a SharePoint 2013 portal that is optimized and ready for Search Driven design patterns.  Finally, we will construct Search Driven components using creative techniques and reflect on the benefits of the overall approach that we followed.

Slides:
Search Driven Design Patterns for SharePoint 2013.pdf

Sunday, March 10, 2013

Blindly Diagnosing a RAM Issue affecting SharePoint 2010 W3Wp.exe and SQL Server 2005 Enterprise Edition


I received limited information about an issue.  Here are some ideas.

Description

A SharePoint Server 2010 Farm with a SQL Server 2005 Enterprise Edition database server has RAM issues which are affecting affecting both the Web front end (w3wp.exe) and SQL Server.

Would be Helpful to Know
Is it 32-bit or 64-bit? How much physical RAM is assigned to each server role? What version and patch level is the OS?  What version and patch level is SQL Server? How is SharePoint being used?  How many users?  Are there custom Web parts? Custom Web pages? What are the SQL Server performance counters reading?  When does a memory spike occur?  How long does it last?  When did it start?  What recently changed in the environment?  Are the systems physical or virtual?  What is the server farm topology?

Possible Causes

Need a Service Pack/Patch for OS:  self-explanatory, but need the current information to know if this is a possibility.

Antivirus:  Investigate antivirus software running on the servers.  IIS Forums reported that McAfee Enterprise V8  had a buffer overflow protection feature that was causing problems with w3wp.exe (IIS Forums, 2008).

Incorrectly disposed objects:  Unmanaged memory can lead to memory problems (MSDN, 2010).

Scheduled jobs:  SQL Server maintenance plans, SQL agent jobs (e.g. backups), SharePoint full or incremental crawl schedules can create noticeable degradation while running.

On the SQL Server side of things:  Resource bottlenecks, TempDB bottlenecks, or a slow running user query (less likely in this situation) (MSDN, 2010).  Query the sys.dm_os_memory_clerks and sys.dm_exec_query_memory_grants DMVs to get an idea how SQL Server is utilizing memory.

Reference

IIS Forums(July, 2008).  W3wp.exe memory usage is out of control.  Retrieved March 10, 2013 from http://forums.iis.net/t/1150494.aspx

Microsoft TechNet (2005).  Troubleshooting Performance Problems in SQL Server 2005.  Retrieved March 10, 2013 from http://technet.microsoft.com/library/Cc96654

MSDN (2010).  Disposing Objects.  Retrieved March 10, 2013 from http://msdn.microsoft.com/en-us/library/ee557362.aspx 


MSDN (2010).  SharePoint Dispose Checker Tool.  Retrieved March 10, 2013 from http://archive.msdn.microsoft.com/SPDisposeCheck

Sunday, March 03, 2013

SPS Boston: Search Driven Design Patterns for SharePoint 2013

Event:
SharePoint Saturday Boston
Saturday, April 27, 2013

Session Title:
Search Driven Design Patterns for SharePoint 2013

Abstract:
First, we will step back and examine some SharePoint related deficiencies, common portal design flaws, and challenges that exist in the enterprise.  Next, we will align ourselves with an overarching Enterprise Architecture strategy and redefine the role of SharePoint Search in the organization.  From there, we will design a SharePoint 2013 portal that is optimized and ready for Search Driven design patterns.  Finally, we will construct Search Driven components using creative techniques and reflect on the benefits of the overall approach that we followed.

Slides:
Search Driven Design Patterns for SharePoint 2013.pdf

Sunday, December 30, 2012

NYESUG: Search Driven Design Patterns for SharePoint 2013

Event:
The NY Enterprise Search User Group
Wednesday, January 9, 2013

Session Title:
Search Driven Design Patterns for SharePoint 2013

Abstract:
First, we will step back and examine some SharePoint related deficiencies, common portal design flaws, and challenges that exist in the enterprise.  Next, we will align ourselves with an overarching Enterprise Architecture strategy and redefine the role of SharePoint Search in the organization.  From there, we will design a SharePoint 2013 portal that is optimized and ready for Search Driven design patterns.  Finally, we will construct Search Driven components using creative techniques and reflect on the benefits of the overall approach that we followed.

Slides:
Search Driven Design Patterns for SharePoint 2013.pdf

Tuesday, December 04, 2012

Error: SharePoint 2013: Adding ContentDB with No Free Space


Description

When attempting to add a Content Database to a SharePoint Web Application, an error occurs:
"Sorry, something went wrong..."


The error message is self explanatory.  It states that "There is not enough disk space on disk".

Solution

Make free space and then recreate Content Database.  It is time to investigate the reasons why free disk space was drawn down to zero.  This situation should not be allowed to occur on the SQL Server data file partition.  Therefore, an activity plan following the error message should be aim towards preventing this situation from occurring in the future. 

Some initial questions to ask might include:
  • Was the initial storage allocation sufficient?
  • Is the server storage partitioned properly?
  • What is consuming space?
  • Are backups configured for the SQL data file partition?
  • Are database backup cleanup jobs scheduled?
  • Is there any logging on the partition?
  • What is the logging retention?

Thursday, November 29, 2012

Error: SharePoint 2013: Central Administration - Service Unavailable: HTTP Error 503


Description


When attempting to open the SharePoint 2013 Central Administration Web site, the site does not come up, and there is an error:

"Service Unavailable.  HTTP Error 503. The Service is unavailable."


Cause


The SQL Server services are stopped because the domain Service Account used to run the SQL Server services is locked out.  This is visible from All Programs, Microsoft SQL Server 2012, Configuration Tools, SQL Server Configuration Manager.




Solution

In Active Directory Users and Computers, perform the following:
  • Unlock the Service Account
  • Ensure that the Service Account is not set to require user to change password at next login
  • Ensure that the password never expires
  • Verify Group Policies on the Organizational Unit to ensure that the account password is not being expired as a result of an effective policy.  If so, change the policy inheritance on the OU.
  • If possible, reboot the SQL Server or manually start all of the services that were affected by the account lockout.

Tuesday, November 27, 2012

SharePoint 2013: How to Configure Subscription Settings Service Application using PowerShell

Last Updated March 28, 2014



Description

This post describes how to configure the SharePoint Server 2013 Subscription Settings Service Application using PowerShell.

Solution

1)  Document the Naming Convention






Document a naming convention for each of the Subscription Settings Service Application components.

Example:
Application Pool Service Account:  Domain\SvcAccount (this should already be created)
Application Pool: SvcApp_SPServiceApplicationPool_03 (this should already be created)
Service Application: SvcApp_SPSubscriptionSettingsServiceApplication_01
Service Application Database: SvcApp_SPSubscriptionSettingsServiceApplication_01_DB_01 

Service Application Proxy:  The Proxy is named automatically by SharePoint 

2)  Open the SharePoint 2013 Management Shell as Administrator.

3)  Verify the Name of the Application Pool.
PS C:\ Get-SPServiceApplicationPool | Select Name

4)  Set the Service Application Pool in a variable.
$SvcAppPool03 = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_03"

5)  Create the Service Application and assign it to the Application Pool.
$SvcApp = New-SPSubscriptionSettingsServiceApplication -ApplicationPool $SvcAppPool03 -Name "SvcApp_SPSubscriptionSettingsServiceApplication_01" -DatabaseName "SvcApp_SPSubscriptionSettingsServiceApplication_01_DB_01" -DatabaseServer "MSSQL Client Alias"
 
6)  Verify the Service Application.
PS C:\ Get-SPServiceApplication | Select Name

5)  Create the Service Application Proxy and assign it to the Service Application.
$SvcAppProxy = New-SPSubscriptionSettingsServiceApplicationProxy -ServiceApplication $SvcApp

It does not appear that the name of the Proxy can be set using the cmdlet.  SharePoint will name the Proxy automatically.

7)  Verify Service Application Proxy.
PS C:\ Get-SPServiceApplicationProxy | Select Name

8)  Start the Service Instance.
Get-SPServiceInstance | where{$_.TypeName -eq "Microsoft SharePoint Foundation Subscription Settings Service"} | Start-SPServiceInstance


References

Microsoft TechNet (2012).  New-SPSubscriptionSettingsServiceApplication.  Retrieved November 27, 2012 from http://technet.microsoft.com/en-us/library/ff607823.aspx.

Microsoft TechNet (2012).  Service application cmdlets in SharePoint 2013.  Retrieved November 27, 2012 from http://technet.microsoft.com/en-us/library/ee906561.aspx.

Microsoft TechNet (2012).  SharePoint 2013 - Service Applications.  Retrieved November 27, 2012 from http://social.technet.microsoft.com/wiki/contents/articles/12512.sharepoint-2013-service-applications.aspx.

SharePoint 2013: How to Configure State Service Application using PowerShell

Last Updated March 28, 2014 

Description

This post describes how to configure the SharePoint Server 2013 State Service Application using PowerShell.

Solution


1)  Document the Naming Convention
.
Document a naming convention for each of the State Service Application components.
Example:
Application Pool Service Account:  Domain\SvcAccount (this should already be created)
Application Pool: SvcApp_SPServiceApplicationPool_02 (this should already be created)
Service Application:  SvcApp_SPStateServiceApplication_01
Service Application Database:  SvcApp_SPStateServiceApplication_01_DB_01
Service Application Proxy:  SvcApp_SPStateServiceApplication_01_Proxy_01
2)  Open the SharePoint 2013 Management Shell as Administrator.

3)  Verify the Name of the Application Pool.
Get-SPServiceApplicationPool | Select Name

4)  Set the Service Application Pool in a variable.

$SvcAppPool02 = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_02"

5)  Create the Service Application and assign it to the Application Pool.
 
New-SPStateServiceDatabase -Name SvcApp_SPStateServiceApplication_01_DB_01 | New-SPStateServiceApplication -Name SvcApp_SPStateServiceApplication_01 | New-SPStateServiceApplicationProxy -Name SvcApp_SPStateServiceApplication_01_Proxy_01 | -DefaultProxyGroup
6) Verify State Service Application.
Get-SPStateServiceApplication | Select Name

7)  Verify State Service Database.
Get-SPStateServiceDatabase | Select Name

9) Verify State Service Application Proxy.
Get-SPStateServiceApplicationProxy | Select Name


References

Microsoft TechNet (2012).  New-SPStateServiceApplication.  Retrieved November 27, 2012 from http://technet.microsoft.com/en-us/library/ff608084.aspx.

Microsoft TechNet (2012).  Service application cmdlets in SharePoint 2013.  Retrieved November 27, 2012 from http://technet.microsoft.com/en-us/library/ee906561.aspx.

Microsoft TechNet (2012).  SharePoint 2013 - Service Applications.  Retrieved November 27, 2012 from http://social.technet.microsoft.com/wiki/contents/articles/12512.sharepoint-2013-service-applications.aspx.

Microsoft TechNet (2012).  State service and session state cmdlets in SharePoint 2013.  Retrieved November 27, 2012 from http://technet.microsoft.com/en-us/library/ee890113.aspx.

Sunday, September 30, 2012

Issue: SharePoint 2013 Configuration Wizard Failure


Description
SharePoint Products Configuration Wizard:  Configuration Failed
Error referencing Step 3:  "Failed to Create the Configuration Database"


Environment Observed
SharePoint 2013 Preview
Windows Server 2008 R2 SP1
SQL Server 2008 R2 SP1


Solution
I searched the Web for blog posts referencing this error, there were quite a few.  I verified the service accounts settings and the SQL Server configurations (Kalil, 2012).  I ran the psconfig command below from PowerShell, from the BIN directory.  After this cmdlet completed, I ran the Configuration Wizard again and the Wizard was successful.

psconfig.exe -cmd configdb create SkipRegisterAsDistributedCacheHost user %domain\service account% password %password% passphrase %password%
(Spiffy, 2012)
 


References

Khalil, G. (July, 2012).  Installing SharePoint 2013 Preview on Windows 2012 Server with SQL 2012-Part 2.  Retrieved September 30, 2012 from http://sharepointgeorge.com/2012/installing-sharepoint-2013-preview-windows-2012-server-sql-2012part-2.

MSDN (2012).  Max degree of parallelism Option.  Retrieved September 30, 2012 from http://msdn.microsoft.com/en-us/library/ms181007(v=sql.105).aspx.

Spiffy (August, 2012).  3 Steps to Setup your SharePoint 2013 Preview.  Retrieved September 30, 2012 from http://spiffy.sg/developers/3-steps-to-setup-your-sharepoint-2013-preview.

Monday, August 20, 2012

SharePoint 2010 UPA Idle


DESCRIPTION

I ran into an issue with the User Profile Application (UPA) recently.  I had recently added a custom user property to the UPA and needed to do a full synchronization to pull in the values from Active Directory.  I manually initiated a full sync, however, the Profile Synchronization Settings remained "Idle."



SOLUTION


First thing I did was RDP to the SharePoint application server and to figure out the LOGONSERVER.  From the command line I typed:

echo %logonserver%

Doing this revealed that that the LOGONSERVER was a domain controller DC01.  I investigated to find that this server was running Windows Server 2003.  I continued to research the domain and found that the entire domain was running at 2003 level and there were a mix of 2003 and 2008 domain controllers.  The domain level wasn't the issue, but the specific server might be the issue.

Next, I manually changed the LOGONSERVER of the SharePoint  application server to a Windows Server 2008 domain controller named, DC03.  I did this from the command line using the following command:

set logonserver=\\DC03

With the LOGONSERVER updated, I attempted to run another full UPA sync.  It was successful this time.


Finally, I wanted to hard code this LOGONSERVER setting to ensure that I didn't have to monitor this.  To do this, I made the following change on the SharePoint application server:  Start, Control Panel, System, System Properties. Advanced Tab, Environment Variables, System Variables.  I added a System Variable called "LOGONSERVER" and I set it to DC03.

Sunday, August 19, 2012

Why Certain SharePoint Solutions Aren't The End Game

Generally speaking, as an organization matures, business processes often need to become more defined and standardized to facilitate repeatability and scalability.  Business processes may also  become more centralized out of necessity.  For example, if you have a lemonade stand on ten streets in town and each one is independently managed, the independent stands end up wasting a lot of time designing their own signs, figuring out how to process sales, and making trips to the grocery store.  If the lemonade stands centralize and standardize then perhaps there is only one group in charge of designing signs, and another group for stocking inventory, and another group for collecting the cash.  Each functional group can then serve the rest of the lemonade stands and the whole operation becomes much more efficient.


I believe that SharePoint has experienced a lot of success by helping companies get one step closer to the centralized and standardized model.  A sweet spot has been opportunities with ten independent lemonade stands.  I thing collaboration sites bridge a huge gap  at this stage when companies don't have mature processes in place, haven't figured out how to do things efficiently, and transactional systems are nowhere to be found.  Only after intentional progress and many waves of iteration will a company achieve great efficiency in such processes.  SharePoint helps in that progression...but I don't think that it is necessarily the end game in all cases.

One advantage to using SharePoint is it is quick and easy to get a solution up and running and the solution is probably a lot better than an email and document attachment process that was occurring before.  We can make successes in these situations and they are great steps forward.  If you read the Budgeting Portal Case Study you will see how SharePoint was used for Budgeting and Planning.  However, there comes a point where we need our process data to be completely integrated with other process data.  It needs to be relational.  It needs to be consistent.  And the ways we consume and produce the data electronically needs to be consistent and intuitive for us to achieve the level of efficiency that we are seeking.  Sometimes, our processes get to be too grown up for SharePoint, quite frankly.

The Budgeting Portal that I have been demonstrating at SharePoint Saturday events is only in SharePoint, temporarily.  Eventually, this is being moved to Hyperion Budgeting and Planning.  You see, a process that started off in email evolved to a document library in SharePoint.  Then it evolved again within SharePoint to include list data.  It continued to progress and get more sophisticated with custom databases, TSQL views and stored procedures, SSIS packages, SSRS reports, dashboards, and Data View Web Parts.  Then the practical limit within SharePoint was reached.  The data in the Budgeting Portal needed to be tied more closely to other financial data that could only be maintained in a financial system.  It became inevitable that this solution would need to become part of the overall financial system in order to facilitate the next wave of progression and efficiency.

Whether it is a lemonade stand or a budgeting and forecasting process, I believe that in many cases, we need to view SharePoint as a tool to help define a process, give it a place to become organized, mature it, and then transfer it to its permanent home.  I don't approach every project this way, but I am seeing this approach become more applicable and more common especially as transactional systems are becoming more flexible.  I believe that the core capabilities of ECM, collaboration, and social computing will eventually become very practical within CRM and ERP systems, which already provide business processes tuned for best practices and rigidity.  In the future, I believe that more and more SharePoint projects will be initiated, not with the purpose of being the end all, but rather with the purpose of promoting adoption of rigid processes in CRM and ERP.  SharePoint can help bridge the gap by being the interim solution where process discovery, definition, and initial improvements are made. 

SPS NYC: Case Study of a SharePoint 2010 Budgeting/Forecasting Portal


Event:
SharePoint Saturday New York City
Saturday, July 28, 2012

Session Title:
Case Study of a SharePoint 2010 Budgeting/Forecasting Portal

Abstract:
A professional services company required a company-wide budgeting solution in time to do year end budgeting, forecasting, and strategic planning.  The organization’s commercial off the shelf (COTS) finance system couldn’t fulfill the requirements.  Despite many resource and time constraints, a solution was developed and rolled out within 6 weeks using SharePoint Server 2010, a custom SQL Server database, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SharePoint Designer, and Data View Web Parts.  This session includes a demonstration of the solution as well as a walkthrough of the project approach and lessons learned.

Slides:

Case Study of a SharePoint 2010 Budgeting/Forecasting Portal.pdf

Monday, April 09, 2012

SPS Baltimore: Case Study of a SharePoint 2010 Budgeting/Forecasting Portal


Event:
SharePoint Saturday Baltimore
Saturday, May 12, 2012

Session Title:
Case Study of a SharePoint 2010 Budgeting/Forecasting Portal

Abstract:
A professional services company required a company-wide budgeting solution in time to do year end budgeting, forecasting, and strategic planning.  The organization’s commercial off the shelf (COTS) finance system couldn’t fulfill the requirements.  Despite many resource and time constraints, a solution was developed and rolled out within 6 weeks using SharePoint Server 2010, a custom SQL Server database, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SharePoint Designer, and Data View Web Parts.  This session includes a demonstration of the solution as well as a walkthrough of the project approach and lessons learned.

Slides:
Case Study of a SharePoint 2010 Budgeting/Forecasting Portal.pdf

Thursday, March 29, 2012

SPS Boston: Case Study of a SharePoint 2010 Budgeting/Forecasting Portal


Event:
SharePoint Saturday Boston
Saturday, April 28th, 2012

Session Title:
Case Study of a SharePoint 2010 Budgeting/Forecasting Portal

Abstract:
A professional services company required a company-wide budgeting solution in time to do year end budgeting, forecasting, and strategic planning.  The organization’s commercial off the shelf (COTS) finance system couldn’t fulfill the requirements.  Despite many resource and time constraints, a solution was developed and rolled out within 6 weeks using SharePoint Server 2010, a custom SQL Server database, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SharePoint Designer, and Data View Web Parts.  This session includes a demonstration of the solution as well as a walkthrough of the project approach and lessons learned.

Slides:
Case Study of a SharePoint 2010 Budgeting/Forecasting Portal.pdf

Blog Archive

Followers