SQL Server: HDD vs SSD
Nice article on SQL Server running on a HDD vs a SSD. I am sure there are loads of more technical articles available, but nice to read something simple and to the point: The effects of an SSD on SQL Server Performance [...]
jquery ajax return value limit
I have been playing a bit with jquery and ajax and came across a very interesting “by design” issue. I built a simple responsive HTML page that populates a data table via a ajax service that returns a JSON string. Everything worked fine until I tried populating a slightly bigger [...]
Find something in a Stored Procedure
Forgive me if this is something old (like using a…well using statement in SQL). I remember a time when you had to download some obscure freeware application to scan through all your stored procedures to find references to some text or table. Years after I was faced with just this [...]
SharePoint SQL Queries
Some useful SQL queries to get web, site and list data: 1) Query to get all the top level site collections SELECT SiteId AS SiteGuid, Id AS WebGuid, FullUrl AS Url, Title, Author, TimeCreated FROM dbo.Webs WHERE (ParentWebId IS NULL) 2) Query to get all the child sites in a [...]
1 oz C#, 2 oz PHP
Thought I would add some PHP your way. Let’s say we have a C# web service (most are :)) that you want to call from PHP. Now there are ways to handle complex types returned but the easiest way is to return a string. Even then you cannot just assign [...]
SSRS and IncludeExceptionDetailInFaults ServiceBehaviorAttribute
I’ve been having some fun and games with Sharepoint 2010 and SSRS. One of the most frustrating things of working with Sharepoint is the lack of consistent error handling and tracing. You are never sure where the errors are logged which can make troubleshooting tough. My problem was related to [...]
Internet Explorer and port 220
A classic case of “a Microsoft update broke my server”. We have a web service hosted on port 220 on IIS. The web service is used extensively and has been working for about 4 years without any hazzles. At the begging of the month as per normal process our IT [...]
Active Directory LastLogonDate
Ok, so I know this has nothing to do with Sharepoint, but it’s one of those things that gets geeks excited and should be shared. We often integrate and work with Active Directory and today we needed to see when a user last logged onto the domain. Now I am [...]
WCF Services and Web Parts
This post will cover how to use and call WCF services without complicated methods to update your web.config\app.config. When you add a WCF service reference to your code it generates all the endpoints in your project’s app.config file. For web parts this is a problem as each web part does [...]
Invalid data has been used to update the list item
I thought over the next couple of weeks I can share some development\coding topics on Sharepoint 2010. Starting with: “Invalid data has been used to update the list item. The field you are trying to update may be read only” This error is usually occurs when updating or creating a [...]