Overview: Technet news flash email letter announced the release of SQL Server 2008 Service Pack 2 today. I think it's been out a few days.
http://go.microsoft.com/fwlink/?LinkId=196550
I have installed on my development machine - no issues. If you are on Windows 2008 upgrade to SP2. New installs should still use SQLServer 2008 R2 and ignore this Service Pack.
Thursday 7 October 2010
Wednesday 6 October 2010
jQuery intellisense
Problem: jQuery is pretty useful and I'm not great at creating it.
Hypothesis: I am using jQuery version jquery-1.4.2.js to get intellisence I need to reference jquery-1.4.1-vsdoc.js, this should be removed at deployment. You can reference the Visual Studio jQuery Intellesense file (jquery-1.4.1-vsdoc.js) either from microsoft's CDN or deploy locally to the 14 hive.
References:
http://weblogs.asp.net/scottgu/archive/2008/11/21/jquery-intellisense-in-vs-2008.aspx
http://www.devcurry.com/2010/02/visual-studio-jquery-intellisense-over.html
Samples:
Get the input from a multiline text box/Textarea
var existingComments = $("[id*='txtComments']").val();
Explaination - txt comments is an text box namely: asp:TextBox runat="server" ID="txtCommentsAmend" TextMode="MultiLine". val() gets the inner html/content.
Append additional data to the text box
$("[id*='txtCommentsAmend']").html(existingComments + 'more info');
Explaination - using the previous example variable append additional text in the textbox.
Hypothesis: I am using jQuery version jquery-1.4.2.js to get intellisence I need to reference jquery-1.4.1-vsdoc.js, this should be removed at deployment. You can reference the Visual Studio jQuery Intellesense file (jquery-1.4.1-vsdoc.js) either from microsoft's CDN or deploy locally to the 14 hive.
References:
http://weblogs.asp.net/scottgu/archive/2008/11/21/jquery-intellisense-in-vs-2008.aspx
http://www.devcurry.com/2010/02/visual-studio-jquery-intellisense-over.html
Samples:
Get the input from a multiline text box/Textarea
var existingComments = $("[id*='txtComments']").val();
Explaination - txt comments is an text box namely: asp:TextBox runat="server" ID="txtCommentsAmend" TextMode="MultiLine". val() gets the inner html/content.
Append additional data to the text box
$("[id*='txtCommentsAmend']").html(existingComments + 'more info');
Explaination - using the previous example variable append additional text in the textbox.
Saturday 2 October 2010
Powershell to Move a Site Collection to a new Content Database
Problem: I have several site collections inside a single content database. The content database is growing rapidly. Backup and restore is fairly slow and SQL can start slowing down if the db is large enough.
Hypothesis: Create at least additional content db, move specific site collections to the new Content database. I was surprised that moving site collections to content databases is not in the Central Admin (CA) UI.
Resolution: Create an additional content database either using PowerShell (PS) or the UI namely:
1.> CA > Application Management > Manage Content Databases > Add a Content Database (I called my content database "WSS_Content_Empty").
2.> Move the Site collection to the new content database using PS
3.> Check the database has been moved in CA
More Info:
http://technet.microsoft.com/en-us/library/cc825328.aspx
Set New Content Database using CA Only:
Hypothesis: Create at least additional content db, move specific site collections to the new Content database. I was surprised that moving site collections to content databases is not in the Central Admin (CA) UI.
Resolution: Create an additional content database either using PowerShell (PS) or the UI namely:
1.> CA > Application Management > Manage Content Databases > Add a Content Database (I called my content database "WSS_Content_Empty").
2.> Move the Site collection to the new content database using PS
More Info:
http://technet.microsoft.com/en-us/library/cc825328.aspx
Set New Content Database using CA Only:
- UI only option to achieve the same result would be to create the new content database using CA as shown above.
- Next using CA go to "Manage Content Databases", select the old/existing content database and set it to offline (This means that you can't add new content databases, existing site collections are still available).
- Adding a new Site Collection will now use the new/next content database that is ready/online.
End of Post
Backup and Restore Powershell commands:
if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null) {
Add-PSSnapin "Microsoft.SharePoint.PowerShell"
}
cls
Backup-SPSite -Identity 'http://my.demo.dev/sites/kbtest' -Path C:\Projects\Backup\test.bak -Force -NoSiteLock -UseSqlSnapshot -Verbose
Restore-SPSite -Identity 'http://my.demo.dev/sites/newkbtest' -Path C:\Projects\Backup\test.bak -Force -Verbose
Friday 1 October 2010
Save site as template link missing in site settings
Problem: You want to create an WSP for your site however, the "Save site as template" link is missing from the "Site Settings" page as shown below.
Hypothesis: Deactivate the Publishing features namely: Manage Site features > Sharepoint Server Publishing & Site Collection features > SharePoint Server Publishing Infrastructure. You know have the ability to create site templates i.e. wsp files. The problem is you don't have your publishing infrastructure.
Resolution: If publishing is enabled on your site, craft a url so you can create the wsp file. Url is http://demo/_layouts/savetmpl.aspx
Resolution: If publishing is enabled on your site, craft a url so you can create the wsp file. Url is http://demo
Tip: You can only include up to 50 MB of contentin SP2010
SP2010 Connections Conference in The Hague - Day 2
Managed Meta data in custom solutions by AC was a real eye opener. Managed Metadata Service (MMS) is very powerful and i need to be using it to a much greater degree. AC's earlier talk on WCM was interesting but not a technical discussion but we were warned so not AC's fault.
Mirjam van Olst gave a presentation on Logging, Monitoring & throttling. It's the 1st time I've been to 1 of her presentations and I was hugely impressed she really knows her stuff.
Dan Holme gave a good session on Information Architecture (IA) and the MMS. Useful as after AC's session i decided i definatelty needed more MMS info.
The last session I went to Wouter van Vugt's session on Access Services - Access services could potentially be huge in SP2010 and it was good to see a techy like Wouter highlight what it was good and bad at.
Generally a good day and a good conference. Not exactly Vegas 2009 or even Berlin 2007 in quality but worth the trip and met some nice people that are really passionate about SharePoint.
Mirjam van Olst gave a presentation on Logging, Monitoring & throttling. It's the 1st time I've been to 1 of her presentations and I was hugely impressed she really knows her stuff.
Dan Holme gave a good session on Information Architecture (IA) and the MMS. Useful as after AC's session i decided i definatelty needed more MMS info.
The last session I went to Wouter van Vugt's session on Access Services - Access services could potentially be huge in SP2010 and it was good to see a techy like Wouter highlight what it was good and bad at.
Generally a good day and a good conference. Not exactly Vegas 2009 or even Berlin 2007 in quality but worth the trip and met some nice people that are really passionate about SharePoint.
Tuesday 28 September 2010
SP2010 Connections Conference in The Hague - Day 1
Keynote by Steve Fox was good but felt too sales orientated. It's always hard to deliver a keynote at a technical conference with the variety of attendees. So overall not the worst and it covered a lot from previous conferences so not much new information outside of prepare for Azure with SharePoint. Also SP1 for SharePoint 2010 will be available sometime in 2011 Q1.
Andrew Connell - AC is always good value however today he had a problem with his laptop/VM and the demos didn't work, still a good presentation on building RIA Rich Internet Applications or as the slide read "Rich Business Applications". Looked at 2 demos for building RIAs using Silverlight client object model vs Restful web services (*.svc), nothing ground breaking but useful if you are new to using the Client Object model.
Michael Noel's session on on Disaster Recovery & High Availability cover load balancing (use sticky sessions, Hardware is better than Sw load balancing), search options and improvements of MOSS search, SQL clustering and mirroring, use SQL alias's for pointing your farm at the db, common farm architectures, SP2010 and virtualisation (not ideal for SQL server), 3types of mirroring, Split content db's but not too small, Backup options and i need to review MS's DPM product.
Went to Andrew Connell's LINQ to SharePoint 201 Best practices. Key takeaway is SPMetal only works on native SP Foundation types, M+LINQ to SharEPoint can be extended as it is implemented using partial classes, the iCustomise interface helps extend SPMEtal for more complex types such as Html fields and Metadata.
See Razvan-Petru Radu conference notes
Andrew Connell - AC is always good value however today he had a problem with his laptop/VM and the demos didn't work, still a good presentation on building RIA Rich Internet Applications or as the slide read "Rich Business Applications". Looked at 2 demos for building RIAs using Silverlight client object model vs Restful web services (*.svc), nothing ground breaking but useful if you are new to using the Client Object model.
- SharePoint apparently in it's page headers returns how busy the SharePoint server is with a number between 1-10, 10 being very busy. You can see this in fiddler.
- Anonymous user sites should generally use RESTful WS rather than Client OM/Silverlight as you need authentication.
Michael Noel's session on on Disaster Recovery & High Availability cover load balancing (use sticky sessions, Hardware is better than Sw load balancing), search options and improvements of MOSS search, SQL clustering and mirroring, use SQL alias's for pointing your farm at the db, common farm architectures, SP2010 and virtualisation (not ideal for SQL server), 3types of mirroring, Split content db's but not too small, Backup options and i need to review MS's DPM product.
Went to Andrew Connell's LINQ to SharePoint 201 Best practices. Key takeaway is SPMetal only works on native SP Foundation types, M+LINQ to SharEPoint can be extended as it is implemented using partial classes, the iCustomise interface helps extend SPMEtal for more complex types such as Html fields and Metadata.
See Razvan-Petru Radu conference notes
Monday 27 September 2010
SharePoint 2010 BCS workshop with Scot Hillier
Overview: attended a workshop on Business Connectivity Services (BCS) given by Scot Hillier in Den Haag (The Hague). I have used BDC in MOSS and the BCS in SP2010 briefly. I can honestly say I am now a BCS convert. I know BCS was an improvement on BDC but looking at the tooling and going building advanced BCS solutions is really powerful and covers a lot more that I understood or had seen in a previous demo.
Summary:
BCS versions feature table
Summary:
- Office can use BCS - pretty obvious but I didn't realise the client application goes straight from the client application i.e. work/outlook to the SQL/WCF/.NET data type directly.
- Double hop issue with NTLM. Scot laid out a table to direct the options available for various scenarios that I will hopefully post here.
- Secure Store Service is extensively used for authentication in BCS.
- SPD has a good tool set for BCS. Probably the place to start.
- SQL 2000 doesn't work as an External Content Type (ECT) - this needs verification.
- BCS doesn't support transactions and is not strongly typed however data access options can be intermingled to get transaction functionality if you need it.
BCS versions feature table
Subscribe to:
Posts (Atom)