http://sqlblogcasts.com/blogs/piotr_rodak/default.aspxif datepart(dw, getdate()) in (6, 7)<br /> <b>use pubs</b>; enCommunityServer 2007.1 (Build: 20917.1142)http://sqlblogcasts.com/blogs/piotr_rodak/archive/2010/05/24/good-practices-database-programming-unit-testing.aspx#14385Mon, 14 Jun 2010 18:32:14 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:14385TrackBack<img src="http://sqlblogcasts.com/aggbug.aspx?PostID=14385" width="1" height="1">http://sqlblogcasts.com/blogs/piotr_rodak/archive/2010/05/24/good-practices-database-programming-unit-testing.aspx#14384Mon, 14 Jun 2010 18:32:06 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:14384TrackBack<img src="http://sqlblogcasts.com/aggbug.aspx?PostID=14384" width="1" height="1">http://sqlblogcasts.com/blogs/piotr_rodak/archive/2010/05/24/good-practices-database-programming-unit-testing.aspx#14345Mon, 07 Jun 2010 17:49:38 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:14345Database testing links « Michael Baylon's blog<p>Pingback from &nbsp;Database testing links &amp;laquo; &nbsp;Michael Baylon&amp;#039;s blog</p> <img src="http://sqlblogcasts.com/aggbug.aspx?PostID=14345" width="1" height="1">http://sqlblogcasts.com/blogs/piotr_rodak/archive/2010/05/11/the-penultimate-audit-trigger.aspx#14300Sat, 22 May 2010 15:13:00 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:14300COLUMNS_UPDATED() for audit triggers - Piotr Rodak<p>Pingback from &nbsp;COLUMNS_UPDATED() for audit triggers - Piotr Rodak</p> <img src="http://sqlblogcasts.com/aggbug.aspx?PostID=14300" width="1" height="1">http://sqlblogcasts.com/blogs/piotr_rodak/archive/2010/05/11/the-penultimate-audit-trigger.aspx#13568Tue, 11 May 2010 14:03:32 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:13568Visual Studio 2005 and SQL Server problem? | BingSite<p>Pingback from &nbsp;Visual Studio 2005 and SQL Server problem? | BingSite</p> <img src="http://sqlblogcasts.com/aggbug.aspx?PostID=13568" width="1" height="1">http://sqlblogcasts.com/blogs/piotr_rodak/archive/2010/04/28/columns-updated.aspx#13563Mon, 10 May 2010 23:28:58 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:13563Piotr Rodak<p>So, it’s time to see what I came up with after some time of playing with COLUMNS_UPDATED() and bitmasks</p> <img src="http://sqlblogcasts.com/aggbug.aspx?PostID=13563" width="1" height="1">http://sqlblogcasts.com/blogs/piotr_rodak/archive/2010/04/28/columns-updated.aspx#13522Fri, 30 Apr 2010 01:08:07 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:13522Twitter Trackbacks for COLUMNS_UPDATED() for audit triggers - Piotr Rodak [sqlblogcasts.com] on Topsy.com<p>Pingback from &nbsp;Twitter Trackbacks for &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COLUMNS_UPDATED() for audit triggers - Piotr Rodak &nbsp; &nbsp; &nbsp; &nbsp; [sqlblogcasts.com] &nbsp; &nbsp; &nbsp; &nbsp;on Topsy.com</p> <img src="http://sqlblogcasts.com/aggbug.aspx?PostID=13522" width="1" height="1">http://sqlblogcasts.com/blogs/piotr_rodak/archive/2008/11/09/numbers-table.aspx#13516Wed, 28 Apr 2010 22:27:48 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:13516Piotr Rodak<p>In SQL Server 2005, triggers are pretty much the only option if you want to audit changes to a table</p> <img src="http://sqlblogcasts.com/aggbug.aspx?PostID=13516" width="1" height="1">http://sqlblogcasts.com/blogs/piotr_rodak/archive/2010/03/11/coding-standards.aspx#13304Wed, 17 Mar 2010 20:33:27 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:13304Hire VB Developers | Product Reviews Article Directory<p>Pingback from &nbsp;Hire VB Developers | Product Reviews Article Directory</p> <img src="http://sqlblogcasts.com/aggbug.aspx?PostID=13304" width="1" height="1">http://sqlblogcasts.com/blogs/piotr_rodak/archive/2010/03/11/coding-standards.aspx#13291Tue, 16 Mar 2010 04:50:12 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:13291Hire VB Developers - Wordpress Powered weblog, Articles news and events. - Articles Hall<p>Pingback from &nbsp;Hire VB Developers - Wordpress Powered weblog, Articles news and events. - Articles Hall</p> <img src="http://sqlblogcasts.com/aggbug.aspx?PostID=13291" width="1" height="1">