Stack Overflow
-
When you first start off trying to solve a problem, the first solutions you come up with are very complex, and most people stop there. But if you keep going, and live with the problem and peel more layers of the onion off, you can often times arrive at some very elegant and simple solutions.
– Steve Jobs, 2006They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety.
– Benjamin Franklin, 1775Homines, dum docent, discunt.
- SenecaTeach, Not Flame
- Kayaker Links
-
Recent Posts
- Solution for Samsung Galaxy S8+ not saving proxy settings on Android 9
- Generate POCOs.groovy – generate C# POCOs from table structure using JetBrains DataGrip
- Indenting code in Visual Studio Code with VSCodeVim plugin
- Bash script to rename files given a text file with new filenames
- ComHem TivoToGo krashar på iPad – lösning
Recent Comments
Archives
- August 2019
- January 2018
- June 2017
- September 2015
- June 2015
- October 2014
- September 2014
- August 2014
- March 2014
- June 2013
- January 2013
- October 2012
- June 2012
- May 2012
- January 2012
- December 2011
- November 2011
- September 2011
- August 2011
- June 2011
- April 2011
- December 2010
- November 2010
- August 2010
- July 2010
- June 2010
- February 2010
- October 2009
- April 2008
- October 2007
Categories
Meta
Category Archives: Work
Fixing “Value does not fall within the expected range” error in MOSS page settings
I wrote this script to correct the error I got from MOSS when trying to edit page settings. Our site uses an internal url (wwwint.mysite.com) and an external one (www.mysite.com). The page layout seemed to have been reset to use … Continue reading
Avoiding X.509 chain policy caching when using WCF with certificate security
A while ago my customer came to me with an issue that was a bit tricky to find a solution to. Their system uses a Windows forms client and a WCF service running on IIS7 on a Windows 2008 R2 … Continue reading
Field not found: CatalogResourceMajorVersion from Commerce Server 2007
So I was trying to troubleshoot this Biztalk 2006 R2 orchestration that includes importing some data into a Commerce Server 2007 instance. CS doesn’t really want to play ball, so I decide to upgrade it to the latest service pack … Continue reading
NULL values in SOAP requests
Question: how to pass a NULL value in a SOAP envelope? Answer: Use the xsi:nil=”true” attribute on the element, and don’t forget the xsi namespace in the envelope. Example SOAP request:
Listing subcategories for a category in Commerce Server 2007 using a SQL query
As promised, here is the follow-up to the last post. This query gets us the names of all subcategories of a particular category in Commerce Server 2007.
Listing categories for a product in Commerce Server 2007 using a SQL query
Commerce Server API is not exactly known for being lightning-fast, so sometimes you want to skip it altogether and just use plain old SQL to get the data. This time I needed to find all categories (at a particular level) … Continue reading
List does not exits in Sharepoint 2007 when accessing cache settings
When trying to access the cache settings in Sharepoint 2007 (Site Collection Administration section, Site collection output cache link). The error I got was: List does not exist The page you selected contains a list that does not exist. It … Continue reading
Dumping / restoring SQL Server data using Powershell
Sometimes you need to transfer data between two SQL Server databases. This Powershell 2.0 script might come in handy. It dumps one or all tables from the specified database to .DAT files and later restores them to another database with … Continue reading
IIS metabase not persisted at iisreset
iisreset forces shutdown of the IIS services and the information that got added to the metabase (using adsutil, WMI, ADSI etc) can get lost. There are two ways of fixing this: 1. Run C:WINDOWSsystem32IIsCnfg.vbs /save 2. net stop and then … Continue reading
Posted in Work
Leave a comment
Script for extracting SQL Server users, roles and role assignments
A nice little script to generate a script for extracting all users. roles and role memberships in a SQL Server database