SharePoint Saturday Sacramento 2011 Web Part Presentation

I presented on Web Part Development and SPMetal at the conference.  Thanks for all who showed up and please remember to connect with me and leave any feedback on my LinkedIn Page.

In addition to my speaking engagement, I attended the following sessions:

• Building the Perfect SharePoint 2010 Farm: Real World Best Practices from the Field
• Michael Noel (MVP)
• The Collaboration Experience
• Talia Israel
• SharePoint Street Smart - Delivering Content to Mobile Devices and Tablets
• Kenneth Lo
• Metadata: Simple to Sublime
• Andy Coyle

Here are the Presentation Slides, Notes, and Code Files

Column Validation Formula - Phone Number

Scenario

• You need to force a formatting convention for phone numbers in a list using the list's column validation formulas.

Issue

• Regular Expressions are not supported. :(

Resolution

• You must build your functions using Excel 2010 formulas
• Example for (555) 555-5555 format on a column named "CELL PHONE"
• =AND(IF(ISERROR(FIND("(", [CELL PHONE],1)), FALSE, (FIND("(", [CELL PHONE]) = 1)), IF(ISERROR(FIND(")", [CELL PHONE],5)), FALSE, (FIND(")", [CELL PHONE], 5) = 5)), IF(ISERROR(FIND(" ", [CELL PHONE],6)), FALSE, (FIND(" ", [CELL PHONE], 6) = 6)), IF(ISERROR(FIND("-", [CELL PHONE],10)), FALSE, (FIND("-", [CELL PHONE], 10) = 10)),IF(ISERROR(1*CONCATENATE(MID([CELL PHONE], 2, 3), MID([CELL PHONE], 7, 3), MID([CELL PHONE], 11, 4))), FALSE, AND(1*CONCATENATE(MID([CELL PHONE], 2, 3), MID([CELL PHONE], 7, 3), MID([CELL PHONE], 11, 4)) > 1000000000, 1*MID([CELL PHONE], 2, 3) <> 911, 1*MID([CELL PHONE], 7, 3) <> 911)))
• You must use your column name instead of "CELL PHONE"
• Includes checks for 911

FREE SharePoint Saturday Conference Coming to Sacramento

I will be presenting on Web Parts and SP Metal.  Come out and learn SharePoint for FREE!
http://sharepointsaturday.org/sacramento/default.aspx

External Content Type Picker stale or missing entries

Scenario

• You have deleted and/or added some External Content Types to Business Connectivity Services
• You attempt to use the External Content Type Picker via a Chart Web Part or some other control
• You correctly see the external content types in SharePoint Designer and in the Central Admin BCS Service Application screens

Issue

• You see deleted External Content Types and/or do not see the newly added External Content Types

Resolution

• Reset IIS on the SharePoint Server(s)
• App pool recycle does not work

Attending Microsoft Cloud Intelligence #CloudIntel Conference

Session Notes

• Bob McDowell - Keynote
• Platform as a service: Windows Azure - Joel Forman
• CDN: Content Delivery Network
• Caches commonly used files in geographically appropriate locations
• Configure for specific static files: media, css, js, etc.
• Each file has a CDN url
• Windows Azure Traffic Manager
• Geographically dispersed Domain resolution forwarding
• Forwards domain requests to appropriate servers by location
• Windows Azure Storage
• File hosting
• SharePoint 2010 Online - Atul Totre
• Dedicated SharePoint Online available for over 5,000 users
• Online Standard Infrastructure Limits
• 10 GB base + 500 MB per user account
• 100 GB max per site collection
• 300 site collection max
• 1 TB storage max per tenant up to 5TB
• 250MB file upload size
• 500 MB per MySite (separate from Site Collections)
• Backups: every 12 hours for 14 days retention
• Management with System Center - Rand Morimoto of CCO
• Configuration Manager (SCCM)
• Patching servers and OS's
• Deploying images/VMs
• Scheduled downtime patching and system grouping
• Quest Management Xtensions - Allow patching non-MS devices, Apple, mobile, etc.
• Operations Manager (SCOM)
• Monitoring
• Plugins: Cisco, SalesForce cloud, Office 365, VMware, etc.
• Logical service grouping
• Monitoring Agents: Run scripted scenarios remotely for client response time monitoring
• Dashboards
• VM Manager (SCVMM)
• Migration to Hyper-V
• Rapid PowerShell provisioning
• Automated Live Migration based on guest session utilization
• Self-service VM Guest Session creation - user's can automatically create VMs
• Data Protection Manager (SCDPM)
• File system, Exchange, SQL, SharePoint, Hyper-V Host/Guest, Windows 7
• Incident Management, Self Service Portal and Password Reset
• Opalis
• Workflow type GUI instead of scripting
• 2012 planned features
• Provision Hyper-V Host
• Cloud based monitoring (Azure)
• Server App-V Application Virtualization
• Application bubble isolates application install from OS
• PaaS Developer Tooling - Bruno Terkaly
• Windows Azure
• Compute
• Web Roles
• Worker Roles
• Storage
• Tables, Blobs, and Queues
• Tables are unlimited scalability, but not relational
• SQL Azure
• App Fabric
• Tools
• SQL Server Management Studio
• http://windows.azure.com web interface
• Visual Studio cloud projects