<?xml version="1.0" encoding="UTF-8"?><rss version="0.92">
<channel>
	<title>SQL Blog of Zach Stagers</title>
	<link>http://scratchbox.co.uk</link>
	<description>www.scratchbox.co.uk</description>
	<lastBuildDate>Tue, 09 Aug 2011 22:03:33 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	<!-- generator="WordPress/3.2.1" -->

	<item>
		<title>MCITP: Database Developer 2008</title>
		<description><![CDATA[Following on from my previous post, I took the next exam (70-451) in the Database Development 2008 MCITP series on the 2nd of August and passed with 93.5%! &#160; &#160; This means that I am now a &#8220;Technology Specialist in SQL Server Developement (2008)&#8221; and a &#8220;Microsoft Certified IT Professional in Database Development (2008)&#8221;. The [...]]]></description>
		<link>http://scratchbox.co.uk/2011/08/mcitp-database-developer-2008/</link>
			</item>
	<item>
		<title>TS: Microsoft SQL Server 2008, Database Development (70-433)</title>
		<description><![CDATA[Yesterday, I took the 70-433 Microsoft exam, and I&#8217;m pleased to announce that I passed with 92% on my first attempt! This gives me the certification of Microsoft Certified Technology Specialist in SQL Server 2008 Database Development. I&#8217;ve been meaning to take one of these exams for a long time now, and I&#8217;ve finally managed [...]]]></description>
		<link>http://scratchbox.co.uk/2011/06/ts-microsoft-sql-server-2008-database-development-70-433/</link>
			</item>
	<item>
		<title>Moving Database Objects between Schemas the quick way</title>
		<description><![CDATA[I&#8217;ve been doing a bit database re-structuring lately, and I came across a nice and quick way to move database objects between schemas. Instead of dropping and recreating the object in the schema you require it to be in &#8211; simply execute the below: The above example will move the object &#8220;dbo.Sproc&#8221; into the &#8220;MySchema&#8221; [...]]]></description>
		<link>http://scratchbox.co.uk/2011/06/moving-database-objects-between-schemas-the-quick-way/</link>
			</item>
	<item>
		<title>Returning Tabular Data as XML with FOR XML PATH and Nested XML Queries</title>
		<description><![CDATA[FOR XML PATH is the favorite amongst most Database Developers due to its ease of use, and the fact that you can build almost any XML structure with it. I&#8217;ll also be discusing nested XML Queries in this post, which kind of goes hand in hand with FOR XML PATH. More on this later. I&#8217;ll [...]]]></description>
		<link>http://scratchbox.co.uk/2011/05/returning-tabular-data-as-xml-with-for-xml-path-and-nested-xml-queries/</link>
			</item>
	<item>
		<title>Returning Tabular Data as XML with FOR XML EXPLICIT</title>
		<description><![CDATA[FOR XML EXPLICIT can be a little awkward to use to say the least, but it has it uses. The good thing about EXPLICIT, is that you can mold it into almost any structure you like. I actually found that reviewing the results as tabular data is what really helped me understand what the FOR [...]]]></description>
		<link>http://scratchbox.co.uk/2011/04/returning-tabular-data-as-xml-with-for-xml-explicit/</link>
			</item>
	<item>
		<title>Using BULK INSERT</title>
		<description><![CDATA[Using BULK INSERT is a nice and efficient way to, well, do a bulk insert! It&#8217;s can be good in situations where you have many, many records to insert &#8211; to many to fit into Excel, for example. To do a BULK INSERT, simply upload your file to the server that holds the database you&#8217;re [...]]]></description>
		<link>http://scratchbox.co.uk/2011/04/using-bulk-insert/</link>
			</item>
	<item>
		<title>Returning Tabular Data as XML with FOR XML AUTO</title>
		<description><![CDATA[About a week ago I posted on FOR XML RAW, this time it&#8217;s FOR XML AUTO&#8216;s turn. The two are actioned via very similar syntax, but operate slightly differently. Auto is probably named &#8220;Auto&#8221; because it performs a lot of the XML node naming for you. There are also a couple of other differences which [...]]]></description>
		<link>http://scratchbox.co.uk/2011/04/returning-tabular-data-as-xml-with-for-xml-auto/</link>
			</item>
	<item>
		<title>Working with Optional Parameters in Stored Procedures</title>
		<description><![CDATA[Using optional parameters within a stored procedure is a good way to give the caller a little more control over what is being returned. For example, if you were writing a stored procedure which was going to be used by a reporting system, and within the system, a user will have the ability to narrow [...]]]></description>
		<link>http://scratchbox.co.uk/2011/04/working-with-optional-parameters-in-stored-procedures/</link>
			</item>
	<item>
		<title>Finding a list of user defined tables with schemas within a SQL Database</title>
		<description><![CDATA[A couple of months ago I did a blog post on Finding a list of user defined tables within a SQL Database. Well, today I&#8217;ve improved upon that example to include the schema that the table belongs too as well. The reason I needed a list of tables and the schemas they belong to in [...]]]></description>
		<link>http://scratchbox.co.uk/2011/04/finding-a-list-of-user-defined-tables-with-schemas-within-a-sql-database-2/</link>
			</item>
	<item>
		<title>SQL LIKE ESCAPE Character</title>
		<description><![CDATA[If you need to do a search on a field for a character that&#8217;s used by the LIKE syntax, the % for example, then you can specify an ESCAPE Character to allow you search for the symbol. To do this, simply specify your escape character, typically a value which you know won&#8217;t be returned in [...]]]></description>
		<link>http://scratchbox.co.uk/2011/04/sql-like-escape-character/</link>
			</item>
</channel>
</rss>

<!-- Performance optimized by W3 Total Cache. Learn more: http://www.w3-edge.com/wordpress-plugins/

Served from: scratchbox.co.uk @ 2012-02-23 08:10:43 -->
