<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://sqlblogcasts.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Piotr Rodak - All Comments</title><link>http://sqlblogcasts.com/blogs/piotr_rodak/default.aspx</link><description>if datepart(dw, getdate()) in (6, 7)&lt;br /&gt;
	&lt;b&gt;use pubs&lt;/b&gt;;

</description><dc:language>en</dc:language><generator>CommunityServer 2007.1 (Build: 20917.1142)</generator><item><title>Hire VB Developers | Product Reviews Article Directory</title><link>http://sqlblogcasts.com/blogs/piotr_rodak/archive/2010/03/11/coding-standards.aspx#13304</link><pubDate>Wed, 17 Mar 2010 20:33:27 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:13304</guid><dc:creator>Hire VB Developers | Product Reviews Article Directory</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;Hire VB Developers | Product Reviews Article Directory&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=13304" width="1" height="1"&gt;</description></item><item><title>Hire VB Developers - Wordpress Powered weblog, Articles news and events. - Articles Hall</title><link>http://sqlblogcasts.com/blogs/piotr_rodak/archive/2010/03/11/coding-standards.aspx#13291</link><pubDate>Tue, 16 Mar 2010 04:50:12 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:13291</guid><dc:creator>Hire VB Developers - Wordpress Powered weblog, Articles news and events. - Articles Hall</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;Hire VB Developers - Wordpress Powered weblog, Articles news and events. - Articles Hall&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=13291" width="1" height="1"&gt;</description></item><item><title>Hire VB Developers | Product Reviews Article Directory</title><link>http://sqlblogcasts.com/blogs/piotr_rodak/archive/2010/03/11/coding-standards.aspx#13263</link><pubDate>Fri, 12 Mar 2010 06:25:54 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:13263</guid><dc:creator>Hire VB Developers | Product Reviews Article Directory</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;Hire VB Developers | Product Reviews Article Directory&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=13263" width="1" height="1"&gt;</description></item><item><title>re: Kayleigh</title><link>http://sqlblogcasts.com/blogs/piotr_rodak/archive/2010/02/22/kayleigh.aspx#13128</link><pubDate>Tue, 23 Feb 2010 12:45:35 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:13128</guid><dc:creator>StevenWhite</dc:creator><description>&lt;p&gt;Another 'Market Square Hero' :)&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=13128" width="1" height="1"&gt;</description></item><item><title>http://stackoverflow.com/questions/2275946/t-sql-insert-or-update/2277595</title><link>http://sqlblogcasts.com/blogs/piotr_rodak/archive/2010/01/04/updlock-holdlock-and-deadlocks.aspx#13104</link><pubDate>Thu, 18 Feb 2010 14:37:30 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:13104</guid><dc:creator>TrackBack</dc:creator><description>&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=13104" width="1" height="1"&gt;</description></item><item><title>linked servers query | SERVERS</title><link>http://sqlblogcasts.com/blogs/piotr_rodak/archive/2009/11/22/data-access-setting-on-local-server.aspx#12993</link><pubDate>Sun, 07 Feb 2010 08:30:10 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:12993</guid><dc:creator>linked servers query | SERVERS</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;linked servers query | SERVERS&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=12993" width="1" height="1"&gt;</description></item><item><title>re: relative query cost not accurate when using set rowcount</title><link>http://sqlblogcasts.com/blogs/piotr_rodak/archive/2010/01/27/relative-query-cost-not-accurate-when-using-set-rowcount.aspx#12946</link><pubDate>Fri, 29 Jan 2010 00:40:33 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:12946</guid><dc:creator>brad_schulz</dc:creator><description>&lt;p&gt;Informative post...&lt;/p&gt;
&lt;p&gt;Of course, one should get out of the habit of using SET ROWCOUNT anyway, since it is a feature that is set to be deprecated in future versions.&lt;/p&gt;
&lt;p&gt;(Love the title of your blog, BTW... use pubs... LOL).&lt;/p&gt;
&lt;p&gt;--Brad&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=12946" width="1" height="1"&gt;</description></item><item><title>updating column with a random value - Piotr Rodak Mobile</title><link>http://sqlblogcasts.com/blogs/piotr_rodak/archive/2010/01/13/updating-column-with-a-random-value.aspx#12845</link><pubDate>Thu, 14 Jan 2010 00:41:01 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:12845</guid><dc:creator>updating column with a random value - Piotr Rodak Mobile</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;updating column with a random value - Piotr Rodak Mobile&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=12845" width="1" height="1"&gt;</description></item><item><title>http://sqlblog.com/blogs/linchi_shea/archive/2009/12/18/the-transact-sql-prime-directive-a-bad-example.aspx</title><link>http://sqlblogcasts.com/blogs/piotr_rodak/archive/2009/11/22/data-access-setting-on-local-server.aspx#12793</link><pubDate>Tue, 05 Jan 2010 14:27:00 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:12793</guid><dc:creator>TrackBack</dc:creator><description>&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=12793" width="1" height="1"&gt;</description></item><item><title>http://stackoverflow.com/questions/629677/sql-server-not-configured-for-data-access</title><link>http://sqlblogcasts.com/blogs/piotr_rodak/archive/2009/11/22/data-access-setting-on-local-server.aspx#12792</link><pubDate>Tue, 05 Jan 2010 14:26:53 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:12792</guid><dc:creator>TrackBack</dc:creator><description>&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=12792" width="1" height="1"&gt;</description></item><item><title>re: Happy New Year</title><link>http://sqlblogcasts.com/blogs/piotr_rodak/archive/2009/12/30/happy-new-year.aspx#12775</link><pubDate>Mon, 04 Jan 2010 21:59:24 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:12775</guid><dc:creator>Piotr Rodak</dc:creator><description>&lt;p&gt;That's a good quote :)&lt;/p&gt;
&lt;p&gt;On the other hand it is surprising how many people DO NOT know regular expressions what results in wicked code.&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=12775" width="1" height="1"&gt;</description></item><item><title>re: Happy New Year</title><link>http://sqlblogcasts.com/blogs/piotr_rodak/archive/2009/12/30/happy-new-year.aspx#12770</link><pubDate>Mon, 04 Jan 2010 09:44:43 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:12770</guid><dc:creator>DavidWimbush</dc:creator><description>&lt;p&gt;Czesc Piotrek,&lt;/p&gt;
&lt;p&gt;RegEx is indeed a powerful thing but it's a bit write-only as languages go, which is a real shame. I don't know if you know that classic quote by Jamie Zawinski:&lt;/p&gt;
&lt;p&gt;Some people, when confronted with a problem, think “I know, I'll use regular expressions.” &amp;nbsp; Now they have two problems.&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=12770" width="1" height="1"&gt;</description></item><item><title>http://sqlblog.com/blogs/linchi_shea/archive/2009/12/18/the-transact-sql-prime-directive-a-bad-example.aspx</title><link>http://sqlblogcasts.com/blogs/piotr_rodak/archive/2009/11/22/data-access-setting-on-local-server.aspx#12745</link><pubDate>Sat, 19 Dec 2009 15:21:42 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:12745</guid><dc:creator>TrackBack</dc:creator><description>&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=12745" width="1" height="1"&gt;</description></item><item><title>re: concurrency control explained</title><link>http://sqlblogcasts.com/blogs/piotr_rodak/archive/2007/11/19/concurrency-control-explained.aspx#12677</link><pubDate>Thu, 03 Dec 2009 15:25:18 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:12677</guid><dc:creator>gurucb</dc:creator><description>&lt;p&gt;We know it is pretty ole to comment upon, but if you have time please review it and let us know your thoughts.&lt;/p&gt;
&lt;p&gt;&lt;a rel="nofollow" target="_new" href="http://www.sqlfundas.com/post/2009/11/26/Database-Lock-Block-Dead-Lock-e28093-What-is-it-Why-is-it-What-to-do-about-it-e28093-Part-1.aspx"&gt;www.sqlfundas.com/.../Database-Lock-Block-Dead-Lock-e28093-What-is-it-Why-is-it-What-to-do-about-it-e28093-Part-1.aspx&lt;/a&gt;&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=12677" width="1" height="1"&gt;</description></item><item><title>SSIS insert bulk of data into remote table with trigger  &amp;laquo;  [Business Intelligence].[ALL]</title><link>http://sqlblogcasts.com/blogs/piotr_rodak/archive/2009/10/10/triggers-and-bulk-insert-in-ssis.aspx#12486</link><pubDate>Wed, 04 Nov 2009 09:53:23 GMT</pubDate><guid isPermaLink="false">fa8c4e8e-46a3-4193-8264-2c1a9cb3475d:12486</guid><dc:creator>SSIS insert bulk of data into remote table with trigger  «  [Business Intelligence].[ALL]</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;SSIS insert bulk of data into remote table with trigger &amp;nbsp;&amp;amp;laquo; &amp;nbsp;[Business Intelligence].[ALL]&lt;/p&gt;
&lt;img src="http://sqlblogcasts.com/aggbug.aspx?PostID=12486" width="1" height="1"&gt;</description></item></channel></rss>