SQL Server 2012 use all memory /memory leak

I have install SharePoint 2013 with Sql server 2012 for development and it run so slow. I found that Sql Server 2012 use alot of memory. It seem to be default how it behavior. There is a setting to lower it so there are free some memory for other application.

Use Sql Server Managment Studio and connect to sql server. Right click -> properties -> Memory and change Maximum server memory. In my case, i have 8 gig of ram. I put max is 3gig.

SharePoint 2013 Preview training for IT Pro

Module 1: SharePoint 2013 IT pro introduction and overview

1. Overview of SharePoint 2013 features and scenarios for IT pros
   Video | Presentation

Module 2: SharePoint 2013 system requirements

1. SharePoint 2013 system requirements
2. Video | Presentation

Module 3: SharePoint 2013 architectural changes

1. Creating routing and throttling rules in SharePoint 2013
   Video | Presentation
2. Overview of SharePoint 2013 analytics features and implementation
   Video | Presentation

Module 4: SharePoint 2013 server farms and site architecture planning

1. SharePoint 2013 distributed cache service
   Video | Presentation
2. SharePoint 2013 alternate access mapping and self-service site creation
   Video | Presentation
3. Change, test, and implement site collection themes in SharePoint 2013
   Video | Presentation
4. Overview of SharePoint 2013 sharing including requesting and viewing permissions
   Video | Presentation

Module 5: Office Web Apps 2013 architecture and deployment

1. Overview of Office Web Apps 2013
   Video | Presentation
2. Deploying Office Web Apps 2013
   Video | Presentation
3. Managing Office Web Apps 2013
   Video | Presentation

Module 6: SharePoint 2013 service application architecture and individual service applications

1. Compare SharePoint 2013 and SharePoint 2010 service application architectures
   Video | Presentation
2. SharePoint 2013 changes and features in Access services
   Video | Presentation
3. SharePoint 2013 changes and features in the apps management service application
   Video | Presentation
4. SharePoint 2013 changes and features in Business Connectivity Services
   Video | Presentation
5. SharePoint 2013 changes and features in Excel services
   Video | Presentation
6. SharePoint 2013 changes and features in the User Profile service application
   Video | Presentation
7. Walkthrough SharePoint 2013 features in the new machine translation service
   Video | Presentation
8. SharePoint 2013 changes and features in PerformancePoint services
   Video | Presentation
9. SharePoint 2013 changes and features in Visio services
   Video | Presentation
10. Walkthrough SharePoint 2013 features in the work management service application
    Video | Presentation
11. SharePoint 2013 changes and features in Word automation service
    Video | Presentation

Module 7: SharePoint 2013 enterprise search overview

1. SharePoint 2013 search architecture and topology changes and features
   Video | Presentation
2. SharePoint 2013 search crawl and content configuration changes and features
   Video | Presentation
3. SharePoint 2013 search query configuration changes and features
   Video | Presentation
4. SharePoint 2013 search results interface choices changes and features
   Video | Presentation

Module 8: SharePoint 2013 social features

1. Overview of SharePoint 2013 social features
   Video | Presentation
2. SharePoint 2013 community sites and forums
   Video | Presentation
3. SharePoint 2013 My Site architecture and administration
   Video | Presentation
4. SharePoint 2013 My Site feeds walkthrough
   Video | Presentation
5. SharePoint 2013 My Site follow walkthrough
   Video | Presentation
6. SharePoint 2013 My Site personal libraries walkthrough
   Video | Presentation
7. SharePoint 2013 My Site My Tasks walkthrough
   Video | Presentation

Module 9: SharePoint 2013 enterprise content management and web content management considerations

1. SharePoint 2013 Enterprise Content Management walkthrough
   Video | Presentation
2. SharePoint 2013 Web Content Management walkthrough
   Video | Presentation
3. SharePoint 2013 managed metadata walkthrough
   Video | Presentation

Module 10: SharePoint 2013 customization options and management

1. SharePoint 2013 app model and customization options
   Video | Presentation
2. SharePoint 2013 app infrastructure configuration and isolation
   Video | Presentation
3. Overview of the SharePoint 2013 renewed developer dashboard
   Video | Presentation
4. Setting up team development infrastructure for SharePoint 2013 development
   Video | Presentation
5. Using SharePoint 2013 Designer to create workflows in SharePoint 2013
   Video | Presentation

Module 11: SharePoint 2013 authentication and authorization overview

1. Claims-based authentication in SharePoint 2013
   Video | Presentation
2. oAuth authentication in SharePoint 2013
   Video | Presentation

Module 12: Overview of SharePoint 2013 business continuity management

1. Design considerations for business continuity management in SharePoint 2013
   Video | Presentation
