Articles by Darek Danielewski (Articles: 6, Tip/Tricks: 12)

Articles: 6, Tip/Tricks: 12

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating: 4.83

Database Development
SQL Server	Thread-safety with SQL Server 2008 16 Jun 2013 Updated: 16 Jun 2013 Rating: 4.86/5 Votes: 6 Popularity: 3.78 Licence: CPOL Views: 33,614 Bookmarked: 15 Downloaded: 0 Please Sign up or sign in to vote. The subject of thread safety is often overlooked by even experienced developers. When designing an application or service to be utilized by multiple internal and external threads, one must account for potential issues arising from concurrent access to shared data.
	Passing Table Valued Parameters with Dapper 31 Oct 2014 Updated: 31 Oct 2014 Rating: 4.90/5 Votes: 9 Popularity: 4.68 Licence: CPOL Views: 120,841 Bookmarked: 14 Downloaded: 0 Please Sign up or sign in to vote. Up until version 1.26 of Dapper, it was not possible to utilize TVP.
Desktop Programming
WPF	Concurrent Sortable Collections and AOP 19 Nov 2012 Updated: 20 Nov 2012 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 18,002 Bookmarked: 9 Downloaded: 97 Please Sign up or sign in to vote. How to use Aspect Oriented Programming Toolkits in a dynamic WPF application
Programming Languages
C#	Using T4 templates for Finite State Machine generation 25 Sep 2013 Updated: 25 Sep 2013 Rating: 4.67/5 Votes: 2 Popularity: 1.40 Licence: CPOL Views: 16,573 Bookmarked: 19 Downloaded: 4 Please Sign up or sign in to vote. Writing multiple finite states machines code is a tedious and boring task. With a little help from T4 Template, this process can be automated.
	Leveraging MemoryCache and AOP for Expensive Calls 15 Nov 2012 Updated: 20 May 2013 Rating: 5.00/5 Votes: 5 Popularity: 3.49 Licence: CPOL Views: 25,051 Bookmarked: 23 Downloaded: 0 Please Sign up or sign in to vote. How to use AOP and System.Runtime.Caching.MemoryCache to improve application performance
Security
Encryption	Extending IDbConnection and getting help from Dapper for tedious tasks 27 Mar 2014 Updated: 31 Mar 2014 Rating: 4.53/5 Votes: 7 Popularity: 3.83 Licence: CPOL Views: 40,524 Bookmarked: 14 Downloaded: 0 Please Sign up or sign in to vote. With a little help from C# Extensions and Dapper, it is easy to streamline coded database interaction, even with encrypted columns

Average blogs rating:

No blogs have been submitted.

Average tips rating: 4.52

Database Development
SQL Server	Dequeue workitems using MERGE [Tip/Trick] 25 Feb 2014 Updated: 25 Feb 2014 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: CPOL Views: 13,210 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. This article demonstrates how to safely dequeue items from a shared table
	Deleting Users With No Database Mappings [Tip/Trick] 16 Jan 2016 Updated: 16 Jan 2016 Rating: 4.47/5 Votes: 4 Popularity: 2.69 Licence: CPOL Views: 6,390 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. A small script to remove old user accounts
	Using Pipeline from Parallel Extension Extras [Tip/Trick] 2 Oct 2013 Updated: 2 Oct 2013 Rating: 4.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 7,520 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. The combined use of Pipeline and NullObject patterns greatly simplifies data processing
	Passing NULL and table values to a parametrized SQL query [Tip/Trick] 4 Jun 2013 Updated: 4 Jun 2013 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 19,062 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. The importance of using parameterized SQL queries has been well established, but passing table values or occassional NULL values has always been a problem ... until now ...
Programming Languages
ASM	Dynamically send WCF endpoint in Silverlight [Tip/Trick] 15 Aug 2011 Updated: 15 Aug 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 5,490 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. If you are using ChannelFactory to access your WCF service here is another solution: http://pocorath.blogspot.com/2011/08/servicereferencesclientconfig.html[^].
C#	Monostate pattern [Tip/Trick] 4 Dec 2013 Updated: 5 Dec 2013 Rating: 4.94/5 Votes: 7 Popularity: 4.17 Licence: CPOL Views: 33,995 Bookmarked: 15 Downloaded: 0 Please Sign up or sign in to vote. An interesting variation on the Singleton pattern
	Sometimes, We Overlook the Simplest Things [Tip/Trick] 31 May 2015 Updated: 31 May 2015 Rating: 4.29/5 Votes: 16 Popularity: 5.05 Licence: CPOL Views: 18,452 Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. How dangerous and inefficient exception-based programming style can be?
	Using AOP to provide default values for non-value-type parameters [Tip/Trick] 11 Sep 2013 Updated: 11 Sep 2013 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 7,130 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. How to apply default values to non-value-types at runtime using Aspect Oriented Programming.
	OperationResult Class in Support of Multiple Return Values from a Method [Tip/Trick] 12 Dec 2015 Updated: 14 Dec 2015 Rating: 5.00/5 Votes: 18 Popularity: 6.28 Licence: CPOL Views: 30,573 Bookmarked: 14 Downloaded: 0 Please Sign up or sign in to vote. Sometimes, you just must return multiple values from a method. Instead of specifying out or passing arguments by reference, consider an OperationResult class.
	Embedding an Image Inside an HTML Email [Tip/Trick] 2 Dec 2013 Updated: 3 Dec 2013 Rating: 5.00/5 Votes: 7 Popularity: 4.23 Licence: CPOL Views: 42,912 Bookmarked: 10 Downloaded: 0 Please Sign up or sign in to vote. Clear guide on how to embed an image inside an HTML email
	Transaction handling with AOP [Tip/Trick] 2 Apr 2013 Updated: 3 Apr 2013 Rating: 4.00/5 Votes: 2 Popularity: 1.20 Licence: CPOL Views: 15,120 Bookmarked: 7 Downloaded: 0 Please Sign up or sign in to vote. How to create and apply TransactionScope using AOP.
SQL	Using Parallel Extension Extras with SqlConnections [Tip/Trick] 1 Oct 2013 Updated: 1 Oct 2013 Rating: 4.00/5 Votes: 2 Popularity: 1.20 Licence: CPOL Views: 20,172 Bookmarked: 9 Downloaded: 0 Please Sign up or sign in to vote. Once in a while comes a tiny NuGet package which makes your code so much more elegant ... Parallel Extension Extras is one such package

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

Darek Danielewski

Architect BI Software, Inc.

United States

A seasoned IT Professional. Programming and data processing artist. Contributor to StackOverflow.

Articles by Darek Danielewski (Articles: 6, Tip/Tricks: 12)

Articles: 6, Tip/Tricks: 12

Average article rating: 4.83

Database Development

Desktop Programming