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 [...]
Blog
Job Definitions Page: Object Reference not Set
I had to review some of my SharePoint 2010 job definitions to figure out why our social rating weren’t updating. So first place to look was the job definitions page. When I browsed there I got the dreaded “Object reference not set” error with not much more detail in the [...]
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 [...]
Selecting the right edition of SQL 2012 for the task
A bit of a long post today, but worth it, because probably the only thing more complicated than SharePoint…Microsoft Licensing: For most organizations, there are four editions of SQL Server 2012 to consider when using the product in its primary roles of database server, reporting server, or analysis or data-mining [...]
Hide Recently Modified Section on SharePoint 2010
When using the publishing and wiki features of SharePoint 2010 you can see the “Recently Modified” section on the left of the screen. As stated it shows the most recent pages that were edited. Although helpful from a development and configuration perspective it does easily confused users. Luckily it is [...]
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 [...]
Meeting Workspaces
Been a while but could not resist sharing this gem. Meeting workspaces has been around since SharePoint 2003/2007 and is a great way to integrate your day to day Office use with SharePoint (aptly named of course Office Server). Now even though I have had some serious challenges with meeting [...]
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 [...]