2. SharePoint 2013 business continuity management features
   Video | Presentation

Module 13: Upgrading to SharePoint 2013

1. SharePoint 2013 upgrade methods and best practices walkthrough
   Video | Presentation
2. SharePoint 2013 upgrade planning tasks and preparation walkthrough
   Video | Presentation
3. SharePoint 2013 upgrade test tasks and options walkthrough
   Video | Presentation
4. SharePoint 2013 upgrade implementation tasks and options walkthrough
   Video | Presentation
5. SharePoint 2013 upgrade validation tasks walkthrough
   Video | Presentation

Module 14: What's new in Project 2013 for IT pros

1. Project 2013 overview for IT pros
   Video
2. Project Online overview
   Video
3. Project 2013 scalability and performance improvements
   Video
4. Project 2013 flexibility overview and improvements
   Video
5. Summary of what's new in Project 2013 for IT pros
   Video

From technet: http://technet.microsoft.com/en-US/sharepoint/fp123606

SharePoint 2013 Preview developer training

Module 1: Introduction to Office 2013 and SharePoint 2013 development

• New features for Office 2013 and SharePoint 2013 - Level 100
• App scenarios for Office 2013 and SharePoint 2013 - Level 100
• Development options for Office 2013 and SharePoint 2013 - Level 100

Module 2: SharePoint 2013 app model for developers

• Why apps for SharePoint 2013? - Level 200
• Introducing the app model for SharePoint 2013, Part 1 - Level 200
• Introducing the app model for SharePoint 2013, Part 2 - Level 200

Module 3: SharePoint 2013 developer tools

• Development model for apps for SharePoint 2013 - Level 200
• Design patterns for apps for SharePoint 2013 - Level 200
• Create SharePoint 2013 app projects - Level 200
• Package and deploy apps for SharePoint 2013 - Level 200

Module 4: Create hosted apps in SharePoint 2013

• SharePoint-hosted app model for SharePoint 2013 - Level 200
• SharePoint-hosted app model for SharePoint 2013 (Demo) - Level 200
• Using JavaScript and jQuery for SharePoint 2013 - Level 200
• Using JavaScript and jQuery for SharePoint 2013 (Demo) - Level 200
• SharePoint 2013 chrome control - Level 200
• SharePoint 2013 cross-domain calls - Level 200

Module 5: Create cloud-hosted apps for SharePoint 2013

• SharePoint 2013 app hosting models - Level 200
• Developer-hosted apps for SharePoint 2013 - Level 200
• Windows Azure auto-provisioned apps for SharePoint 2013 - Level 200

Module 6: SharePoint 2013 client object model (CSOM) and REST APIs

• SharePoint 2013 strategy for SharePoint client object model (CSOM) and REST - Level 200
• Programming SharePoint client object model (CSOM) with C# and JavaScript for SharePoint 2013 - Level 200
• SharePoint 2013 REST and Odata fundamentals - Level 200
• Making REST calls with C# and JavaScript for SharePoint 2013 - Level 200
• Making REST calls with C# and JavaScript for SharePoint 2013 (Demo) - Level 200

Module 7: OAuth and application identity in SharePoint 2013

• SharePoint 2013 application identity and permissions - Level 200
• Requesting and granting application permissions in SharePoint 2013 - Level 200
• SharePoint 2013 OAuth implementation - Level 200
• Authentication using server-to-server high trust in SharePoint 2013 - Level 200

Module 8: Develop SharePoint 2013 remote event receivers

• Introducing remote event receivers in SharePoint 2013 - Level 400
• Remote event receivers in SharePoint 2013 (Demo) - Level 400

Module 9: Workflow changes and features in SharePoint 2013

• SharePoint 2013 workflow architecture platform overview - Level 400
• Developing SharePoint 2013 workflows with SharePoint Designer - Level 400
• Developing SharePoint 2013 workflows with SharePoint Designer (Demo) - Level 200
• Developing SharePoint 2013 workflows with Visual Studio - Level 400
• Developing SharePoint 2013 workflows with Visual Studio (Demo)- Level 200

Module 10: Business connectivity services changes in SharePoint 2013

• SharePoint 2013 Business Connectivity Services and OData services overflow - Level 400
• App-level external content types for SharePoint 2013 - Level 400
• SharePoint 2013 custom event receivers - Level 400
• SharePoint 2013 custom event receivers (Demo) - Level 200

Module 11: Search features and changes in SharePoint 2013

• SharePoint 2013 Search overview - Level 400
• Executing queries in SharePoint 2013 - Level 400
• Executing queries in SharePoint 2013 (Demo) - Level 200
• Search verticals in SharePoint 2013 - Level 400
• Search verticals in SharePoint 2013 (Demo) - Level 200
• Search content parsing and web callouts in SharePoint 2013 - Level 400

