<?xml version="1.0" encoding="UTF-8"?><rss version="0.92">
<channel>
	<title>entwicklungsgedanken</title>
	<link>http://www.entwicklungsgedanken.de</link>
	<description>Verschiedene Gedanken rund um die Softwareentwicklung</description>
	<lastBuildDate>Thu, 29 Jul 2010 11:09:20 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	<!-- generator="WordPress/3.0" -->

	<item>
		<title>Solving NULL values are recognized as text-values within dynamic queries in PostgresSQL</title>
		<description><![CDATA[I&#8217;ve written a dynamic query which is finally executed via EXECUTE my_dynamic_query; The query contained a select list in which two columns should always be NULL. -- ... stuff before dynamic_select_cols := 'tbl1.foo, tbl1.bar, null AS theAlias1, null AS theAlias2, tbl2.foo2'; -- ... stuff after combining the dynamic queries EXECUTE my_dynamic_query; In my case the [...]]]></description>
		<link>http://www.entwicklungsgedanken.de/2010/07/29/solving-null-values-are-recognized-as-text-values-within-dynamic-queries-in-postgressql/</link>
			</item>
	<item>
		<title>Using a C# preprocessor directive for testing custom timer-jobs</title>
		<description><![CDATA[If your are writing custom timer-jobs for your SharePoint solution it will happen that you write jobs which are only executed once a day or even less often. As a developer you cannot wait that long&#8230; You could of course comment in and out (via ctrl + k, ctrl + c / ctrl + k, [...]]]></description>
		<link>http://www.entwicklungsgedanken.de/2010/07/22/using-a-c-preprocessor-directive-for-testing-custom-timer-jobs/</link>
			</item>
	<item>
		<title>Configure the symfony-mailer (swiftmailer) during runtime</title>
		<description><![CDATA[One of my current projects is a multi-client environment. Each client has its own smtp-settings for the mailings that are done within that application. From static &#8230; Symfony allows the configuration of the mailer in its factories.yml. There smtp-settings can be definied. But in this case this is impossible as every client has different smtp-settings [...]]]></description>
		<link>http://www.entwicklungsgedanken.de/2010/05/03/configure-the-symfony-mailer-swiftmailer-during-runtime/</link>
			</item>
	<item>
		<title>Meeting workspaces in SharePoint 2010 / Office 2010. A disappointment.</title>
		<description><![CDATA[SharePoint 2010 RTM (and its Foundation) are available for awhile now. After installing SharePoint Foundation I immediately took a look into the meeting workspaces. No improvements since the Beta! Not all lists support the new AJAX-Dialogs. The page-management (for multi-paged workspaces) is still the same as in 2007. Even some old (SP 2007) graphics appear. [...]]]></description>
		<link>http://www.entwicklungsgedanken.de/2010/04/29/meeting-workspaces-in-sharepoint-2010-office-2010-a-disappointment/</link>
			</item>
	<item>
		<title>WITH-Klausel</title>
		<description><![CDATA[In der Praxis trifft man von Zeit zu Zeit auf aufgeblaehte SQL-Queries, die ausserordentlich kostenintensiven und langwierigen Ausfuehrungsplaenen folgen. Zeigt eine weitergehende Analyse, dass die komplexe Abfrage eine oder mehrere Subqueries enthaelt, die mehrfach ausgefuehrt werden, dann besteht eine sehr gute Chance durch Verwendung der sogenannten WITH-Klausel, die Performance der Abfrageausfuehrung erheblich zu steigern. Im [...]]]></description>
		<link>http://www.entwicklungsgedanken.de/2010/04/15/with-klausel/</link>
			</item>
	<item>
		<title>MIN, MAX innerhalb eines SELECT-Statement</title>
		<description><![CDATA[Manchmal benötigten man sowohl den kleinsten (min) als auch den größten (max) Wert einer indizierten Spalte gleichzeitig. SELECT MIN(id) , MAX(id) FROM big_table Bei diesem SELECT kommt zwar das richtige Ergebnis, dennoch kann die Antwortzeit sehr lange dauern. Der Grund liegt in einem FAST FULL INDEX SCAN. Besser ist folgendes: SELECT MIN(id) min_value FROM big_table [...]]]></description>
		<link>http://www.entwicklungsgedanken.de/2010/04/05/min-max-innerhalb-eines-select/</link>
			</item>
	<item>
		<title>Blockierende SQL-Session</title>
		<description><![CDATA[Folgendes SQL-Statement kann man verwenden wenn man prüfen möchte ob es blockierende Sitzungen gibt. SELECT , b.username blocking_username , b.osuser blocking_osuser , b.machine blocking_machine , b.program blocking_program , w.sid waiting_sid , w.username waiting_username , w.osuser waiting_osuser , w.machine waiting_machine , w.seconds_in_wait FROM v$SESSION w , v$SESSION b WHERE w.blocking_session is not NULL AND b.sid = [...]]]></description>
		<link>http://www.entwicklungsgedanken.de/2010/04/05/blockierende-sql-session/</link>
			</item>
	<item>
		<title>Sortierung von hierachischen B&#228;umen</title>
		<description><![CDATA[Oft hat man die Anforderung hierachische Bäume sortiert darzustellen. Am besten soll die Sortierung auch jederzeit geändert werden können. Folgendes Beispiel soll die einfache Lösung aufzeigen: SELECT a.id , a.parent_id , a.label , a.sort FROM menu_tree a ORDER BY 2 nulls first,1 &#160; ID PARENT_ID LABEL SORT 1 &#160; Anwendung 1 2 1 Hilfsdaten 2 [...]]]></description>
		<link>http://www.entwicklungsgedanken.de/2010/04/05/sortierung-von-hierachischen-bumen/</link>
			</item>
	<item>
		<title>How to install postgres 8.4 on Debian 5 (lenny)</title>
		<description><![CDATA[Because I didn&#8217;t found this information in one place I&#8217;m writing this quick &#8220;guide&#8221; on how to install PostgreSQL 8.4.x on Debian 5.x &#8220;lenny&#8221;. Debian lenny stable packages are bundled with Postgres 8.3.x but thanks to Debian Backports the newer Postgres version is available for lenny. Simply do it Add the backports-sources (/etc/apt/sources.list) and update [...]]]></description>
		<link>http://www.entwicklungsgedanken.de/2010/03/06/how-to-install-postgres-8-4-on-debian-5-lenny/</link>
			</item>
	<item>
		<title>Updating existing lookup fields in SharePoint</title>
		<description><![CDATA[Creating lookup-fields only via XML-Definition is not possible. You need the ID of the Web hosting the list and the ID of the list hosting the data the lookup field is connected to. This information can only be retrieved when both entities are created… Object model?! When looking into the SPFieldLookup-class you find the properties [...]]]></description>
		<link>http://www.entwicklungsgedanken.de/2010/02/01/updating-existing-lookup-fields-in-sharepoint/</link>
			</item>
</channel>
</rss>
