<?xml version="1.0" encoding="UTF-8"?><rss version="0.92">
<channel>
	<title>appytizers</title>
	<link>http://www.rohand.com</link>
	<description>the book of i</description>
	<lastBuildDate>Fri, 13 Aug 2010 16:37:52 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	<!-- generator="WordPress/3.0.1" -->

	<item>
		<title>COUNT(*) All DB2 Tables</title>
		<description><![CDATA[Here&#8217;s a succinct way of generating SELECT COUNT(*) against all tables in a DB2 database. SELECT 'SELECT COUNT(*) AS COUNT_' &#124;&#124; TABLE_NAME &#124;&#124; ' FROM ' &#124;&#124; TABLE_SCHEMA &#124;&#124; '.' &#124;&#124; TABLE_NAME FROM sysibm.TABLES ORDER BY TABLE_NAME This returns output like the following: SELECT COUNT(*) AS COUNT_ADVISE_INDEX FROM DB2INST.ADVISE_INDEX SELECT COUNT(*) AS COUNT_ADVISE_WORKLOAD FROM DB2INST.ADVISE_WORKLOAD]]></description>
		<link>http://www.rohand.com/2010/count-all-db2-tables/</link>
			</item>
	<item>
		<title>Resize an Image in C#</title>
		<description><![CDATA[This function will let you resize an image in C#. public static Bitmap Resize(Bitmap original, int width, int height) { Bitmap bitmap = new Bitmap(width, height); using (Graphics gfx = Graphics.FromImage(bitmap)) { gfx.InterpolationMode = Drawing2D.InterpolationMode.HighQualityBicubic; gfx.SmoothingMode = Drawing2D.SmoothingMode.HighQuality; gfx.PixelOffsetMode = Drawing2D.PixelOffsetMode.HighQuality; gfx.CompositingQuality = Drawing2D.CompositingQuality.HighQuality; gfx.DrawImage(original, 0, 0, width, height); return bitmap; } }]]></description>
		<link>http://www.rohand.com/2010/resize-an-image-in-c/</link>
			</item>
	<item>
		<title>Why is mcshield.exe Running with High Priority?</title>
		<description><![CDATA[After weeks of putting up with significant disk activity and system slowness, I finally noticed that the McAfee anti-virus On Access Scanner process &#8211; mcshield.exe – was running as a High Priority process in Task Manager. The fix was simple: Open Task Manager Switch to the Processes tab Find mcshield.exe Right-click → Set Priority → [...]]]></description>
		<link>http://www.rohand.com/2010/why-is-mcshield-exe-running-with-high-priority/</link>
			</item>
	<item>
		<title>List Stored Procedures with Contents in SQL Server</title>
		<description><![CDATA[I needed to get a list of all stored procedures that accessed a specific column in a table. Some stored procedures generated dynamic SQL statements so the View Dependencies feature was not guaranteed to get me the full list. This query lets me retrieve the name and body of all stored procedures in a database. [...]]]></description>
		<link>http://www.rohand.com/2010/list-stored-procedures-with-contents-in-sql-server/</link>
			</item>
	<item>
		<title>Find All Rows in Table1 That Are Not in Table2 Using JOIN</title>
		<description><![CDATA[To find all rows that are in dbo.TABLE1 but not in dbo.TABLE2 using the SQL JOIN operator: SELECT COUNT(*) FROM dbo.TABLE1 t1 WITH (NOLOCK) LEFT OUTER JOIN dbo.TABLE2 t2 WITH (NOLOCK) ON t1.PrimaryKey = t2.PrimaryKey WHERE t2.PrimaryKey IS NULL]]></description>
		<link>http://www.rohand.com/2010/find-all-rows-in-table1-that-are-not-in-table2-using-join/</link>
			</item>
	<item>
		<title>SQL 2008 &#8211; Manage DTS Packages</title>
		<description><![CDATA[I installed the SQL Server 2008 Feature Pack to get the DTS components for SQL Server Management Studio 2008. However, the IDE continued to error until I copied the following files from the SQL Server 2000 manager to the SQL 2008 Manager folders. You need to have SQL 2000 Enterprise Manager installed on the same [...]]]></description>
		<link>http://www.rohand.com/2010/sql-2008-manage-dts-packages/</link>
			</item>
	<item>
		<title>Do Not .IndexOf Without Further Checks</title>
		<description><![CDATA[Do not do this: if (&#34;A,B,C,D,E&#34;.IndexOf(key) &#62; -1) { // CODE REDACTED } If key is an empty string, the result is 0 and the code in the IF block is executed. This is probably not what you expected.]]></description>
		<link>http://www.rohand.com/2010/do-not-indexof-without-further-checks/</link>
			</item>
	<item>
		<title>Google AppEngine</title>
		<description><![CDATA[I have an application concept in my head and wanted to build it for Google AppEngine. The AppEngine SDK is offered in two flavors: Python and Java. I wasn’t really sure which SDK to pick. Python has been supported since Day One – it has the most examples and the best API support. In addition, [...]]]></description>
		<link>http://www.rohand.com/2010/google-appengine/</link>
			</item>
	<item>
		<title>Welcome to 2010</title>
		<description><![CDATA[Happy New Year! Here’s wishing everyone a wonderful and exciting 2010.]]></description>
		<link>http://www.rohand.com/2010/welcome-to-2010/</link>
			</item>
	<item>
		<title>Created on a Slate PC</title>
		<description><![CDATA[This post was created on a Slate PC &#8211; a Motion Computing LE1600 -running Windows 7 and &#34;typed&#34; using the handwriting recognition very very quickly :) I AM Impressed!]]></description>
		<link>http://www.rohand.com/2009/created-on-a-slate-pc/</link>
			</item>
	<item>
		<title>DB2 System Properties</title>
		<description><![CDATA[These calls will retrieve DB2 system properties. SELECT * FROM TABLE(SYSPROC.ENV_GET_INST_INFO()) AS Instance_Info GO SELECT * FROM TABLE(SYSPROC.ENV_GET_PROD_INFO()) AS Product_Info GO SELECT * FROM TABLE(SYSPROC.ENV_GET_SYS_INFO()) AS System_Info GO]]></description>
		<link>http://www.rohand.com/2009/db2-system-properties/</link>
			</item>
	<item>
		<title>How to Create a Junction in Windows 7</title>
		<description><![CDATA[Create a junction in Windows 7 using the MKLINK command. mklink /j source-path target-path As an example, create a junction called C:\Volatile that resides on the S: drive. mklink /j C:\Volatile S:\Volatile]]></description>
		<link>http://www.rohand.com/2009/how-to-create-a-junction-in-windows-7/</link>
			</item>
	<item>
		<title>First Post</title>
		<description><![CDATA[This is the DePo Skinny theme and I really like it. Update: Now replaced with Thematic. Update: The theme used by Bret Taylor&#8217;s blog is my favorite. Update: Now using Hybrid Update: Now using BareCity]]></description>
		<link>http://www.rohand.com/2009/first-post/</link>
			</item>
</channel>
</rss>