Module 12: Enterprise content management changes in SharePoint 2013

• eDiscovery for SharePoint 2013 - Level 400
• Managed metadata service and taxonomy improvements in SharePoint 2013 - Level 400

Module 13: Web content management changes and features in SharePoint 2013

• SharePoint 2013 web content management platform improvements - Level 400
• SharePoint 2013 web content management platform improvements (Demo) - Level 200
• SharePoint 2013 web content management content authoring - Level 400
• SharePoint 2013 web content management content by search web part - Level 200
• SharePoint 2013 custom branding sites - Level 200
• SharePoint 2013 custom branding sites (Demo) - Level 200
• Usage analytics and multilingual enhancements in SharePoint 2013 - Level 200

Module 14: Social features in SharePoint 2013

• SharePoint 2013 social overview and MySite - Level 400
• SharePoint 2013 social overview and MySite (Demo) - Level 200
• SharePoint 2013 microfeed overview - Level 400
• SharePoint 2013 communities overview - Level 400

Module 15: Office services in SharePoint 2013

• Excel Services for SharePoint 2013 - Level 400
• Word Automation Services for SharePoint 2013 - Level 400
• PowerPoint Automation Services for SharePoint 2013 - Level 400
• SharePoint 2013 Translation Services - Level 400

Module 16: Create mobile apps for SharePoint 2013

• SharePoint 2013 mobile development basics - Level 200
• Creating mobile apps with SharePoint 2013 (Demo) - Level 200
• Understand and develop push notifications in SharePoint 2013 - Level 200
• Understand and develop location-aware apps in SharePoint 2013 - Level 200

Module 17: Develop apps for Office 2013

• Intro to Apps and Web Extensibility Framework (WEF) for Office 2013 - Level 100
• Apps for Office 2013 Visual Studio 11 tools - Level 100
• Develop task pane apps for Office 2103 with Visual Studio 11 (Demo) - Level 100
• Develop content apps for Office 2013 with Visual Studio 11 (Demo) - Level 100
• Develop mail apps for Office 2103 with Visual Studio 11 (Demo) - Level 100
• Package and deploy Office 2013 - Level 100
• Design and theme apps for Office 2013 - Level 100

Module 18: Project Server 2013 training for developers

• Project Server 2013 developer overview - Level 200
• Getting up to speed with Project Server 2013 extensibility (Demo) - Level 300
• Project Server 2013 extensibility summary - Level 200

From Microsoft: http://msdn.microsoft.com/en-US/sharepoint/fp123633

SharePoint 2013 Preview Intro (New/Change/Improve)

Change / Improve

• Office Web App is no longer a service application. It is now a stand alone product
• Web Analytics is no longer service application, it part of search
• ECM
• Site level retention policies
• • Retention policy
  • Project closure and expiration policy
• Discovery Center
• eDiscovery
• Team folders
• Web Content Management
• SEO
• Cross Site Publishing
• Video & Embedding
• Image rendition
• Clean Urls
• Metadata navigation
• Social
• User experience redesign
• integrate task into mysite from EXCHANGE, MOBILE, OUTLOOK and PROJECT
• Better discussion board
• Seach
• New search architecture with one unified search
• Rich contenxtual preview
• Peronalized search results base on search history
• Business Intelligence
• Excel BI
• Powerview add-in
• In Memory BI engine
• Excel service improved
• Performance Services
• Filter enchancements and Filter search
• Dashboard migration (move dash board from one enviroment to another)
• Support for Analysis Services Effective User (eliminate kerberos delegation need)
• Visio Services
• Support VCS and Azure Sql
• collobration live with services
• Mobile
• Automatic mobile Browser redirection
• Push notifications
• Customization
• App

New

• New Service Application introduce (machine translate service, apps management services and work management service)
• App model

Calendar or List view filter base on workflow status. Workflow status values

When working with sharepoint list view filter, You can not filter workflow status by text/string like "Approved", "Rejected" .... you have to put in the actual value. See table below.

Status	Value
Not Started	0
Failed on Start	1
In Progress	2
Error Occurred	3
Canceled	4
Completed	5
Failed on Start (retrying)	6
Error Occurred (retrying)	7
Canceled	15
Approved	16
Rejected	17

SharePoint 2010 short url

This is useful if you have a long link or if you have an external site and use link on twitter. This is completely free from codeplex.

Troubleshoot User Profile Sync in SharePoint 2010 Digagram

This diagram help troubleshoot issue with profile sync. Thanks to Henrik Halmstrand